Hello,
I need to create a variable and assigned a character value based on the criteria.
I need to do this step by using the proc sql.
When I am using following code, I am getting an error.
proc sql;
create table test2 as
select *, case
when ( length(strip(_datetime)) GE 9 ) then
when _date1 GT _date2 then 'N'
end as var1_new
end
from test1 ;
You can't compound the conditions with another WHEN ( you would need another CASE) or add an AND.
when ( length(strip(_datetime)) GE 9 ) & _date1 GT _date2 then 'N'
end as var1_new
The other END makes me wonder if this is already part of a nested case statement though, which means you may need to post the whole nest to debug it.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: