I have a character date variable of format dd-MMM-yyyy in which some of the values are in the format -MMM-yyyy. i want to remove the first "-" only from these values.
I tried using this code
if length(date1) ne 11 then col1 = substr(date1,2,8);
else col1 = date1;
But I couldn't get the desired result.
The sample date values are as below.
If you're after tested code then please provide sample data in form of a SAS datastep creating such data and not in form of a screenshot.
Looking at the screenshot: Could it be that you've got leading blanks? If so then below could work:
if length(left(date1)) ne 11 then col1 = substr(left(date1),2,8);
If you're after tested code then please provide sample data in form of a SAS datastep creating such data and not in form of a screenshot.
Looking at the screenshot: Could it be that you've got leading blanks? If so then below could work:
if length(left(date1)) ne 11 then col1 = substr(left(date1),2,8);
Thanks for your help @Patrick
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.