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. ... View more

Hi, I am trying to get data from a dat file to show in sas. There are multiple columns in the dat file but i only want three. Below is the code I used but when I open the resulting file in SAS only the first column is showing data. Any suggestions would be great. Thank you.   data WORK.THIRTY; infile 'D:\XX\P_02\30\New folder\LBDS2023-20190630-005517Z-DataLog_User.dat' delimiter='09'x DSD truncover lrecl=32767 firstobs=2 ; input DATE :$10. TIME :$15. H20 :$20.; run;   A ... View more

Hi,  I have a days worth of data that is time marked almost every second, where every second a concentration of X chemical is recorded. I have been able to round the time to the nearest minute in SAS, however I am trying to get the average of all the concentrations starting with my first recorded minutes until the 5th minute, and then so on every 5 minutes. So in this case I want the average of '4:42, 4:43, 4:44, 4:45, and 4:46' then the next five minutes etc. Below is a snippet of the data. The first two columns are the original date and time, X is the chemical and its recorded volume. Date time is just the combination of the first two columns, and the second to last column is the SAS_rounded time, and the last column is the Date and Sas_rounded time added together. As you can see I have multiple values for just one minute.  I tried using the MOVAVE function with a unit of 5, but it was only taking the average of the first five entries of X, and so on. I want the code to be able to get the average of the first 5 minutes of X recordings and so on. I also added the code I tried to use for this. Any help with this would be great, thanks.   Example of Data DATE TIME X Date time sas_rounded sas_datetime 5/26/2019 4:42:04 .1003 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:04 .025 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:05 .3623 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:06 1.5256 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:07 22.3626 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:07 2.2256 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:08 3.3458 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:09 6.3565 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:10 7.5642 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:10 8.2356 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:11 2.5655 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:12 5.235 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:13 -8.22 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:13 -.123 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:14 -5.235 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:15 5.2546 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:16 -20.256 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:16 6.3412 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:17 -5.2532 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:18 3.5687 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:19 6.43 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:19 5.2356 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:20 0.2535 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42 5/26/2019 4:42:21 -2.5254 5/26/2019 4:42 4:42:00 AM 5/26/2019 4:42   proc expand data = twentysix out = twentysix_5min method=None; CONVERT X = X_ave/TRANSFORM=(MOVAVE 5); by sas_datetime; run; proc expand data = twentysix out = twentysix_5min_TRY method=None; CONVERT X = X_ave / TRANSOUT=(MOVAVE 5 trim 4); by sas_datetime; run; ... View more