topic If statement in SAS Proc in SAS Programming

If statement in SAS Proc

Ramanuj_Khatri — Fri, 08 Apr 2016 16:21:47 GMT

Hi everyone,

I have two question please answer them:

1. Is it true that we can't use if statement in all SAS Procedures? Are there some procedures in which we can use if statement, If yes then please name some of them.

2. Can we use if statement in Proc sql? If yes, then please give me a small example.

Thanks,

Ramanuj

Re: If statement in SAS Proc

Reeza — Fri, 08 Apr 2016 16:29:45 GMT

No you can't use IF statements in all procs.

I think you're intending to refer to WHERE statements.

AFAIK you can use it all procs.

WHERE is a clause available in SQL.

You cannot use if statement in proc sql.

Re: If statement in SAS Proc

FreelanceReinh — Fri, 08 Apr 2016 16:38:39 GMT

Hi @Ramanuj_Khatri,

Answers:

Examples of procedures which allow the use of an IF statement (in a certain way) include PROC PHREG, PROC GENMOD, PROC NLMIXED, PROC MCMC, PROC GLIMMIX and some other statistical procedures as well as PROC FCMP.
No, an IF statement is not valid in PROC SQL. If you want to perform, e.g., conditional assignments in PROC SQL, please provide details on your problem.

Re: If statement in SAS Proc

Tom — Fri, 08 Apr 2016 16:45:40 GMT

WHERE statements should work in all procs. The main exception is PROC SQL which has its own WHERE clause as part of statements like SELECT, DELETE or UPDATE.

An actual IF/THEN statement is general NOT available in PROCS. There are some procs that allow you to provide snippets of code that will support IF/THEN statements.

In PROC SQL the type of logic you would use in an IF/THEN statement you would normally code using CASE instead.

So in a data step you could write:

if sex= 1 then gender='Female';
else if sex=2 then gender='Male';
else gender='Unknown;

In PROC SQL you would write:

case when sex=1 then 'Male'
     when sex=2 then 'Female'
     else 'Unknown'
end as Gender

Re: If statement in SAS Proc

ballardw — Fri, 08 Apr 2016 16:46:05 GMT

You can use IF in Proc FCMP (which makes functions calleable in a datastep), Proc Template (in defining some options inside diferent types of templates) , In compute blocks in Proc Report.

I'm sure there are other places but I don't have every SAS module available.

Re: If statement in SAS Proc

Ramanuj_Khatri — Fri, 08 Apr 2016 17:02:39 GMT

Thanks Tom, for detailed answer.