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.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.