topic Re: Help loading Excel data in Statistical Procedures

Help loading Excel data

genius99 — Tue, 10 Sep 2019 16:08:30 GMT

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

Re: Help loading Excel data

Jagadishkatam — Tue, 10 Sep 2019 16:14:20 GMT

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;

Re: Help loading Excel data

Tom — Tue, 10 Sep 2019 16:19:26 GMT

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.