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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.