topic Re: how to remove -- from sas date in SAS Programming

how to remove -- from sas date

vraj1 — Fri, 02 Aug 2019 16:42:16 GMT

I have a date which is "2006-07---" and i want to remove "---" as those are missing dates and make it to "2006-07".

any suggestion on how to do it. basically make these --- to iso date format

PaigeMiller — Fri, 02 Aug 2019 16:45:00 GMT

Use the TRANWRD function

Reeza — Fri, 02 Aug 2019 16:47:14 GMT

Ksharp — Sat, 03 Aug 2019 11:55:48 GMT

data _null_;
x="2006-07---   ";
y=prxchange('s/\-+$//',1,strip(x));
put x= y=;
run;