topic Import CSV file with date variable in SAS Enterprise Guide

Import CSV file with date variable

Kennychan0809 — Fri, 30 Nov 2018 09:29:07 GMT

Hi All,

I have a lot of excel files saved as date variable (i.e. "ABC 20181130.csv", "ABC 20181129.csv" ... etc) would like to import to SAS. Is there any way/code that SAS can read the date variable of the CSV files ?

Re: Import CSV file with date variable

RW9 — Fri, 30 Nov 2018 10:04:09 GMT

How are you reading the csv files? The simplest method is to take the filename when you put it in your import code. The simplest method of this is in the datastep you use to import the data - you do use a datastep right:

data want;
  infile "c:/myfiles/*.csv" filename=filename dlm=",";
  length ...;
  input ...;
  informat ...;
  format ...;
  inname=filename;
run;

With this you can read 1 or more file - I just read all files with .csv extension in here - and get the filename information into a variable - you can process that variable to just get date out.

Re: Import CSV file with date variable

Jagadishkatam — Fri, 30 Nov 2018 10:14:08 GMT


data work.testdata;
infile '~path/ABC_20181130.csv' delimiter=',' ;
input date yymmdd10. ;
run;

or you could use

the

proc import datafile='~path/ABC 20181130.csv' dbms=csv replace;
run;

Re: Import CSV file with date variable

Reeza — Fri, 30 Nov 2018 15:51:39 GMT

You can also use the wildcard and use FILENAME to grab the file name from the file and parse out the date after the fact.