Okay, so I am trying to get the results of proc univariate to export to a microsoft excel sheet. I need multiple ones. Currently, my code is:
%macro test2;
%do i = 1 %to 13;
%let v = %scan(&varsX,&i.);
ods html file="testfile.cls";
proc univariate data=test;
var &v;
run;
ods html close;
%end;
%mend test;
%test2;
where my variables are defined in a list above. This prints out a bunch of sheets saved as ASCII files, but I want them all as excel sheets in the same workbook.
Not tested but some thing like this should get you started:
%macro test3;
ods tagsets.excelxp file="testfile.xlm" options (sheet_interval='PROC');
%do i = 1 %to 13;
%let v = %scan(&varsX,&i.);
proc univariate data=test;
var &v;
run;
%end;
ods tagsets.excelxp close;
%mend test3;
%test3;
The XML file generated can be opended in Excel.
Not tested but some thing like this should get you started:
%macro test3;
ods tagsets.excelxp file="testfile.xlm" options (sheet_interval='PROC');
%do i = 1 %to 13;
%let v = %scan(&varsX,&i.);
proc univariate data=test;
var &v;
run;
%end;
ods tagsets.excelxp close;
%mend test3;
%test3;
The XML file generated can be opended in Excel.
Great, this puts them all in the same file with sheets which is awesome.
You have any idea how to keep a title in there because when I run this version of code it drops the titles.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.