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
how many types of prompts are there? : Sas-bi
What do you code to create a macro? : sas-macro
how does sas handle missing values in a merge? : Sas programming
: and & modifiers.
Explain the use of proc print and proc contents?
which date function advances a date, time or datetime value by a given interval? : Sas programming
What is data _null_?
Do you need to rearrange the order of the data for the report?
List down the reasons for choosing sas over other data analytics tools.
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
What do the SAS log messages "numeric values have been converted to character" mean?
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
Describe the function and utility of the most difficult SAS macro that you have written?
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi