1. Load CSV file to a table
proc import datafile="C:\temp\test.csv"
out=work.test
dbms=csv
replace;
getnames=yes; //get column names from the first row
run;
2. Load any delimited file
proc import datafile="C:\temp\test.psv"
out=mydata
dbms=dlm
replace;
delimiter='|';
getnames=yes;
run;