Hi all,
I am just trying to learn tagset excelxp. I am getting this error (code and error listed below). I am using SAS 9.3 .
Thanks for your help.
Regards,
Amit
Error:
NOTE: Writing TAGSETS.EXCELXP Body file: multisheet.xls
ERROR: Physical file does not exist, /rem/sas/data/test1/multisheet.xls.
ERROR: No body file. TAGSETS.EXCELXP output will not be created.
Code:
ods tagsets.excelxp file="multisheet.xls"
path="/rem/sas/data/test1/"
style=minimal;
proc sort data=sashelp.CARS out=CARS;
by Make;
run;
proc print data=CARS;
by Make;
run;
ods tagsets.excelxp close;
Hi all,
The path name was incorrect. Pointing to right path name solved the issue.
Thanks everyone for their help.
@Reeza: path option is availabel in tagsets.
@Anca: Since my sas server is in linux i need to use forward slash.
Regards,
Amit
I don't believe there is a path option in ods tagsets. You need to specify the full path of the output document in the file option instead.
I would try to define the path using back-slashes "\" instead of forward slashes "/"
ods tagsets.excelxp file="multisheet.xls"
path="\rem\sas\data\test1\"
style=minimal;
proc sort data=sashelp.CARS out=CARS;
by Make;
run;
proc print data=CARS;
by Make;
run;
ods tagsets.excelxp close;
It worked for me when I did that.
Good luck!
Anca.
Hi all,
The path name was incorrect. Pointing to right path name solved the issue.
Thanks everyone for their help.
@Reeza: path option is availabel in tagsets.
@Anca: Since my sas server is in linux i need to use forward slash.
Regards,
Amit
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.