DATA Step, Macro, Functions and more

SAS Import

Reply
Contributor
Posts: 70

SAS Import

Hello

 

How to import .xlsx file with multiple sheets using infile input statement.

 

Please help me with this.

 

Kafeel

Super User
Posts: 7,857

Re: SAS Import

Posted in reply to KafeelBasha

Save the sheets each as .csv, then you can use infile/input.

.XLSX can only be used with proc import or libname.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 70

Re: SAS Import

Posted in reply to KurtBremser

I agree with you.

 

Is there any way we could import without using proc import or libname.

 

Kafeel

Super User
Posts: 7,857

Re: SAS Import

Posted in reply to KafeelBasha

Read my post. Save to a textual format that is compatible with text input, and you can use a data step with infile/input.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 10,044

Re: SAS Import

Posted in reply to KafeelBasha

DDE skill, but that is too very old . I wouldn't suggest it .

Super User
Posts: 19,869

Re: SAS Import

Posted in reply to KafeelBasha

Why are you trying to do this? 

 

Contributor
Posts: 70

Re: SAS Import

Just to know all possible ways to import.

Ask a Question
Discussion stats
  • 6 replies
  • 284 views
  • 2 likes
  • 4 in conversation