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

Reply
Learner
Posts: 1

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

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.

Super User
Posts: 11,552

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

Posted in reply to r_islam56

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.

 

 

Ask a Question
Discussion stats
  • 1 reply
  • 60 views
  • 0 likes
  • 2 in conversation