topic Erro with tagsets.excelxp : physical file does not exist in ODS and Base Reporting

Erro with tagsets.excelxp : physical file does not exist

AmitKB — Thu, 07 Feb 2013 15:19:56 GMT

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;

Re: Erro with tagsets.excelxp : physical file does not exist

Reeza — Thu, 07 Feb 2013 15:41:48 GMT

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.

Re: Erro with tagsets.excelxp : physical file does not exist

AncaTilea — Thu, 07 Feb 2013 15:51:46 GMT

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.

Re: Erro with tagsets.excelxp : physical file does not exist

AmitKB — Thu, 07 Feb 2013 17:39:27 GMT

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