DATA Step, Macro, Functions and more

Import data from my local machine to a SAS Data Set using SAS Base

Reply
Occasional Contributor
Posts: 13

Import data from my local machine to a SAS Data Set using SAS Base

Hello!

I've got problems trying to import data from a data file located on my personal computer to the SAS Data set using INFILE statement.

If I use Enterprise Guide Import Wizard everything performs perfectrly. I point to my local file using EG file explorer. But the need is to perform this task using SAS Base script.

The problem is that the SAS server can not see my local computer. Thus I can't refer the local file such as: FILENAME Data 'c:\info.dat'.

Can you tell me If there is a way to make the server "see" my local computer (my local files) to allow me perform the SAS import procedure automatically by means of SAS Base script (avoiding the use of EG Import Wizard)?

Thank you for your attention
Valued Guide
Posts: 2,177

Re: Import data from my local machine to a SAS Data Set using SAS Base

can you ftp the file to your SAS server?
Occasional Contributor
Posts: 13

Re: Import data from my local machine to a SAS Data Set using SAS Base

Yes, I suppose
Valued Guide
Posts: 2,177

Re: Import data from my local machine to a SAS Data Set using SAS Base

I think the alternative of establishing an ftp service or open port - even if private, or a "shared" folder on your desktop,
so that the server can address your system, is deeply deprecated these days.

peterC
Occasional Contributor
Posts: 13

Re: Import data from my local machine to a SAS Data Set using SAS Base

Thank you peterC

Does it mean that it is uncommon situation to transfer data directly from the local machine to the SAS server and there are no standard means to perform this procedure automatically (using SAS script languages)?
Valued Guide
Posts: 2,177

Re: Import data from my local machine to a SAS Data Set using SAS Base

SAS Enterprise Guide provides a standard way to deal with the data arrangements you have.
SAS Institute provide alternative solutions for building robust "hands-free" processes when you do not wish to use SAS Enterprise Guide. You may already have these solutions available. I would suggest speaking to your SAS administrator clarifying what you need.

peterC
SAS Super FREQ
Posts: 8,869

Re: Import data from my local machine to a SAS Data Set using SAS Base

Hi:
I also believe that there was talk of an EG task that would upload local data to the SAS server. There was mention of it back in 2007 here:
http://support.sas.com/forums/thread.jspa?messageID=4818ዒ (near bottom of thread)
and here
http://support.sas.com/forums/thread.jspa?messageID=4809ዉ

cynthia
Ask a Question
Discussion stats
  • 6 replies
  • 715 views
  • 0 likes
  • 3 in conversation