Sorry, I had to figure out how to use the options(sheet_label...); So here is something that could work: %macro export();   ods tagsets.excelxp file = "&file_path.\my_file.xls" ;      %do i = 1 %to 4;        ods tagsets.excelxp options(sheet_label = "sheet_Name_&i" ); ;           proc print data = &dsname.;run;      %end;   ods _all_ close; %mend; %export();          So, you first initialize (or whatever the word is) the ODS TAGSETS.EXCELXP file=.... Then you use another ODS TAGSETS.EXCELXP OPTIONS(sheet_label...) for each of your export... I hope this helps. Anca. ... View more

Hi. You may want to try ods tagsets.excelxp instead of proc export. So, you could do something like this: ods tagsets.excelxp file = "....\my_file.xls";      proc print data = your_data;run; ods tagsets.excelxp close; Good luck. Anca. ... View more

Understood.:smileyblush: ... View more

sorry, for some reason I dind't read the entire question. would this work for you? proc means data = your_data sum;   var hosp:; **I am assuming that you've coded 0/1 the subject_numb that meet the criteria for being hospitalized on day 1...n;   ods output summary = sums; run; :smileyconfused: ... View more

Hi. If want you want is to count the study_numb you can do this in several ways: data want;      set have; *your data set;      by study_numb;      if first.study_numb; run; OR proc sql;      select count(distinct study_numb) as your_count      from your_data; quit; *this should display the count in your output window. I hope it helps. Anca. ... View more

Hi. Would you like something like this? data  have; input ord  desc $; cards; 0  dfkasdf 1  qewrqwe 2  werewrqe 3  etritreter 4  cvczcvzcve 5  werewrqwer 6  rqwerqwerq 7  vczcvzvzcved 8  wereruipeewr 9  dhfewrwerq 10 wrwerwerq 11 ewryteiqwe 12 rewrbnmnbz 13 wecvxcvjzc 14 ewrwerqwe 15 itititoeoe ; run; data want;   set have;   if ord in (0,12,8,4) then  grp=1;   else if ord in (1,13,9,5) then  grp=2;       else if ord in (2,14,10,6) then grp=3;       else if ord in (3,15,11,7)then  grp=4; run; proc sort data = want;by grp;run; data really_want;   set want;   by grp;   if not first.grp then grp = .; run; ?? ... View more

I agree. what does "steps of soapbox" mean? ... View more

Hi, you have posted a somehow similar question here: https://communities.sas.com/message/172117#172117 As mentioned, it may be time to look ito hiring a statistician ... View more

Hi. if you do a quick google search on your request you will see that there is some sort of code (that looks similar to yours) from Jie Cao: http://ihome.cuhk.edu.hk/~b121456/tools/FF_reg.txt Maybe it will help? Anca ... View more