The SAS Output Delivery System and reporting techniques

Erro with tagsets.excelxp : physical file does not exist

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 99
Accepted Solution

Erro with tagsets.excelxp : physical file does not exist

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;


Accepted Solutions
Solution
‎02-07-2013 12:39 PM
Frequent Contributor
Posts: 99

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

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

View solution in original post


All Replies
Super User
Posts: 19,146

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

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.

Super Contributor
Posts: 543

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

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.

Solution
‎02-07-2013 12:39 PM
Frequent Contributor
Posts: 99

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

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 3582 views
  • 0 likes
  • 3 in conversation