03-13-2015 12:53 PM
anybody can help me how can i initiate my _n_ from 1 when my condition is met.
I am using following code to do that. It is working but it has problem where _n_ is linked to 'IF' condition.
i.e. if _Type_ = 2 is appearing in row number 5 in my table "AirCont" then my call symputx outcome gives me the outome to 'Y5' , whereas I want that _N_ initiate/incriment only when condition is met.
if _Type_ = 2 then call symputx(compress('Y' || _n_),year);
03-13-2015 01:05 PM
Perhaps I don't understand the question?
If you want your own counter just make your own counter.
if _type_=2 then do;
call symputx(compress('Y' || n),year);
If you want to use the _N_ as the count of how many times the data step as iterated then change your IF to a WHERE.
where _type_=2 ;
call symputx(compress('Y' ||_n_),year);