DATA Step, Macro, Functions and more

proc SQL in SAS

Accepted Solution Solved
Reply
Contributor
Posts: 38
Accepted Solution

proc SQL in SAS

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


Accepted Solutions
Solution
‎01-25-2018 07:56 AM
Trusted Advisor
Posts: 1,831

Re: proc SQL in SAS

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

 

View solution in original post


All Replies
Contributor
Posts: 22

Re: proc SQL in SAS

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

Re: proc SQL in SAS

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

Solution
‎01-25-2018 07:56 AM
Trusted Advisor
Posts: 1,831

Re: proc SQL in SAS

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

 

Super User
Posts: 13,283

Re: proc SQL in SAS

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 170 views
  • 2 likes
  • 4 in conversation