Import CSV to sas data

rojomauri — Thu, 16 Nov 2017 19:51:37 GMT

Hi,

I need to import many CSV files into a SAS data.

All the CSV has the same structure but different names:

/test/Inventario201701cons.csv

/test//Inventario201702cons.csv

/test/Inventario201703cons.csv

.......

So, I need to import the files depending the date (month) when I started my study. If my started month was 201701 (JAN-17), I will need to take +6 CSV files from JAN-17, so I need 201701-201702-.......-201706, but If I started on 201703, I will need 201703-....-201708 and so on

Could you please help!

Thanks

Re: Import CSV to sas data

Reeza — Thu, 16 Nov 2017 20:24:03 GMT

If they're all in one folder, you can use a wildcard approach instead.

And you can read all at once, assuming you want all of the tables stacked together.

Here's a write up on how to do that.

If you need further help, you should include your code, the log and description of what issues you're having.

https://communities.sas.com/t5/SAS-Communities-Library/How-do-I-write-a-macro-to-import-multiple-text-files-that-have/ta-p/223627

If you need instructions on how to import a CSV file see here:

http://video.sas.com/detail/videos/sas-analytics-u/video/4573016758001/creating-a-sas-table-from-a-csv-file?autoStart=true

@rojomauri wrote:

Hi,

I need to import many CSV files into a SAS data.

All the CSV has the same structure but different names:

/test/Inventario201701cons.csv

/test//Inventario201702cons.csv

/test/Inventario201703cons.csv

.......

So, I need to import the files depending the date (month) when I started my study. If my started month was 201701 (JAN-17), I will need to take +6 CSV files from JAN-17, so I need 201701-201702-.......-201706, but If I started on 201703, I will need 201703-....-201708 and so on

Could you please help!

Thanks

topic Import CSV to sas data in SAS Procedures

Import CSV to sas data

Re: Import CSV to sas data