Convert an excel file to SAS data file using %sysexec and infile statement

[r_islam56]

I am trying to convert an excel file to sas file using %sysexec and infile but it is not converting properly. For some of the rows in excel file becoming 2 rows in sas file. Please assist me in this regard. Thank you.

[ballardw]

Can you show the code you are using?

You may also need to describe the environment you operate in, operating system, SAS version and whether you are connecting to a server in SAS. Also, do you have SAS Access to PC files licensed. If you are not sure run:

Proc setinit;

run;

The Log will have a list of all licensed products.