topic Re: If statements based on dates in New SAS User

If statements based on dates

mmea — Thu, 04 Feb 2021 13:11:26 GMT

In my datastep I want to make a new variable based on a date variable

Nor a specific date, men a date value.

If variable1 HAS a date then new_variable = 1

If it doesnt have a date the new variable = 0

How can I do so?

Re: If statements based on dates

PeterClemmensen — Thu, 04 Feb 2021 13:15:10 GMT

What do you mean by "If variable1 HAS a date" ?

I can guess that variable1 is a character variable? So, if the value in variable1 can represent a date, then set new_variable = 1.

Is that right? Can you post come examples of variable1?

Re: If statements based on dates

mmea — Thu, 04 Feb 2021 13:19:58 GMT

the variable1 has the dates "2020-12-29" etc.

But can also contain "NULL"

In a data step I want to make a new variable (new_variable) that has the values 1 if variable 1 has a date or 0 if variable1 has no date

make sense?

Re: If statements based on dates

PeterClemmensen — Thu, 04 Feb 2021 13:22:25 GMT

The logic here is: If variable1 can meaningfully be represented as a date, set new_varaible to 1. Else set new_variable to 0.

data have;
input variable1 $12.;
datalines;
01/01/2021  
nonsense    
32/01/2021  
somechar    
31/01/2021  
nonsense    
01jan2021   
somechar    
;

data want;
   set have;
   new_variable = input(variable1, anydtdte12.) > .;
run;

Result:

variable1   new_variable 
01/01/2021  1
nonsense    0 
32/01/2021  0 
somechar    0 
31/01/2021  1 
nonsense    0 
01jan2021   1 
somechar    0

Re: If statements based on dates

mmea — Thu, 04 Feb 2021 13:28:00 GMT

Thanks!

Can this be done in proc sql? or does it not know these times of functions?

Re: If statements based on dates

PeterClemmensen — Thu, 04 Feb 2021 13:30:41 GMT

Proc SQL is no problem

data have;
input variable1 $12.;
datalines;
01/01/2021  
nonsense    
32/01/2021  
somechar    
31/01/2021  
nonsense    
01jan2021   
somechar    
;

proc sql;
   select variable1,
          (input(variable1, anydtdte12.) > .) as new_variable
   from have;
quit;