Hello!
I am using the EG 4.2, is there a way to perform this task programatically? That is, Upload/Download SAS Data Sets using SAS Code.
Thank you!
A couple of ways come to mind.
1) if you can map the local drive from the server (or know the UNC name), you can use LIBNAMES and PROC COPY.
2) if you local administrators will enable the X command in SAS, you can use the OS copy procedures to move the files.
Doc Muhlbaier
Duke
You note the UPLOAD uses the SAS OLEDB local data provider.
Q1: Is the OLEDB provider dependent on the bitness of the SAS table? Supposing the providers are different, 32/64 and are dependent on the bitness of the SAS table...if one installs EG32 or EG64 (no local SAS) are both the SAS OLE32 and OLE64 data providers installed?
Q2: If a SAS table is loaded from one OS, Windows, to another OS, Unix...will the table be migrated so the cross-platform engine on the Unix server would need be utitlized (32 migrates to 64). (I might surmise that if the OLEDB driver is being used, the SAS table is not going through a simple binary/ftp transfer)
Thanks
Wow @RogerSpeas, you win the award for updating the oldest thread this week! (This post was originally from 2007.)
To answer your question, the OLE DB provider is not a factor during the Upload or Download. In the original post, I just wanted to point out that when you don't use the Upload task, you can still read local data set files with EG and EG will transfer those records to SAS as needed -- but it's slow. The Upload task makes the transfer a faster operation -- using a binary FTP-like transfer.
After Upload, the task checks to see if the data set encoding matches that of the SAS session and if it doesn't, it runs a DATA step to fix it up.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.