creating excel files on unix

Reply
Contributor LRN
Contributor
Posts: 57

creating excel files on unix

Hi All,

I am trying to create a excel file on my unix directory. But I am getting the following error:

ods listing close;

ods tagsets.excelxp path='/aaa/bbb/ccc' file='testfile.xml' style=mystyle;

ods tagsets.excelxp options(sheet_name='mydata');

proc report data=test; run;

ods tagsets.excelxp close;

ods listing;

Error:

physical file does not exist. c\aabbb\ccc\tstfile.html

warning: no body file. tagsets.excelxp output will not be created

Could some one help me to solve this issue.

Thank you


Respected Advisor
Posts: 3,777

Re: creating excel files on unix

This

physical file does not exist. c\aabbb\ccc\tstfile.html

with c and backslash implies you are running the program on windows.

If so you will need to use the proper file reference from a windows point of view.

If not show more of the actual code and log.

Ask a Question
Discussion stats
  • 1 reply
  • 183 views
  • 0 likes
  • 2 in conversation