PROC EXPORT with PCFILES Service

[PTD_SAS]

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.

[Kurt_Bremser]

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)

[PTD_SAS]

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!

[SASKiwi]

Here's a simple test:

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

proc report data = sashelp.class nowd missing;

run;

ods tagsets.excelxp close;

[PTD_SAS]

Thanks!

[Reeza]

Does it run fine in batch under your own account?

[PTD_SAS]

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.

[Kurt_Bremser]

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

[PTD_SAS]

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