data from an excel file.

[deentran]

//

[shahparth260]

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]

I don't know how to fix it simply. 

[singhsahab]

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]

CSV stands for Comma Separated Vector.

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

See proc import documentation:

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a000332605.htm

[Kurt_Bremser]

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.