Erro with tagsets.excelxp : physical file does not exist

[AmitKB]

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;

[Reeza]

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.

[AncaTilea]

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.

[AmitKB · Accepted solution]

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