Interval WEEKDAY<weekend days>W allows you to do this (with SAS the week starts Sunday so it's WEEKDAY17W). Documentation here.   data _null_; call symputx('dt',put(intnx('WEEKDAY17W',today(),-1),date9.)); stop; run; %put &=dt; Run above today on Monday April 26. 33 %put &=dt; DT=23APR2021   ... View more

Simply replace "30APR2021"d with today() for the dynamic transformation. ... View more

Thanks a lot! This worked ... View more

Try regex   data have; input string $10.; datalines; asd123ffgg sdffggghhj 34fggghhhh dfvd dvrfgbbfe1 ; run; data want; set have; pattern="s/\d+/$1/"; patternid=prxparse(pattern); if not prxmatch(patternid,string) then do; output; end; run; ... View more

@Shradha1 wrote: Yes some values will fall into two snaps. The ranges will be overlapping. So the entry for 10APR2020 will be duplicated, against one entry the value will be 30Apr2020 and 31may2020 against other. Similarly for other values Use next coed: data want; set have; if date between '01Mar2020'd and '22Apr2020'd then do; snap='30Apr2020'd; output; end; if date between '01Apr2020'd and '23May2020'd then do; snap='31May2020'd; output; end; if date between '01May2020'd and '22Jun2020'd then do; snap='30Jun2020'd; output; end; if date between '01Jun2020'd and '23Jul2020'd then do; snap='31Jul2020'd; output; end; if date between '01Jul2020'd and '31Jul2020'd then do; snap='31Aug2020'd; output; end; run; Thus you will get the wanted duplicates.   ... View more

Or control the values a bit better: data want; set have; newvariable=cats('c_',put(_n_, z2.)); run; Assuming you know there are fewer than 100 records. This gives you C_01, C_02, ... C_15. Which will sort properly and, IMHO, looks a bit nicer. ... View more

Assuming that "Month" and "Month_1" are alphanumeric:   data have; input Date :date9. YearMonth $; format Date date9.; datalines; 2Jan2019 201901 28Feb2019 201902 31Jan2019 201901 31Dec2019 201912 1Jan2020 202001 31Mar2020 202003 ; data want; set have; Month_1 = put(date+1, yymmn6.); run; If a "Date" is the last day of a month adding one automatically shifts the date to first day of the next month. EDIT: Hitting reload in the browser seems to be good idea, if a tab is open for more than an hour, preventing the duplication of answers.   ... View more

Or a SQL cartesian join: proc sql; select a.*, b.* from a, b    ; quit; ... View more

This helped thanks a lot!! ... View more