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.

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;

Answer / gajari rao

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

All the best pavan mandadi

what other sas products have you used and consider yourself proficient in using? : Sas programming

0 Answers  

---

: and & modifiers.

0 Answers   Oracle,

---

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

0 Answers  

---

What is the good sas programming practices for processing large data sets?

0 Answers  

---

What is the difference between the proc sql and data step?

0 Answers  

---

---

You need to create an In List that it is to be later used in a Where Clause that includes all the Regions that begin with the letter A from the sashelp.shoes table. Using PROC SQL with an into clause create the following string from the sashelp.shoes table using the variable region “AFRICA”,”ASIA”,…..

3 Answers  

---

You need to perform an analysis on a massive dataset by groups, but are unable to sort the data due to memory constraint. How would you accomplish the task?

2 Answers  

---

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

3 Answers   Accenture,

---

Give e an example of..

0 Answers  

---

How can sas program be validated?

0 Answers  

---

Explain what is SAS informats?

0 Answers  

---

What is the difference between where and if statement?

0 Answers  

---