Importing files from subfolders from a folder

annie_1 — Mon, 28 Oct 2019 14:51:15 GMT

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;

run;

Any help would be great.

Thank you.

topic Importing files from subfolders from a folder in New SAS User

Importing files from subfolders from a folder

Re: Importing files from subfolders from a folder