SAS Import

[KafeelBasha]

Hello

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

Please help me with this.

Kafeel

[Kurt_Bremser]

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

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

[KafeelBasha]

I agree with you.

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

Kafeel

[Kurt_Bremser]

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

[Ksharp]

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

[Reeza]

Why are you trying to do this? 

[KafeelBasha]

Just to know all possible ways to import.