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

[Jade_SAS]

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

[ballardw]

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?

[Jade_SAS]

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

Thanks,

Jade

[Patrick]

---

@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)

[Jade_SAS]

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

Jade

[Patrick]

---

@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

[LinusH]

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.

[Jade_SAS]

Thank you both for your suggestions and feedback!

[AnnaBrown]

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