Hi guys,    suppose to have a number of .csv files (50) in the same folder. Each file is named: PRJ__20221201_13227_MF                                     PRJ__20221201_13227_TR                                     PRJ__20221201_13227_RECOV                                    .............   PRG__ 20221201_ 13227_  are present and the same in all file names.    Is there a way to read all the files in input without doing "proc import" for all files every time? It is preferable that the read files be named with the suffix, e.g., MF, TR, RECOV.   Thank you in advance ... View more

Hi guys,  suppose to have 3 folders named: Country1, Country2, Country3.  In each, there are files named:  Stats_Q1_C1, Stats_Q1_C2, Stats_Q1_C3, Stats_Q2_C1, Stats_Q2_C2, Stats_Q2_C3. etc until Q27.  Is there a way to generate an Excel file for each Q* containing the content of C1, C2, C3 together?  The content are basically frequency tables.    So, file_Q1 will contain the content of files Stats_Q1_C1, Stats_Q1_C2 and Stats_Q1_C3 in the same sheet (so an Excel file is required) one under the other.    Thank you in advance   Best           ... View more

Hi guys,  suppose to have a sas dataset of 51 rows and 50 columns.  I would like to do a PROC FREQ of each of the 50 columns. No combinations or something like that but only PROC FREQ and out with the prefix "stats" and then the name of the variable (column).  Columns (variables) have different names but all starts with Q17_   Is there a way to not to do this variable by variable?    Thank you in advance ... View more

Hi guys,  is there a way to proc import an excel file with 463 columns (variables)?  It is truncated and I cannot save the original file in .csv file format.      Thank you in advance     ... View more

Dear all,  suppose to have the following:  data DB; input ID :$20. Admission :date09. Discharge :date09.; format Admission date9. Discharge date9.; cards; 0001 13JAN2015 13JAN2015 0001 13JAN2015 31MAR2015 0001 01MAR2018 30SEP2018 0001 01JAN2019 31DEC2019 0002 01JAN2015 31DEC2015 0002 01JAN2019 01JAN2019 0002 01JAN2019 15APR2019 ; Is there a way to get the following?    data DB1; input ID :$20. Admission :date09. Discharge :date09.; format Admission date9. Discharge date9.; cards; 0001 13JAN2015 31MAR2015 0001 01MAR2018 30SEP2018 0001 01JAN2019 31DEC2019 0002 01JAN2015 31DEC2015 0002 01JAN2019 15APR2019 ; In other words for equal admission dates I would like to remove the rows where admission == discharge and retain all the cases where admission =! discharge. The first case occurs because there is an emergency department access while the second is a real admission.    Can anyone help me please?    Best ... View more