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
data _null_;
x="2006-07--- ";
y=prxchange('s/\-+$//',1,strip(x));
put x= y=;
run;
Use the TRANWRD function
data _null_;
x="2006-07--- ";
y=prxchange('s/\-+$//',1,strip(x));
put x= y=;
run;
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.