topic data from an excel file. in SAS Programming

data from an excel file.

deentran — Sat, 27 Oct 2018 20:28:47 GMT

shahparth260 — Sat, 27 Oct 2018 05:02:28 GMT

Why you want to do manually , I think it must be some dynamic way.

Can I get sample data which I can import in my SAS ?

deentran — Sat, 27 Oct 2018 20:29:11 GMT

I don't know how to fix it simply.

singhsahab — Sat, 27 Oct 2018 06:14:10 GMT

you can import your excel file by using PROC IMPORT procedure.

just need to update filepath in %let path statement.

%let path=filepath;
proc import datafile="&path.\data.xlsx"
out=want dbms=excel replace;
run;

Shmuel — Sat, 27 Oct 2018 06:18:48 GMT

CSV stands for Comma Separated Vector.

It can be imported by SAS using either CSV engine or by DLM=",".

See proc import documentation:

Kurt_Bremser — Sat, 27 Oct 2018 06:21:16 GMT

If you need help for reading a csv file, you should post that.

Use the dsd option in the infile statement to correctly read empty (missing) columns.