Hi , I have the following code below that has a hard-coded BeginDt and macro to create EndDate3, both of which are later used in my program and need to be in 'ddmmmyyyy'd format: %let BeginDt = '01SEP2015'd; %let Enddt = %sysfunc(today(),date9.); %let Enddt2 ="&Enddt"d; %let Enddt3=%sysfunc(tranwrd(&Enddt2,%str(%"),%str(%'))); %put &Enddt3;   I'm trying to modify the code, so the BeginDate is also dynamic based on a certain condition. The condition is that if EndDt3 is less that 01Sep(current year) then Startdate should be 01Sep(current year minus 5). Otherwise, if EndDt3 is greater or equal to 01Sep(current year) then StartDate should be 01Sep(current year minus 4). Ultimately, I need StartDate macro variable to look like '01sep2015'd (depending on a condition).   I have this code below and it's not working as it's not converting macro characters into date values:   data _null_; %let Enddt = %sysfunc(today(),date9.); %let Enddt2 ="&Enddt"d; %let Enddt3=%sysfunc(tranwrd(&Enddt2,%str(%"),%str(%'))); %let curr_year=%sysfunc(year(%sysfunc(date())));   if &Enddt3 < '01sep&curr_year'd then start='01sep(&curr_year-5)'d; else if &Enddt3 >= '01sep&curr_year'd then start='01sep(&curr_year-4)'d; %let StartDt=start; %put &StartDt; run;   Any suggestions of how to solve this would be greatly appreciated. Thank you! ... View more

Hi, I have a dataset with clients who had certain procedure performed over the 3 year time period. I need to flag those instances where  4 or more procedures took place outside the 180 day period for each client ID (status=flagged). Here is a sample data set. ID serv_dt lag PROCCD proccdcnt status 217207401 3/22/2017 0 95951 4   217207401 4/2/2018 376 95951 4   217207401 4/3/2018 1 95951 4   217207401 5/23/2018 50 95951 4   220135502 11/4/2016 0 95951 4   220135502 11/13/2016 9 95951 4   220135502 11/14/2016 1 95951 4   220135502 11/15/2016 1 95951 4 flagged 237287806 11/17/2017 0 95951 6   237287806 11/18/2017 1 95951 6   237287806 11/19/2017 1 95951 6   237287806 10/28/2018 343 95951 6   237287806 10/29/2018 1 95951 6   237287806 10/30/2018 1 95951 6   220462501 10/17/2018 0 95951 5   220462501 10/18/2018 1 95951 5   220462501 10/19/2018 1 95951 5   220462501 10/20/2018 1 95951 5   220462501 10/21/2018 1 95951 5 flagged 249892003 12/7/2016 0 95951 4   249892003 12/8/2016 1 95951 4   249892003 12/9/2016 1 95951 4   249892003 12/10/2016 1 95951 4 flagged 257527503 4/14/2017 0 95951 6   257527503 4/15/2017 1 95951 6   257527503 5/28/2017 43 95951 6   257527503 7/18/2018 416 95951 6   257527503 7/19/2018 1 95951 6   257527503 7/20/2018 1 95951 6   219482501 8/30/2016 0 95951 11   219482501 8/31/2016 1 95951 11   219482501 9/1/2016 1 95951 11   219482501 9/2/2016 1 95951 11 flagged 219482501 9/3/2016 1 95951 11 flagged 219482501 9/4/2016 1 95951 11 flagged 219482501 9/5/2016 1 95951 11 flagged 219482501 9/6/2016 1 95951 11 flagged 219482501 9/7/2016 1 95951 11 flagged 219482501 9/8/2016 1 95951 11 flagged 219482501 9/9/2016 1 95951 11 flagged   So, for example, the first ID=217207401 will not be flagged. But the second, id=220135502 will be flagged as there were 4 procedures done in less than 180 days. I understand that there should probably be some way of using a macro to count within each ID group the number of days for the consequitive 4 observations, and flag them when it's more than 180. But I'm not sure how to do that as teh number of rows for each ID is different. Any help or advice would be appreciated. Thank you! ... View more

Hi, I'm trying to extract a text string (name) from a longer string, which may occur either once within the string or multiple times (several names). I'm breaking the longer string into groups and using prxparse and prxmatch with grouping to extract only the group I need, but something is not working. Below is an example of my text string, my code and what I'm looking for at the end.   data have;  Prov_Info ="ProviderName: Spine and Pain Center of Whatchamikola; IDN: 2345678901; IsGroup: No;,   ProviderName: Happy Toes; IDN: 3456789012; IsGroup: No;,   ProviderName:  IDN: 3456789012; IsGroup: Yes;, ProviderName: Bright Smiles of AZ; IDN: 1234567890 IsGroup: Yes;, ";    patternID = prxparse('/^(ProviderName:)( |.*; )(NPI: )/');         if prxmatch(patternID, strip(Prov_Info)) then do;      newname=prxposn(patternID, 2, Prov_Info); end; run;   Result needed: newname=Spine and Pain Center of Whatchamikola; Happy Toes;  Bright Smiles of AZ;   Any suggestions would be attreciated. Thank you! ... View more