topic Re: Excel output file does not appear in Statistical Procedures

Excel output file does not appear

haoduonge — Wed, 14 Jun 2023 15:27:23 GMT

Hi all,

I run the code below, and although I can see the results in the SAS window, the Excel file that I saved is not visible. I would appreciate it if you could review the code and provide guidance on how to fix this issue.

Thank you!

libname out xlsx "C:\1.PROJECTS\XXX\test_snp.xlsx";
%macro HR(x=);
%let outputName=_PE%substr(%cmpres(&x.),1,%sysfunc(min(%length(&x.),29)));
ods graphics off;
ods output ParameterEstimates=&outputName.;
*;
proc phreg data = all;
CLASS &x (ref='0');
model FU_TIME_YRS *HCC_DEAD(0)=&x /eventcode=1;
run;
*;
ods output close;
ods graphics on;
*;
%mend HR;
*;
%HR(x=GEN1);
%HR(x=GEN2);

Re: Excel output file does not appear

ballardw — Wed, 14 Jun 2023 20:22:54 GMT

Your code does not use the Library you defined that I can see.

I'm not fond of library names like OUT as they are easy to confuse with options but I think this may have been what you intended, since you don't really state what is supposed to appear in Excel. To send output to a library the reference is always libname.datasetname (or catalog or other SAS item)

%macro HR(x=);
%let outputName=_PE%substr(%cmpres(&x.),1,%sysfunc(min(%length(&x.),29)));
ods graphics off;
ods output ParameterEstimates= out.&outputName.;
*;
proc phreg data = all;
CLASS &x (ref='0');
model FU_TIME_YRS *HCC_DEAD(0)=&x /eventcode=1;
run;
*;
ods output close;
ods graphics on;
*;
%mend HR;

Re: Excel output file does not appear

haoduonge — Wed, 14 Jun 2023 20:16:25 GMT

Thank you!