https://communities.sas.com/t5/SAS-Programming/how-to-list-the-earliest-and-latest-file-in-a-directory/m-p/833623#M329559 If it's SAS data sets, it's slightly easier as you can assign a library and the information is in sashelp.vtable already for you to parse. Thu, 15 Sep 2022 15:00:48 GMT Reeza 2022-09-15T15:00:48Z https://communities.sas.com/t5/SAS-Programming/how-to-list-the-earliest-and-latest-file-in-a-directory/m-p/833387#M329442 <P>hello all sas experts:</P> <P>&nbsp;</P> <P>i have a folder that stored a lot of datasets from different years. the dataset are: Cinfo2004 to Cinfo2021, Ginfo2006 to Ginfo2021, Ginfo_Geocode2010 to Ginfo_Geocode2021.&nbsp;</P> <P>I would like to create a sas code to list all data files in the directory by providing the earliest and latest years for each type of the dataset. for example Cinfo’s earliest year is 2004 and the latest is 2021 and Ginfo's earliest year is 2006 and the latest is 2021.</P> <P>i know there is a way to write a sas code to pull out these information but don't know how to do it.</P> <P>&nbsp;</P> Wed, 14 Sep 2022 17:53:33 GMT https://communities.sas.com/t5/SAS-Programming/how-to-list-the-earliest-and-latest-file-in-a-directory/m-p/833387#M329442 juliajulia 2022-09-14T17:53:33Z https://communities.sas.com/t5/SAS-Programming/how-to-list-the-earliest-and-latest-file-in-a-directory/m-p/833388#M329443 <P>Are these SAS data sets or some other file type?</P> Wed, 14 Sep 2022 17:57:24 GMT https://communities.sas.com/t5/SAS-Programming/how-to-list-the-earliest-and-latest-file-in-a-directory/m-p/833388#M329443 Reeza 2022-09-14T17:57:24Z https://communities.sas.com/t5/SAS-Programming/how-to-list-the-earliest-and-latest-file-in-a-directory/m-p/833390#M329444 <P>You can read all the file names in a folder into a SAS data set.</P> <P><A href="https://communities.sas.com/t5/SAS-Programming/How-to-List-all-the-files-in-a-folder/td-p/674065" target="_blank" rel="noopener">https://communities.sas.com/t5/SAS-Programming/How-to-List-all-the-files-in-a-folder/td-p/674065</A></P> <P><BR />From there you can pick the ones you want.</P> Wed, 14 Sep 2022 18:10:07 GMT https://communities.sas.com/t5/SAS-Programming/how-to-list-the-earliest-and-latest-file-in-a-directory/m-p/833390#M329444 PaigeMiller 2022-09-14T18:10:07Z https://communities.sas.com/t5/SAS-Programming/how-to-list-the-earliest-and-latest-file-in-a-directory/m-p/833618#M329557 <P>Thank you</P> Thu, 15 Sep 2022 14:56:34 GMT https://communities.sas.com/t5/SAS-Programming/how-to-list-the-earliest-and-latest-file-in-a-directory/m-p/833618#M329557 juliajulia 2022-09-15T14:56:34Z https://communities.sas.com/t5/SAS-Programming/how-to-list-the-earliest-and-latest-file-in-a-directory/m-p/833623#M329559 If it's SAS data sets, it's slightly easier as you can assign a library and the information is in sashelp.vtable already for you to parse. Thu, 15 Sep 2022 15:00:48 GMT https://communities.sas.com/t5/SAS-Programming/how-to-list-the-earliest-and-latest-file-in-a-directory/m-p/833623#M329559 Reeza 2022-09-15T15:00:48Z