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...

Please, anyone, let me know the style or an example of using
'by='/'by' variable of a PDV(Program Data Vector)

Answer Posted / cutepa1

Thanks Rajesh, Here I got the appropriate answer for the
above question. A PDV has got such two variables like
'first.<BY-variable> and last.<BY-variable> apart from other
temporary variables. Here a BY-variable is the variable that
is mentioned in BY statement. a first.<var> returns 1 when a
first obs of that variable's datavalue is iterated or
contributed and returns 0 for the remaining other obs whose
datavalue of that specified variable in the BY-statement.
Respectively it returns 1 for when last obs is contributed
with the usage of last.<BY-variable> and returns 0 for the
rest of the observations.
Here I got an example
=======
data ex;
set emp; /* a source table retrived from Oracle emp */
by deptno; /* we can call 'deptno' as our BY-variable */
lead=first.deptno; /* new variable called lead that returns
the value either 1 or 0 basing on deptno*/
follow=last.deptno;
run;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how many types prompting framework can be broken down to? : Sas-bi

1049


What is a macro routine?

2668


Compare sas with other data analytics tools.

993


Intern stastical programmer written test

699


where to use sas business intelligence? : Sas-bi

1029


which date functions advances a date time or date/time value by a given interval? : Sas programming

918


what is data integration? : Sas-di

1078


What function CATX syntax does?

1183


What is connection profile? : sas-grid-administration

1133


What is the difference between nodupkey and nodup options?

995


What are the scrubbing procedures in sas?

964


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

1158


What are the difference between sas functions and procedures?

1094


what are some good sas programming practices for processing very large data sets? : Sas programming

889


How do you control the number of observations and/or variables read or written?

1209