BookmarkSubscribeRSS Feed
FK1
Lapis Lazuli | Level 10 FK1
Lapis Lazuli | Level 10

Hi Folks,

 

can someone elighten me, what is behind the "black box magic":

Note: In preparation for running the following code, the Import
Data wizard has used internal routines to transfer the source data
file from the local file system to SASApp. There is no SAS code
available to represent this action.

 

How does SAS technically access the remote data?

 

In my case, I am connected to the Meta Data Server using a serer-profile.

The SAS environment is on an IBM AIX based operating system.

Then, I am running the EG-Wizzard (7.15 HF8 (7.100.5.6214) (32-bit)) running from Windows 7 Enterprise N (Version 6.1, Build 7601: Service Pack 1) and I am accessing a remote Windows-based Fileserver.

 

Does SAS use the SAS/CONNECT tcpunix.scr -script?

1 REPLY 1
Kurt_Bremser
Super User

@FK1 wrote:

Hi Folks,

 

can someone elighten me, what is behind the "black box magic":

Note: In preparation for running the following code, the Import
Data wizard has used internal routines to transfer the source data
file from the local file system to SASApp. There is no SAS code
available to represent this action.

 

How does SAS technically access the remote data?

 

In my case, I am connected to the Meta Data Server using a serer-profile.

The SAS environment is on an IBM AIX based operating system.

Then, I am running the EG-Wizzard (7.15 HF8 (7.100.5.6214) (32-bit)) running from Windows 7 Enterprise N (Version 6.1, Build 7601: Service Pack 1) and I am accessing a remote Windows-based Fileserver.

 

Does SAS use the SAS/CONNECT tcpunix.scr -script?


No. That would mean you had SAS running on your desktop and on your server.

EG uses Windows-based means to access the external data source (a local DB client, ODBC, Microsoft Data Access) to read the data and converts it to a textfile, which is copied to the server. EG also creates code to read that textfile, and executes in on the server.

The code you see in the log is the one used to import the textfile, and cannot be used in any way to read the original source.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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.

SAS Training: Just a Click Away

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

Browse our catalog!

Discussion stats
  • 1 reply
  • 517 views
  • 0 likes
  • 2 in conversation