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 are the prime responsibilities of data integration administrator? : Sas-di
is data integration and etl programming is same? : Sas-di
what is proc Index? and what is proc document?
Mention how to limit decimal places for the variable using proc means?
What is the basic syntax style in SAS?
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
explain the difference between proc means and proc summary?
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
Explain proc univariate?
What are the statements in proc sql?
What is the difference between proportion and average?
What is the use of divide function?
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
How to create an external dataset with sas code?
What is a method to debug and test your SAS program?