topic Re: How to output excel file quickly from SAS Server when using SAS EG? in SAS Data Management

How to output excel file quickly from SAS Server when using SAS EG?

Jade_SAS — Thu, 08 Feb 2018 02:00:15 GMT

Hi All,

I am using PC server to export excel file from server to PC( or import excel file from PC to Server), it's really slow when dealing with the big excel file. My question is whether this is an efficient way to quickly output excel file from SAS Server to PC? Thank you!

I am using SAS Server on Linux.

Another question is whether there is a way to export the SAS dataset to CSV file from SAS Server to PC? Thank you!

Jade

Re: How to output excel file quickly from SAS Server when using SAS EG?

ballardw — Thu, 08 Feb 2018 15:55:39 GMT

How big is 'big', number of variables and records.

And if the Excel is truly large, why send it to Excel in the first place?

Re: How to output excel file quickly from SAS Server when using SAS EG?

Jade_SAS — Fri, 09 Feb 2018 01:33:34 GMT

Thank you. If not excel, usually how do you provide the data to your client?

Thanks,

Jade

Re: How to output excel file quickly from SAS Server when using SAS EG?

Patrick — Fri, 09 Feb 2018 10:56:52 GMT

@Jade_SAS wrote:

Thank you. If not excel, usually how do you provide the data to your client?

Thanks,

Jade

Certainly not as Excel if not "forced" by the client. I strongly prefer textual files for data exchange (delimited files, XML, Json)

Re: How to output excel file quickly from SAS Server when using SAS EG?

Jade_SAS — Tue, 13 Feb 2018 15:54:06 GMT

Could you please share the syntax of how to output these textual files (delimited files, XML, Json) in SAS? Thank you!

Jade

Re: How to output excel file quickly from SAS Server when using SAS EG?

Patrick — Wed, 14 Feb 2018 08:36:34 GMT

@Jade_SAS wrote:

Could you please share the syntax of how to output these textual files (delimited files, XML, Json) in SAS? Thank you!

Jade

That's all fully documented. Please RTM.

Possible keywords: data step PUT statement, libname XML engine, Proc Export, Proc JSON

Re: How to output excel file quickly from SAS Server when using SAS EG?

LinusH — Wed, 14 Feb 2018 12:23:55 GMT

One must ask why you are distributing somewhat large file to client Pc's in the first place. Especially with upcoming regulation about data security and privacy (GDPR...)
It would be better if they could get interface to work directly with data on the server instead. If Excel is preferred Add in to MS Office/Office Analytics could be something to try.

Re: How to output excel file quickly from SAS Server when using SAS EG?

Jade_SAS — Fri, 02 Mar 2018 01:31:08 GMT

Thank you both for your suggestions and feedback!

Re: How to output excel file quickly from SAS Server when using SAS EG?

AnnaBrown — Fri, 02 Mar 2018 14:33:23 GMT

Hi @Jade_SAS,

I'm glad you found some useful suggestions If one of the replies was the exact solution to your problem, can you "Accept it as a solution"? Or if one was particularly helpful, feel free to "Like" it. This will help other community members who may run into the same issue know what worked.

Thanks!
Anna