What is LAG function?How is it used? can any one explain
Answers were Sorted based on User's Feedback
Answer / sheetal
lag function is used to look at the previous values as :
lag(<varaiable name>); gives you the the previous value .
| Is This Answer Correct ? | 15 Yes | 2 No |
Answer / 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 |
Answer / naveen
this Question was raised by saddi soorath....
lag function enables you to have the previous value.
we have the following data
Name num
Naveen 1
Naveen 2
Basha 1
Basha 2
so in data step
if u give num1 =lag(num) you will have the following result
Name num num1
Naveen 1 .
Naveen 2 1
Basha 1 .
Basha 2 1
Thanks and regards
| Is This Answer Correct ? | 3 Yes | 0 No |
What are all the problems you faced while validating tables and reports?
0 Answers Accenture, Quintiles,
how to intersect the tables by using PROC MIXED?
If you could design your ideal job, what would it look like?
I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.
what the use of proc glm
PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?
Explain how merging helps to combine data sets.
what are sas/access and sas/connect? : Sas programming
Mention some common errors that are usually committed in sas programming.
What does the RUN statement do?
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
how does sas handle missing values in an update? : Sas programming