01-22-2014 05:12 AM
My data set is Like This,
And My desired Output Look Like,
So Pls Guys Help Me out in this problem. Your Valuable Suggestion appreciate.
Thanks In Advance.
01-22-2014 05:53 AM
before I offer a solution
is it really just a repeat of the first N obs where N goes from 1 to 5?
Message was edited by: Peter Crawford
01-22-2014 05:59 AM
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.
01-22-2014 06:05 AM
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?
01-22-2014 11:48 PM
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.
01-23-2014 06:49 AM
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_".