topic Re: If clause in SAS Programming

If clause

Babloo — Fri, 25 Sep 2015 10:46:19 GMT

When I run the following code, I got 'not success' in the log where as I'm execpting 'sucess' message in the log. Can someone explain this code?

%let end_title=1565;
%macro test;
data test1;
if %eval(&end_title)<1565< %eval(&end_title)+%eval(&end_title) then put 'success';
else put "notsucess";
_n=%eval(&end_title)+%eval(&end_title);
run;
%mend test;
%test

Re: If clause

Astounding — Fri, 25 Sep 2015 11:35:59 GMT

That's a question that pops up from time to time .,.. here's oen thread you can look at:

https://communities.sas.com/t5/Base-SAS-Programming/Macro-resolving/m-p/218619#M40282

Re: If clause

Babloo — Fri, 25 Sep 2015 11:41:15 GMT

Could you please tell me how to print the value of _n_ in log from the following code? I could not see the value of _n_ after placing the put _all_ statement.

if 1<_n_< %eval(&end_title) then do; put option;end;
put _all_;
if _n_=%eval(&end_title) then do; put option;		
put _all_;

Re: If clause

RW9 — Fri, 25 Sep 2015 12:41:00 GMT

Hi,

Lets start again. What are you attempting to do. There is nothing there (again) which needs macro code. There is then the difference in the code you posted, in the first instance you use _n which is a variable or macro variable? in the latest post you use _n_ wihch is an automatic variable for row number. What is the purpose, the logic, i.e. what goes in (as a datastep) and what do you want the output to look like.

Re: If clause

Babloo — Fri, 25 Sep 2015 12:49:42 GMT

My first and second post is not related to each other. I missed to start a new thread for my second post. I need to get the value the _n_ in SAS log. When I tried this code, I'm not getting the value of _n_ in SAS log.

if 1<_n_< %eval(&end_title) then do; put option;end;
put _all_;
if _n_=%eval(&end_title) then do; put option;		
put _all_;

I tried this code as well, but could not suceeed.

if 1<_n_< %eval(&end_title) then do; put option;end;
put _n_=;
if _n_=%eval(&end_title) then do; put option;		
put _n_=;

Re: If clause

Astounding — Fri, 25 Sep 2015 13:02:11 GMT

put _all_ will include writing _n_. If you want _n_ only, you could try:

put _n_=;

Re: If clause

Babloo — Fri, 25 Sep 2015 13:10:21 GMT

I did tried as I said my previous, but I could not see the value of _n_ in SAS log.

Re: If clause

Tom — Fri, 25 Sep 2015 13:19:16 GMT

You seem to be missing a END for your second DO.

Re: If clause

RW9 — Fri, 25 Sep 2015 13:19:51 GMT

Sorry, you still have not explained what you are trying to do, what is the input data, what is the output requirement. The reason is in base SAS, this works fine:

data tmp;
set sashelp.cars;
put _n_;
run;

It prints the row number for each record in the dataset. I can't see what your trying to do.

Re: If clause

Tom — Fri, 25 Sep 2015 13:21:27 GMT

Looks like it is working to me.

1565 is NOT less than 1565. So the ELSE clause should execute.

Re: If clause

Babloo — Fri, 25 Sep 2015 13:23:52 GMT

I'm not getting the value of _n_ after I place the end statement. I should have get the value of _n_ for the first do lopp atleast, but not.

Re: If clause

arodriguez — Fri, 25 Sep 2015 13:44:41 GMT

After macro replacement your if clause is

if 1565<1565<1565+1565 then put 'success';
else put "notsucess";

1565 is not les than 1565 so the else clause is executed and print "notsucess" message

Re: If clause

PGStats — Fri, 25 Sep 2015 17:52:38 GMT

Logic:

1565 < 1565 < 1565+1565 is equivalent to

1565 < 1565 < 3130 is equivalent to

1565 < 1565 and 1565 < 3130

since 1565 is not < 1565, the result is FALSE

hence "not success".