Thank you for always sharing. ... View more

hahaha ... View more

Specifying "ods tagsets.excelxp options(sheet_label=' ' sheet_name=' ' sheet_interval='bygroup');" produces a result that I can only call unexpected. hahaha ... View more

This worked great for me. And instead of this: %else %do; %put Could not find &dsname ; %end; I created an empty global temp table: %else %do; /* If Oracle table does not exists, create it */ proc sql ; connect to oracle (path="hcemi" user=&hcemi_u. password="%superq(hcemi_p)" connection=shared adjust_byte_semantic_column_lengths=yes); execute (create global temporary table "%sysuserid..temptrans (mbr_id char(46))) by oracle ; quit ; %end ; Thanks! ... View more

This is great, Reeza, thanks for sharing. Q: Is there an efficient way to limit the output to the person using this tool? ... View more

Thanks so much. I'll try it tomorrow and let you know how it goes. ... View more

If I understand your question correctly, try using an out=work.xxx after the '/' to output all the rows to a SAS dataset.  change xxx to a sas ds name of your chosing. If ou want to catalogue the output dataset, change work. to a permanent library name.     Then I wrote my Proc Freq code:   proc freq data=vars; tables (&var1.)*(&var2.) /norow nocol nopercent missing out=work.xxx; run; good luck! ... View more