I have a sample proc sql code that wont run.
proc sql;
select
(CASE
WHEN t1.variable = 0 THEN 'No'
ELSE t1.variable end) as ColumnName
FROM TABLE T1;
quit;
Running this gives me an error of:
"Result of WHEN Clause 2 is not the same data type as the preceding results"
Is it because the result wants to be an integer? If so, how do I out put a "NO"?
I tried to put a colon between the 0, but get the following:
Expressing using equals (=) has components of different data types
result of when clause 2 is not the same data type as preceding results
Correct, you cannot mix chars into numerical variables.
You have some options. Either store the result in a char variable (requires put() on the t1.variable).
Or perhaps can live with using 0 or . (Missing) instead of a NO. (Which a format could fix).
If you require "No" for display purposes then a format would do a good job:
proc format;
value no
0 = "No";
run;
proc sql;
select
t1.variable as ColumnName format = no.
FROM T1;
quit;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.