SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Reply
Highlighted
Regular Contributor
Posts: 190

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

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

Super User
Posts: 12,148

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

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?

Regular Contributor
Posts: 190

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

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

 

Thanks,

Jade

Respected Advisor
Posts: 4,273

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


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)

 

Regular Contributor
Posts: 190

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

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

 

Jade

Respected Advisor
Posts: 4,273

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


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

Super User
Posts: 5,607

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

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.
Data never sleeps
Ask a Question
Discussion stats
  • 6 replies
  • 164 views
  • 0 likes
  • 4 in conversation