rem	Report to show what has been passed/failed by dodo
rem
rem	js10 8/11/2006
rem

rem:entry title=Clone


set pause off
set recsep off
set linesize 120
set pagesize 32000
set feed off
set verify off

column clonename	heading "Clone"		format A12
column id_prep		heading "Prep ID"	format 999999
column prep_number	heading "Prep"	        format 99
column description	heading "Status"	format A25
column statusdate	heading "Date"		format A10
column operator		heading "Email"		format A5
column remark		heading "Remarks"	format A30 word_wrapped

ttitle center "Dodo Pass/Fails for &1 - Details" skip 2

select D.CLONENAME, D.ID_PREP, D.PREP_NUMBER, DSD.DESCRIPTION, DS.STATUSDATE, DS.OPERATOR, ds.remark
from DNAPREP D, DNAPREP_STATUS DS, DNAPREPSTATUSDICT DSD
where D.ID_PREP = DS.ID_PREP
AND DS.STATUS   = DSD.ID_DICT
AND D.clonename = '&1'
order by ds.statusdate;

quit;
