Solved: how to remove -- from sas date

vraj1 · Posted 08-02-2019 12:42 PM

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

Ksharp · Posted 08-03-2019 07:55 AM

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

PaigeMiller · Posted 08-02-2019 12:45 PM

Use the TRANWRD function

--
Paige Miller

Reeza · Posted 08-02-2019 12:47 PM

- or x is the ISO 8601 standard to denote a missing component. Your data already uses the --.
http://support.sas.com/documentation/cdl/en/leforinforref/64790/HTML/default/viewer.htm#p1a0qt18rxyd...

Ksharp · Posted 08-03-2019 07:55 AM

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

how to remove -- from sas date