topic proc SQL in SAS in SAS Programming

proc SQL in SAS

Vahe_Mar — Thu, 25 Jan 2018 12:26:58 GMT

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

Re: proc SQL in SAS

Rhys — Thu, 25 Jan 2018 12:31:56 GMT

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

Re: proc SQL in SAS

Vahe_Mar — Thu, 25 Jan 2018 12:35:36 GMT

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

Re: proc SQL in SAS

Shmuel — Thu, 25 Jan 2018 12:41:01 GMT

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

Re: proc SQL in SAS

ballardw — Thu, 25 Jan 2018 15:43:50 GMT

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.