Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What is LAG function?How is it used? can any one explain

Answers were Sorted based on User's Feedback



What is LAG function?How is it used? can any one explain..

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

What is LAG function?How is it used? can any one explain..

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

What is LAG function?How is it used? can any one explain..

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

Post New Answer

More SAS Interview Questions

what are all the default values getting in PROC MEANS...???

2 Answers  


How would you keep from overlaying the a SAS set with its sorted version?

4 Answers  


what are sas bi dashboard components? : Sas-bi

0 Answers  


what are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?

1 Answers  


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

0 Answers  


Explain the difference between nodup and nodupkey options?

0 Answers  


We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B

3 Answers  


Explain data step in SAS

0 Answers  


Can we create datasets by proc step ? (Proc contents, Means)?

2 Answers  


Give some examples where proc report’s defaults are same as proc print’s defaults?

0 Answers  


explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di

0 Answers  


what is option year cuttoff in sas

2 Answers   L&T,


Categories