Hi all,
I need to write sql code in sas,
variable A divide to Variable b * 100, if answer more then 5 then give me new variable filled "Y"
using data name Example
Thanks
@Rhys solution:
select case when (var_a / var_b)*100 > 5 then 'Y' else 'N' end as var_c
means that result (either Y or N) wil be in var_c variable.
Then "Y" can you tell me where is my variable which should be equal to "y"
@Rhys solution:
select case when (var_a / var_b)*100 > 5 then 'Y' else 'N' end as var_c
means that result (either Y or N) wil be in var_c variable.
As a general note you might want to consider using numeric values of 1 and 0 instead of character 'Y' and 'N'.
If 1 is the value for 'Y' or 'Yes' or however you think then:
If varname then <other code> ; treats a value for the variable varname as true.
You can a have a number of different formats to assign a display value of 'Y', 'Yes' ,'True', 'In Compliance' or what have you.
For summary tables such as in proc report or proc tabulate then the N statistics gives how many results are assigned either value, Sum shows number of 'Y' values and mean is percentage of 'Y' values.
If you have multiple variables code this way then Sum of the variables gives a count of how many variables have 'Y' values.
And other coding behaviors are possible that get more cumbersome for character values.
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.