Please, anyone, let me know the style or an example of using
'by='/'by' variable of a PDV(Program Data Vector)
- 3 Answers
- 6930 Views
- Verinon Technology Solutions, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
What is maximum number of rows and cols can be handled in SAS?
Mention sas system options to debug sas macros.
In the flow of DATA step processing, what is the first action in a typical DATA Step?
What is the general format of function in sas? : sas-grid-administration
where are dashboard components are created and maintained? : Sas-bi
Explain what Proc glm does?
What is the basic syntax style in SAS?
I have 2 data sets A & B. Both have a variable called Age in them, each of them specifying a different functionality. In my program I use bot these data sets. How do I specify which Age variable I want to use?
How do dates work in sas?
what does the run statement do? : Sas programming
How do you add a number to a macro variable?
Teradata 
