We have some sas code that we %include into most of our stored processes so that users can select their preferred style of output.  It is:   data _null_; if upcase("&outtype") = "HTML" then call symput("odsdest","HTML"); if upcase("&outtype") = "PDF" then do; options orientation=landscape; rc = stpsrv_header('Content-type','application/pdf'); rc = stpsrv_header('Content-disposition','attachment; filename=temp.pdf'); call symput("odsdest","PDF"); end; if upcase("&outtype") = "EXCEL" then do; rc = stpsrv_header('Content-type','application/vnd.ms-excel;'); rc = stpsrv_header('Content-disposition','attachment; filename=temp.xls'); call symput("odsdest","tagsets.excelxp"); end; run; %let _odsdest=&odsdest; %global _ODSSTYLE; %let _ODSSTYLE=Normal; run;   The HTML and PDF output is fine, as the PROC REPORT is output with the headers and footers.  But the excel version of the output is lacking the headers and footers.  There are two parts to the report with each part being written to a separate worksheet in the file.     Why are the headers/footers not being displaced in Excel?   I tried a different set of code that does not have  call symput("odsdest","tagsets.excelxp"); That output puts the headers/footers, but it all appears on a single worksheet.   Suggestions? ... View more

I have a table (email_list) with two values: ORG_ID email_address This tables has multiple records with the same ORG_ID and unique email addresses.  I want to build a table so that I have a single row for each ORG_ID with all of the individual emails concatenated into a single value with the emails separated by a comma so that I can use that field to email the users.   I have the count of the records: proc sql;    select count(*) into :rec_count    from work.email_list; quit;   Then I want to build the list: %do j=1 to &rec_count;     if first record:         org = org_id;         email = email_address     else        if org = org_id then email = email || "', '" || email_address        else            org = org_id,            email = email_address;   ... View more

I tried to comment out a macro by placing /*  before the %macro and */ after the %mend;  But for some reason that did not work:     I actually had to place another /* before the PROC SQL statement:   Any suggestions as to why this is the case?  I had originally made my change in a text editor, not SAS EG 8.  So, the process threw errors when I ran the code. ... View more