topic Re: SAS Import in SAS Programming

SAS Import

KafeelBasha — Mon, 18 Apr 2016 04:52:11 GMT

Hello

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

Please help me with this.

Kafeel

Kurt_Bremser — Mon, 18 Apr 2016 07:11:13 GMT

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

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

KafeelBasha — Mon, 18 Apr 2016 07:42:34 GMT

I agree with you.

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

Kafeel

Kurt_Bremser — Mon, 18 Apr 2016 07:44:57 GMT

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 — Mon, 18 Apr 2016 07:55:23 GMT

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

Reeza — Mon, 18 Apr 2016 09:12:12 GMT

Why are you trying to do this?

KafeelBasha — Wed, 20 Apr 2016 05:09:32 GMT

Just to know all possible ways to import.