proc SQL in SAS

[Vahe_Mar]

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]

select case when (var_a / var_b)*100 > 5 then 'Y' else 'N' end as var_c
from table

[Vahe_Mar]

Then "Y" can you tell me where is my variable which should be equal to "y"

[Shmuel · Accepted solution]

@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.

[ballardw]

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.