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)
- 3 Answers
- 7573 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 |
for whom is sas data integration studio designed? : Sas-di
What is the order of application for output data set options, input data set options and SAS statements?
What is a method to debug and test your SAS program?
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
I need level 2 to 5 sas using companies in india
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
i have one dataset data l; input name: $ 25; cards; manoj is a good boy to krishna krishna is a god boy to malli malli is good boy to ramana ques: here i want "manoj" observations nubers
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
do you prefer proc report or proc tabulate? Why? : Sas programming
How do you connect the desktop application to metadata server? : sas-grid-administration
What does PROC print, and PROC contents do?
what are system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?
Teradata 
