Thank you so much! ... View more

Thank you. I forgot to mention in my initial post that in the dataset that I have to create from all these csv files, I will also have to include a new variable containing the name of the csv file for each observation. Will I be able to do that by modyfying the solution you provided? ... View more

Thank you! ... View more

Thank you very much @Kurt_Bremser!   I was also able to modify my code, by entering a proc sql on top of the macro calc (before reading the datasets) and introducing the variable (which I used in INFILE statement) inside this proc sql:     %macro calc(lbl=); proc sql noprint; select file_name into :fname from latest_filenames where segment = &lbl.; quit;   /*Reading csv files into dataset*/ data work.incsv; infile "&STOUT.\&fname." dlm='|,' dsd firstobs=2; input acct_id :$30. column2 :4. column3 :$6. bal :20. ; run;   /*Perform calculations*/   /*Update results dataset*/   %mend calc; %calc(lbl='PRODUCT1'); %calc(lbl='PRODUCT2'); %calc(lbl='PRODUCT3');   ... View more

Hi, thank you for your input!   Here is what I am trying to do (sorry did not provide more details in my original post last night): - In a folder (Windows), I have a list a of csv files; their filenames contain specific keywords (representing what product they are), the month end date (for example: 20200630) and date/time stamp when they were created (for example: 20200710.180656).   The structure of these filenames within this folder is as follow:   PROD.CNTR_PRODUCT1.DATA.20200630.csv.20200717.174612 PROD.CNTR_PRODUCT1.PARAMETER.20200630.csv.20200717.180610 PROD.APPtriggerfile.PROD - Dept.CNTR_PRODUCT1.20200630.csv.20200717.180615   PROD.CNTR_PRODUCT2.DATA.20200630.csv.20200717.183024 PROD.CNTR_PRODUCT2.PARAMETER.20200630.csv.20200717.184315 PROD.APPtriggerfile.PROD - Dept.CNTR_PRODUCT2.20200630.csv.20200717.184320   PROD.CNTR_PRODUCT3.DATA.20200630.csv.20200717.184942 PROD.CNTR_PRODUCT3.PARAMETER.20200630.csv.20200717.190211 PROD.APPtriggerfile.PROD - Dept.CNTR_PRODUCT3.20200630.csv.20200717.190216   PROD.CNTR_PRODUCT1.DATA.20200630.csv.20200717.191521 PROD.CNTR_PRODUCT1.PARAMETER.20200630.csv.20200717.193221 PROD.APPtriggerfile.PROD - Dept.CNTR_PRODUCT1.20200630.csv.20200717.193226   PROD.CNTR_PRODUCT3.DATA.20200630.csv.20200717.193743 PROD.CNTR_PRODUCT3.PARAMETER.20200630.csv.20200717.194201 PROD.APPtriggerfile.PROD - Dept.CNTR_PRODUCT3.20200630.csv.20200717.194206   Task 1: Out of hundreds of these files in this folder, I have to select very few (about 19); these files should be: - only DATA files, - only for specific products as per specified list (Product1, 2...) - only the latest created files.   I am able to do this and I have created a dataset with two column: one containing the full filename and the other containing only the respective product name (if needed I can include other information like month-end-date, datestamp, timestamp...):   PROD.CNTR_PRODUCT1.DATA.20200630.csv.20200717.191521 PRODUCT1   PROD.CNTR_PRODUCT2.DATA.20200630.csv.20200717.183024 PRODUCT2   PROD.CNTR_PRODUCT3.DATA.20200630.csv.20200717.193743 PRODUCT3   Task 2: I have to: a - import them as sas datasets (they are csv files) b - perform some calculations with some of the data contained in these datasets.   The generic code for Task 2/b is as follow:   %LET STOUT=\\NAS_SHARED_LOCATION\Folder1\Folder2;   %macro calc(lbl=); /*Reading csv files into dataset*/ data work.incsv; infile "&STOUT\&flname" dlm='|,' dsd firstobs=2; input acct_id :$30. column2 :4. column3 :$6. bal :20. ; run;   /*Creating the results*/ proc sql; create table outreslt as select "&lbl" as Product length=12 label='Product', count(*) as Total_Records format=comma10. label='Total Count', sum(bal) as Total_BAL format=dollar16. label='Total Amount' from work.incsv; quit;   /*Updating Results*/ data Output_results; set Output_results outreslt; run; %mend calc; %calc(lbl="Product1"); %calc(lbl="Product2"); %calc(lbl="Product3"); ... %calc(lbl="Product19");   /*Printing Results*/ proc print data=Output_results; run;   My question is about Task 2/a: is it possible to pass the values from the dataset created in Task 1 to the infile statement used in Task 2/b, specicilally to &flname variable?   Thank you! ... View more