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

Answers were Sorted based on User's Feedback



Please, anyone, let me know the style or an example of using 'by='/'by' variabl..

Answer / rajesh

list of 'by' variables tell SAS how data is stored in
source dataset or how it is to be represented in
output/output dataset.

PDV is used to write the observations in output dataset and
it does not get impected from any BY variable as data in
SAS always read sequencely. If BY vaialbes are there then
it just ensures that source dataset is sorted on list of BY
variables. It does not impact other thing.

Is This Answer Correct ?    2 Yes 0 No

Please, anyone, let me know the style or an example of using 'by='/'by' variabl..

Answer / 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

Please, anyone, let me know the style or an example of using 'by='/'by' variabl..

Answer / gajari rao

pls some one try to answer this question my friend is
waiting for your answer.

All the best pavan mandadi

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SAS Interview Questions

how to debug and test the sas program? : Sas-administrator

0 Answers  


how could you generate test data with no input data? : Sas programming

0 Answers  


How would you include common or reuse code to be processed along with your statements?

3 Answers   Accenture,


How to convert .xls file into CSV format?

6 Answers   Quintiles,


What are the limitations for memory allocation for SAS variables

0 Answers   Signetsoft,


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

0 Answers  


Difference between nodup and nodupkey options?

0 Answers  


How can a SAS WEB REPORT STUDIO USER identify which report tabs they have been permitted without entering the SAS WEB REPORT STUDIO

2 Answers   TCS,


If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn’t have a value?

3 Answers   Accenture,


What is the difference between order and group variable in proc report?

0 Answers  


For what purpose(s) would use the RETURN statement?

1 Answers  


1.What is the difference between _NULL_ , _ALL_, and _N_? 2.What are the uses of _NULL_ using in Data Steps? Can we _NULL_ in Proc Steps also? 3.How do call the macro variable in Data Steps? 4.How to construct Pivot tables in Excel Using SAS?

3 Answers  


Categories