Help loading Excel data

[genius99]

I am trying to load another excel file attached,

this is my code

/*Load Data*/
data Employees;
    infile "C:/Users/100355202/Desktop/employees.csv" dsd dlm = "09"x;
    input EmployeeID LastName :$20. FirstName :$20. Title :$20. Gender :$20. BirthDate :mmddyy10. 
          HireDate :mmddyy10. Address :$20. City :$20. Region :$20. PostalCode :$20. Country :$20. 
          HomePhone :$20. Extension :$20. ReportsTo;
run; 

I am getting this output

I am receiving these notes

can you help me figure out what's wrong with the code

[Jagadishkatam · Accepted solution]

Could you please try the proc import procedure as below and when you run this , you should be able to see a data step in log file.

proc import datafile="C:/Users/100355202/Desktop/employees.csv"  out=employees dbms=csv replace;
getnames=yes;
run;

[Tom]

You probably want , at a minimum, to add the TRUNCOVER option to your INFILE statement.  It is hard to tell what your CSV file actually looks like in this forum without downloading it.  The forum displays CSV files as if they are spreadsheets instead of the text files they are.  Perhaps if you attached to file using .txt as the extension instead. Or just pasted a couple of example lines into the pop-up box that appears when you click on the Insert Code icon.