topic Re: How to import the file into SAS (from local systme to server) in SAS Programming

How to import the file into SAS (from local systme to server)

vThanu — Thu, 28 Mar 2019 07:47:07 GMT

I want to read an excel file into SAS environment (Server) which is saved on my windows desktop (using proc step or data step).

Can it be possible? how?

Thanks in advance...

Re: How to import the file into SAS (from local systme to server)

Kurt_Bremser — Thu, 28 Mar 2019 07:55:45 GMT

You have to save any data that you want to import into SAS with SAS code only (no use of Enterprise Guide import wizards) to a location that is "visible" from the context of the SAS session.

You can do that by

using a shared location mounted both on your desktop and server
setting up a share on your desktop that is accessible by the server
copying the file to the server with a tool like WinSCP

After the file is visible, you can either use proc import or libname excel.

Note, though, that the use of the Excel file format for data interchange is advised against, as you force SAS to make guesses about column attributes; it is recommended to save spreadsheets to text files and read those with a data step, where you have control.

Re: How to import the file into SAS (from local systme to server)

Oligolas — Thu, 28 Mar 2019 07:56:12 GMT

Yes it's possible, did you try the forum's search functionality?

https://communities.sas.com/t5/SAS-Programming/Help-with-import-excel-file/m-p/545669/highlight/true#M150999

Re: How to import the file into SAS (from local systme to server)

Patrick — Thu, 28 Mar 2019 08:04:35 GMT

@Kurt_Bremser "no use of Enterprise Guide import wizards"

I thought the SAS EG import wizard uses client side .net to read the Excel and then uploads the data to the server for further processing - or you select in one of the Wizard windows to include the data and then EG creates code with data included.

Re: How to import the file into SAS (from local systme to server)

Kurt_Bremser — Thu, 28 Mar 2019 08:14:05 GMT

Yes, the conversion from Excel to an intermediate text which is copied to the server happens with help of MS.

But from the OP, I take it that a solution without EG interaction is wanted.

Re: How to import the file into SAS (from local systme to server)

Patrick — Thu, 28 Mar 2019 08:34:16 GMT

@vThanu

If you've got SAS Enterprise Guide and this is a one off task then use the SAS Import Wizard (File/Import) to read the data from Excel. That's by far the quickest way to do things for simple Excel spreadsheets.

If you need a repeatable and automated solution which also can execute without the SAS EG client then everything @Kurt_Bremser already wrote.