Importing files from subfolders from a folder

[annie_1]

Hi, 

I need to import some dat files into SAS however each file is in a folder and all of these folders are within one folder.

At first I was just importing them one by one using libname and infile. However, I have 60 files I need.

Is there any way to extract the dat files without having to import them one by one? I know there are other posts that recommend doing a macro but I have very little experience with SAS and do not know how to do a macro. I am using SAS 9.4 (32).

Below is what i was doing

libname ds 'D:\Picarro Data\picarro data\2\2019';

x 'cd D:\Picarro Data\picarro data\2\2019';

* IMPORT P 2 DATA;

data df2_08272019;

infile '08\27\LBDS2023-20190827-111601Z-DataLog_User.dat' firstobs=2;

input DATE :$10. TIME :$15. FRAC_DAYS_SINCE_JAN1 $ FRAC_HRS_SINCE_JAN1 $ JULIAN_DAYS $ EPOCH_TIME $ ALARM_STATUS $ INST_STATUS $  CavityPressure $ CavityTemp WarmBoxTemp species H2CO H2CO_30s H2CO_2min H2CO_5min H2O CH4;

run;

data df2_082819;

infile '08\28\LBDS2023-20190828-101608Z-DataLog_User.dat' firstobs=2;

input DATE :$10. TIME :$15. FRAC_DAYS_SINCE_JAN1 $ FRAC_HRS_SINCE_JAN1 $ JULIAN_DAYS $ EPOCH_TIME $ ALARM_STATUS $ INST_STATUS $  CavityPressure $ CavityTemp WarmBoxTemp species H2CO H2CO_30s H2CO_2min H2CO_5min H2O CH4;

run;

Any help would be great.

Thank you.

[tomrvincent]

Use this: https://communities.sas.com/t5/General-SAS-Programming/SAS-import-multiple-text-file-in-subfolders/m...