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
what is function of retain statment
explain about data integrator metadata reports? : Sas-di
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
Which are the statements whose placement in the data step is critical?
What are all the problems you faced while validating tables and reports?
what is sas and what are the functions? : Sas-administrator
What is the difference between using drop = data set option in data statement and set statement?
how many display types available in sas bi dashboard? : Sas-bi
What is the command used to find missing values?
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
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
What is a pdv and what are its functions?
How would you define the end of a macro?
Give some ways by which you can define the variables to produce the summary report (using proc report)?
What is the good sas programming practices for processing large data sets?