Import csv files

BrahmanandaRao — Fri, 03 Jul 2020 12:36:10 GMT

Good Evening

How to import multiple csv files as a single dataset

Re: Import csv files

Tom — Fri, 03 Jul 2020 12:41:37 GMT

@BrahmanandaRao wrote:

Hi

Good Evening

How to import multiple csv files as a single dataset

Don't "import" them. Instead just read them.

I will assume they all have the same structure, otherwise why are you putting them into a single dataset?

data want;
   length fname filename $256 ;
   input '/mydir/*.csv' filename=fname dsd truncover ;
   input @;
   if fname ne lag(fname) then input ;
   input  .... ;
   filename=fname;
run;

Just replace the 'input ....' statement with the code to read your variables. So you might want to first use LENGTH statement to define the variable before the INPUT statement. Also you might want to add FORMAT and/or LABEL statements.

topic Import csv files in SAS Programming

Import csv files

Re: Import csv files