topic Re: PROC EXPORT with PCFILES Service in SAS Procedures

PROC EXPORT with PCFILES Service

PTD_SAS — Wed, 18 Feb 2015 05:15:55 GMT

I run 64 bit SAS 9.4 M2 on Windows 7 and using PROC EXPORT with EXCELCS engine to export to 32 bit Excel. SAS PC Files service is installed. The workbook I export to has multiple sheets and has xlsb format. I have installed the correct version of PC Files Server to match the bits and SAS version. The problem I have is everything runs fine under my own account but the program hangs without errors under another account we have to run SAS batch jobs. Both accounts have administrator privileges. It's very puzzling, it looks like the cause may be some differences in the account properties/attributes? Would anyone be able to help?

Thanks.

Re: PROC EXPORT with PCFILES Service

Kurt_Bremser — Wed, 18 Feb 2015 07:32:58 GMT

Try to use ODS TAGSETS.EXCELXP to create Excel-readable .xml files.

- no 32/64 bit problems

- only Base SAS needed (no PC Files Server)

- will run on ANY platform

This should alleviate all problems arising from different configurations/privileges of the accounts involved

On top of this:

- can do report formatting (PROC EXPORT only delivers data)

Re: PROC EXPORT with PCFILES Service

PTD_SAS — Wed, 18 Feb 2015 23:30:50 GMT

Kurt,

Thanks for that. Would you have any example code using tagsets for Excel? Just in case, because I'm not familiar with this. Thanks!

Re: PROC EXPORT with PCFILES Service

SASKiwi — Wed, 18 Feb 2015 23:40:31 GMT

Here's a simple test:

ods tagsets.excelxp file="\MyDir\class.xml"

proc report data = sashelp.class nowd missing;

run;

ods tagsets.excelxp close;

Re: PROC EXPORT with PCFILES Service

PTD_SAS — Wed, 18 Feb 2015 23:47:03 GMT

Thanks!

Re: PROC EXPORT with PCFILES Service

Reeza — Thu, 19 Feb 2015 02:26:26 GMT

Does it run fine in batch under your own account?

Re: PROC EXPORT with PCFILES Service

PTD_SAS — Thu, 19 Feb 2015 02:36:51 GMT

Yes, it runs fine under my own account in batch or interactively. It's the other account we have specifically for batch jobs that is giving the problem. The workbook has quite a few sheets but I wouldnt think that would be a problem.

Re: PROC EXPORT with PCFILES Service

Kurt_Bremser — Thu, 19 Feb 2015 06:25:44 GMT

It may be that the other account has problems accessing the PC Files server because of some policies within Windows.

Re: PROC EXPORT with PCFILES Service

PTD_SAS — Sun, 22 Feb 2015 21:41:45 GMT

Yes, I think this is the most likely cause. I asked our IT department to compare the properties of the 2 accounts.