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 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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