cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
kotapatipavan95
‎02-03-2022
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Import csv files of saturday and sunday on monday

by Calcite | Level 5 in SAS Programming
‎02-03-2022 04:03 PM
‎02-03-2022 04:03 PM
This is the code I tried. %let weekdy = weekday(today()); %let day = %sysfunc(putn(%eval(%sysfunc(today())), yymmddn8.)); %let ysday = %sysfunc(putn(%eval(%sysfunc(today())-1), yymmddn8.)); %let dbysday = %sysfunc(putn(%eval(%sysfunc(today())-2), yymmddn8.));   %let loc=/location/Data;   data _null_; d=&weekdy.; if d=2 then do; proc import datafile="/&loc./file-&day..csv" dbms=csv out=data_1 replace; run;   /*yesterday_file*/ proc import datafile="/&loc./file-&ysday..csv" dbms=csv out=data_11 replace; run;   /*daybefore_file*/ proc import datafile="/&loc./file-&dbysday..csv" dbms=csv out=data_12 replace; run;   /*concoat_files*/ data data1; set work.data_1 work.data_11 work.data_12; end; else do; proc import datafile="/&loc./file-&day..csv" dbms=csv out=data_1 replace; run;   data data1; set work.data_1; end; run; ... View more

Import csv files of saturday and sunday on monday

by Calcite | Level 5 in SAS Programming
‎02-03-2022 03:28 PM
‎02-03-2022 03:28 PM
I am trying to import csv file into sas based on weekday.  If its Monday, it has to import files of Saturday, Sunday and Monday and concatenate them, and rest of the days it has to import files of that day. csv files have name convention of "file-20220203.csv" I tried writing a If-Then-Else condition, where if weekday is 2(Monday) then import files of today, yesterday and daybefore yesterday, else import file of that day. But its not working. ... View more

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

by Calcite | Level 5 in SAS Programming
‎01-13-2022 11:34 AM
‎01-13-2022 11:34 AM
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 ... View more

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

by Calcite | Level 5 in SAS Programming
‎01-13-2022 11:22 AM
‎01-13-2022 11:22 AM
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?   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-03-2022 03:17 PM
Quick links