Rick, Try this data one; set one; time2 = left(put(time,best12.)); run; proc sort data = one; by subject period; run; proc transpose data=one out=two(drop=_NAME_) prefix=HR; by subject period; id timep; idlabel time2; run; proc print data=two label noobs; run; GL. ... View more

try this week = intnx('week',date,0,'b'); GL. ... View more

Neil, try this data t1; format a $100.; input a $; datalines; 26CRDT2010-05-13-07.30.00.000000 23ABCD2010-05-13-07.30.00.000 ; run; data t2; set t1; format l 8. field $10. value $30. ; l = substr(a,1,2); field = substr(a,3,4); value = substr(a,7,l); drop a; run; proc transpose data = t2 out = t3 (drop = _name_); id field; var value; run; GL. ... View more

can you put the example of corresponding datetime value after using the formula. Message was edited by: sastech ... View more

you can use DDE to export data to specific rows and columns of existing spreadsheet. ... View more

you can try 1) subquery to create list of customer id's 2) create macro variable/s of customer id's from local sas table and use in sql query HTH ... View more

Yennie, try this. proc sql; create table temp as select a.*, fruit_desc from t1 a , t2 b; quit; data temp2; set temp; where index(upcase(compress(fruit_desc)),upcase(compress(fruit))) > 0 ; run; HTH ... View more

you can set ps and ls options before ods. ... View more

Patrick thanks for explanation. Sapper hope it works for you. ... View more

you can create trigger file at the end of the job that creates sql table and look for the trigger file to kick off sas job. ... View more