Hello,   In need of help to record months for each effective date of eligibility until a change in their coverage.  So, I need to expand so that each month that they are in a specific insurance code, then they change the insurance code and span the months from when they changed their insurance code. This is the data that I have: plan_eff_dt plan_term_dt ID INS_CD 1/1/2022 12/30/2022 3761 513 8/1/2022 12/30/2022 3761 600 1/1/2023 12/30/2023 3761 600 7/1/2023 12/30/2023 3761 513   The data that I want: active_mbr_dt plan_eff_dt plan_term_dt ID INS_CD 1/1/2022 1/1/2022 12/30/2022 3761 513 2/1/2022 1/1/2022 12/30/2022 3761 513 3/1/2022 1/1/2022 12/30/2022 3761 513 4/1/2022 1/1/2022 12/30/2022 3761 513 5/1/2022 1/1/2022 12/30/2022 3761 513 6/1/2022 1/1/2022 12/30/2022 3761 513 7/1/2022 1/1/2022 12/30/2022 3761 513 8/1/2022 8/1/2022 12/30/2022 3761 600 9/1/2022 8/1/2022 12/30/2022 3761 600 10/1/2022 8/1/2022 12/30/2022 3761 600 11/1/2022 8/1/2022 12/30/2022 3761 600 12/1/2022 8/1/2022 12/30/2022 3761 600 1/1/2023 1/1/2023 12/30/2023 3761 600 2/1/2023 1/1/2023 12/30/2023 3761 600 3/1/2023 1/1/2023 12/30/2023 3761 600 4/1/2023 1/1/2023 12/30/2023 3761 600 5/1/2023 1/1/2023 12/30/2023 3761 600 6/1/2023 1/1/2023 12/30/2023 3761 600 7/1/2023 7/1/2023 12/30/2023 3761 513 8/1/2023 7/1/2023 12/30/2023 3761 513 9/1/2023 7/1/2023 12/30/2023 3761 513 10/1/2023 7/1/2023 12/30/2023 3761 513 11/1/2023 7/1/2023 12/30/2023 3761 513 12/1/2023 7/1/2023 12/30/2023 3761 513 ... View more

Hello,   I'm needing to extract the middle numbers from an alphanumeric string that can have varying lengths. This an example of the alphanumeric strings:     Have:              1)  SC_NATLTAP_P_617686046__0520               2)  NC_OPTUM PARTD_R_220335038421000999P__0910     Want:             1)  617686046             2)  220335038421000999P   I've used Compress, but still leaves the last 4 digits, which I don't need. ID = Compress(clm_nb,"_","A"); Thank you in advance.       ... View more

My SAS program contains a PRXPARSE statement, but it writes every changes it makes to the SAS log causing the log to balloon to over several gigabytes.  I have suppressed what should be written to the log :  options MSGLEVEL=N nonotes nosource NOPRINTMSGLIST noerrorabend missing=" " ; Yet, it still writes everything the PRXPARSE is doing: Is there a way to suppress these from writing to the log ? Thank you.   ... View more

I'm trying to get a list of files in a directory and the subdirectories with file attributes, in particular the size of each file. the files are listed in the main directory, but there a bunch of subdirectories with files.  I've been using the following code, but have not figured out how to get the size of the file, it only gives the directory and file.  I've used the FINFO function, but doesn't give the size.   %macro list_files(dir,ext); %local filrf rc did memcnt name i; %let rc=%sysfunc(filename(filrf,&dir)); %let did=%sysfunc(dopen(&filrf));   %if &did eq 0 %then %do; %put Directory &dir cannot be open or does not exist; %return; %end;   %do i = 1 %to %sysfunc(dnum(&did)); %let name=%qsysfunc(dread(&did,&i));   /* %if %qupcase(%qscan(&name,-1,.)) = %upcase(&ext) %then %do;*/ %if %qscan(&name,2,.) ne %then %do; %put &dir/&name;   data _tmp; length dir $512 name $100; dir=symget("dir"); name=symget("name"); size=FINFO(OPEN(symget("name")), 'FILE SIZE (BYTES)'); run; proc append base=want                     data  =_tmp; run;quit; %end; %else %if %qscan(&name,2,.) = %then %do; %list_files(&dir/&name,&ext) %end; %end; %let rc=%sysfunc(dclose(&did)); %let rc=%sysfunc(filename(filrf)); %mend list_files; %list_files(/gpfsFS2/sasdata/adhoc/pofin/nps/npsts/prod/cera/data,*) ... View more