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;
DELIMITER= has to be its own statement.
DELIMITER= has to be its own statement.
PS with a text file, I would never use IMPORT. Write your own data step according to the documentation you received with the file.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.