topic Re: Import ';' delimited file from URL in SAS Programming

Import ';' delimited file from URL

avaslef — Mon, 25 Oct 2021 17:16:21 GMT

I am able to import the file but am struggling to get specify the delimiter to a semicolon (;).

filename stdata temp;
proc http
	url="https://www4.stat.ncsu.edu/~online/datasets/StudentData.txt"
	out=stdata;
quit;

proc import datafile=stdata
	out=homework.StudentData
	dbms=dlm
	delimiter=';'
	replace;
run;

proc print data=homework.studentdata;
run;

Re: Import ';' delimited file from URL

Kurt_Bremser — Mon, 25 Oct 2021 17:19:54 GMT

DELIMITER= has to be its own statement.

Re: Import ';' delimited file from URL

Kurt_Bremser — Mon, 25 Oct 2021 17:25:35 GMT

PS with a text file, I would never use IMPORT. Write your own data step according to the documentation you received with the file.

Re: Import ';' delimited file from URL

avaslef — Mon, 25 Oct 2021 17:25:45 GMT

Thank you!