topic import Set of CSV files in SAS Programming

import Set of CSV files

sg_kr — Wed, 17 Jul 2019 12:39:37 GMT

Hi,

I have a folder in local machine, where every month set of CSv files will be updated.

Now i want to import all of them and create tables as per their file name .

can anyone help on this.

thanks

Re: import Set of CSV files

Kurt_Bremser — Wed, 17 Jul 2019 12:45:02 GMT

By "local machine", do you mean that you have stored the csv files on a machine other than the one where SAS is installed and running?

In this case, you first need to take care that the files are either copied to the SAS machine or that the place where the csv files are stored is somehow "visible" to SAS.

Re: import Set of CSV files

Reeza — Wed, 17 Jul 2019 15:23:20 GMT

Do you have code to read one file successfully? If so, post that code.

Are all files exactly the same structure?