BookmarkSubscribeRSS Feed
V_Andy
Fluorite | Level 6
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
6 REPLIES 6
Peter_C
Rhodochrosite | Level 12
can you ftp the file to your SAS server?
Peter_C
Rhodochrosite | Level 12
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
V_Andy
Fluorite | Level 6
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)?
Peter_C
Rhodochrosite | Level 12
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
Cynthia_sas
SAS Super FREQ
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

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 2587 views
  • 0 likes
  • 3 in conversation