topic import files in sas in New SAS User

import files in sas

sindhura1 — Sun, 30 Aug 2020 09:51:19 GMT

I want to import multiple excel files into sas and display filenames and corresponding column names.

can anyone help me with this.

Re: import files in sas

Kurt_Bremser — Sun, 30 Aug 2020 10:44:22 GMT

What kind of SAS setup do you use?

University Edition
On Demand for Academics
Local, single computer
Client/Server with a remote server

Which interface do you use? Enterprise Guide, SAS Studio, or native Display Manager?

Re: import files in sas

sindhura1 — Sun, 30 Aug 2020 11:07:55 GMT

I use Enterprise Guide with Client/Server with a remote server

Re: import files in sas

Kurt_Bremser — Sun, 30 Aug 2020 11:22:44 GMT

You can create an Import task for every Excel file; the wizard will guide you through this.

Or you copy all your Excel files to the SAS server (either by using the Copy Files task, or an external utility like WinSCP), and write code that assigns a library for every Excel file, after which you can use DICTIONARY.TABLES and DICTIONARY.COLUMNS to extract the metadata.