How to extract a non imputed date value in a variable?

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

How to extract a non imputed date value in a variable?

[ Edited ]

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.

date1.jpg


Accepted Solutions
Highlighted
Solution
‎01-09-2018 01:31 AM
Respected Advisor
Posts: 4,540

Re: How to extract a non imputed date value in a variable?

Posted in reply to jayaprakash

@jayaprakash

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);

View solution in original post


All Replies
Highlighted
Solution
‎01-09-2018 01:31 AM
Respected Advisor
Posts: 4,540

Re: How to extract a non imputed date value in a variable?

Posted in reply to jayaprakash

@jayaprakash

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);
New Contributor
Posts: 3

Re: How to extract a non imputed date value in a variable?

Thanks for your help @Patrick

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 102 views
  • 0 likes
  • 2 in conversation