topic Re: Can we use if and else if inside proc sql? in SAS Programming

Can we use if and else if inside proc sql?

GN0001 — Thu, 01 Jul 2021 03:23:57 GMT

Proc sql;

create table mytable as

select distinct b.*,

if b.rate < 35 then '50th'

else if < 50 then '75th'

else if < 75 then '80th'

else if >=75 'this is the one' as label = 'done'

, a.diagcode

from tableb b left join tablea a on....

Or if statement can't be used inside proc sql and we need to use case statement only?

Respectfully,

blue blue

Re: Can we use if and else if inside proc sql?

SASKiwi — Thu, 01 Jul 2021 03:43:31 GMT

I'm pretty sure we gave you the answer to this in another of your questions. There is no such thing as IF logic in SQL only CASE.

I've followed your progress on the Community with interest and respectfully I think you are missing some basic SAS concepts that would really speed up your learning.

I suggest you start using the free SAS online learning resources like this huge list of how-to tutorials

And explore the SAS documentation

These will really supercharge your learning!

Re: Can we use if and else if inside proc sql?

GN0001 — Thu, 01 Jul 2021 04:08:53 GMT

I am so grateful to your response.

I have a couple of certificates in SAS. I am doing SAS Base currently, and I get any chance, I will listen to my tutorials again. I wish I had not gone for it at all!

I am currently covering The little SAS Book.

I will go to the links you sent me, thank you very much. Unfortunately topics that I post here requires answers for my project that are due. SAS documentation is very technical and it is very hard to understand, at least for me.

I probably asked you this question before, but what happens is if I don't use them, I will lose them. The way you mentioned to me here, believe me, I wont' forget it.

Thanks for your advice and link you sent me.

Blue Blue

Re: Can we use if and else if inside proc sql?

SASKiwi — Thu, 01 Jul 2021 04:38:34 GMT

No problem. Best of luck on your SAS journey!