excellent thanks for your help. I believe that this macro must have been defined befroe but when i moved systems it needed to be added to the catalog. Thanks for the code sorted now
Mike
i think it will work, all you need to do is ensure that the lag value stays at the letter E value until it finds the next letter E and then update it.
Apologies i dont have time to write the step as im having a few issues with data myself....
Dunnes
Hi proximo,
im no expert but i use a lag step for a similar problem, which calculates the difference betweek 2 rows.
Not sure if its the exact step you need but have a read of this
http://www.lexjansen.com/mwsug/2006/ApplicationsDevelopment/AD08.pdf
Cheers
Dunnes
Hi,
i have recently moved from SAS 9.2 to 9.13 adn some of my code wont work any more. I have quite a large macro and i get an error message on the first instance of a few let functions.
Code:
data QSI_WealthSGout;
set wealthselfgenapp;
where BranchID eq &id;
run;
%let...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.