topic Re: How To Control Retain Variable Value in SAS Programming

How To Control Retain Variable Value

dishant — Wed, 22 Jan 2014 10:12:06 GMT

Hi all,

My data set is Like This,

data chk;

input x;

datalines;

;

Run;

And My desired Output Look Like,

So Pls Guys Help Me out in this problem. Your Valuable Suggestion appreciate.

Thanks In Advance.

Regards,

Dishant Parikh

Re: How To Control Retain Variable Value

Peter_C — Wed, 22 Jan 2014 10:53:02 GMT

dishant

please

before I offer a solution

why!

is it really just a repeat of the first N obs where N goes from 1 to 5?

Message was edited by: Peter Crawford

Re: How To Control Retain Variable Value

dishant — Wed, 22 Jan 2014 10:59:44 GMT

Hi peter,

Actually I am Creating one Macro This Solution Will Helpful me a lot.

can you help me to reach the required output ,it would be grateful.

Re: How To Control Retain Variable Value

Peter_C — Wed, 22 Jan 2014 11:00:58 GMT

data fun;

do y= 1 to _n_ ;

set chk point= y ;

output ;

end ;

if _n_ >= 5 then stop ;

run ;

Re: How To Control Retain Variable Value

dishant — Wed, 22 Jan 2014 11:05:19 GMT

Hi Peter,

Thanks A lot For giving the answer and your valuable time.This Solution Will Helpful me a lot.

One More Question we can do with the any other logic or procedure?

Re: How To Control Retain Variable Value

Peter_C — Wed, 22 Jan 2014 12:26:07 GMT

Why is that not an adequate anserr?

did your One Macro need something else?

Message was edited by: Peter Crawford

Re: How To Control Retain Variable Value

dishant — Thu, 23 Jan 2014 04:48:07 GMT

Hi Peter,

yeah obviously its adequate answer and it takes me new level of thinking but as per your logic we need to pass total _n_ in if condition.

If suppose data get updated and few more observation added then again we need to change the if condition right?

So is their any logic in dynamic way.

Thanks In advance.

Re: How To Control Retain Variable Value

Peter_C — Thu, 23 Jan 2014 08:15:06 GMT

what error messages are you getting?

Re: How To Control Retain Variable Value

data_null__ — Thu, 23 Jan 2014 11:49:07 GMT

If you visit the online documentation regarding the SET statement you will find the NOBS option. Which should suffice for what you call "total _N_".

data chk;
  input x;
  datalines; 
12
23
34
11
45
; 
Run; 

data fun;
   group = _n_;
   do y= 1 to _n_;
      set chk point=y nobs=nobs;
      output; 
      end; 
   if _n_ >= nobs then stop; 
   run; 
proc print; 
   run;