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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.