I need to group values in  variable - and Arrive at the following Output Input - Header 1 Header 2 Header 3 Sub 1 101 102 Sub 1 124 125 Sub 1 175 176 Sub 2 201 202 Sub 2 275 276 Sub 2 295 296 Output - Header 1 Header 2 Sub 1 101, 102, 124, 125, 175, 176 Sub 2 201, 202, 275, 276, 295, 296 Thanks in Advance. ... View more

Hi All, I am trying to schedule a SAS task to run automatically every day, using the task scheduler. I was able to do this comfortably in windows XP.The first step in task scheduler in XP is to locate the SAS software and there by telling the task scheduler where to execute the program. How ever the setuo is completely changed in windows 7. Can any one help me in doing this. thanks in advance. ... View more

I have a situation where subject is receiving drug twice a day. I have to identify subjects missing 4 or more consecutive doses. I am using the following code - where USUBJID is subject number and EXDT is date. However with d >= 2 it is listing even if the subject missses 2 doses on the same day. IF I use d >2 it does not list subjects if 4 consecutive doses are missed in 3 days. Any suggestions are appreciated Thanks in advance. data miss2; f=0; do until(last.USUBJID); set EX_BID; by USUBJID; d = ifn(not first.USUBJID,dif(EXDT),0); if d ge 2 then do; output; f=1; end; end; run; ... View more

Can any one please help me how to generate the final sas dataset name in uppercase. ... View more

I have posted a query earlier regarding printing all the datasets in a library and I got some good response. I especially liked the post by Flip data _null_; set sashelp.vmember( where = (libname = upcase('&libname') and memtype = 'DATA')) end = eof; if _n_ = 1 then call execute("ODS Listing Close; ods rtf nogtitle file='C:\report1.rtf' style=profile ;"); call execute("proc print data = " || memname || " noobs; run;"); if EOF then call execute("ods rtf close;"); run; since it takes less time than the one I am using. Now my question is can we customize the order in which the datasets are printed. By default they are printed in alphabetical order. I want to specify a sort order. Thnx ... View more