topic Read Online SAS File into SAS in SAS Data Management

Read Online SAS File into SAS

Wed, 15 Jul 2015 17:45:20 GMT

It is as simple as the title, but I can't quite get it.

File name and location:

If this was not an online file, I would be looking to do the following:

data sample_data;

run;

Any help appreciated - thanks

H L

BrunoMueller — Wed, 15 Jul 2015 20:48:57 GMT

You can use Proc HTTP to get the SAS Data Set and write it directly to the WORK Library. See sample code below.

filename sample "%sysfunc(pathname(work))/sample_data.sas7bdat"; 

proc http

  method="get" 
  url= 'http://www.unc.edu/~mfunk/dr/v1dot1/sample_data.sas7bdat' 
  out=sample
;
run; 

data new;
  set sample_data;
run;

Thu, 16 Jul 2015 12:46:31 GMT

Thank you that code worked. I got close but could quite get it right.