topic Re: I am trying to import csv file with date in file name. in SAS Programming

I am trying to import csv file with date in file name.

kotapatipavan95 — Thu, 13 Jan 2022 16:22:03 GMT

for example, the file name is abcd_01jan2022.csv

using DATE9. function, I am able to get 01JAN2022 but in my case scenario, month should be in lowcase.

Can any one please help?

Re: I am trying to import csv file with date in file name.

Reeza — Thu, 13 Jan 2022 16:30:54 GMT

Use the lowcase/lower functions?

How are you getting the date? How are you creating the file name?

@kotapatipavan95 wrote:

for example, the file name is abcd_01jan2022.csv

using DATE9. function, I am able to get 01JAN2022 but in my case scenario, month should be in lowcase.

Can any one please help?

Re: I am trying to import csv file with date in file name.

kotapatipavan95 — Thu, 13 Jan 2022 16:34:54 GMT

I am using

%let date = %sysfunc(today(), DATE9.);

data file_name;

infile "/path/abcd_&date..csv;

run;

when I run this, the program is trying to import file name abcd_13JAN2022.csv

but the file naming(file I am trying to import) has lower case for month i.e. abcd_13jan2022.csv

Re: I am trying to import csv file with date in file name.

japelin — Thu, 13 Jan 2022 16:36:34 GMT

data _null_;
  dt=lowcase('01JAN2022');
run;

%let dt=%lowcase(01JAN2022);

Re: I am trying to import csv file with date in file name.

andreas_lds — Thu, 13 Jan 2022 17:07:19 GMT

Either wrap %sysfunc in %lowcase, or wrap &date. in the infile statement in %lowcase.

%let date = %lowcase(%sysfunc(today(), DATE9.));

data file_name;
  infile "/path/abcd_%lowcase(&date.).csv;
run;