What is LAG function?How is it used? can any one explain
Answer Posted / basha
hai gajari
this is basha from chennai no phones no mails why? what
happened man?
ok lets see answer
lag function returns value from que
ex:-
data gajari;
input chindhi 8. @@;
datalines;
1 2 3 4 5
;
run;
data rao;
set gajari;
chore=lag(chindhi);
run;
output:-
obs chndhi chore
1 1 .
2 2 1
3 3 2
4 4 3
5 5 4
ok bye
take care
basha
TVS F&S
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
How many ways to overcome a missing values???
How would you define the end of a macro? : sas-macro
Name and describe few sas character functions that are used for data cleaning in brief.
If a variable contains only numbers, can it be a character data type?
What is a method to debug and test your SAS program?
how can you put a "trace" in your program? : Sas programming
What is the use of divide function?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
What is a put statement?
How do you connect the desktop application to metadata server? : sas-grid-administration
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
Explain append procedure?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
What is the command used to find missing values?