BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
H
Pyrite | Level 9 H
Pyrite | Level 9

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

File name and location:

http://www.unc.edu/~mfunk/dr/v1dot1/sample_data.sas7bdat

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

data sample_data;

     set 'http://www.unc.edu/~mfunk/dr/v1dot1/sample_data.sas77bdat';

run;

Any help appreciated - thanks

H L

1 ACCEPTED SOLUTION

Accepted Solutions
BrunoMueller
SAS Super FREQ

Hi

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;

View solution in original post

2 REPLIES 2
BrunoMueller
SAS Super FREQ

Hi

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;
H
Pyrite | Level 9 H
Pyrite | Level 9

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1135 views
  • 1 like
  • 2 in conversation