Answer / vera royzman

Program data vector (PDV)is a logical area in memory where
SAS builds a data set, one observation at a time. When a
program executes, SAS reads data values from the input
buffer (a logical area in memory into which SAS reads each
record of raw data when SAS executes an INPUT statement) or
creates them by executing SAS language statements. The data
values are assigned to the appropriate variables in the
program data vector. From here, SAS writes the values to a
SAS data set as a single observation. When the DATA step
reads a SAS data set, SAS reads the data directly into the
program data vector.

Answer / anuj goyal

pdv is though a logical concept only but helps u to
understand the most important i.e, THE DATA STEP.
Two things u need to understand the compilation Phase and
the Execution Phase.
While reading a Raw data file:-

1) Compilation Phase - it checks for syntax errors and
conversion of ur data step into the machine code along with
creation of two things viz. INPUT BUFFER and PDV.
At the end of compilation phase u will have these two things
with u (Input Buffer and PDV).
In PDV all the variables present in the INPUT statement in
the data step will be give place in ur PDV as per the length
mentioned by u.

2) Execution Phase - Before beginning of the this phase all
the variables will be initialized to missing(if character)
and periods(if numeric)[use "put _all_" statement to check
ur PDV status in the log].
Then when the input statement is encountered for the first
time The first record from raw data file is moved from it to
ur INPUT BUFFER. Then one to one mapping is done and data is
then again moved to PDV(So u can can take input buffer as a
temporary storage area for ur data, one at a time). Then
when run statement is encountered, then the implicit OUTPUT
statement forces the read data row to the output data set.

Answer / santhosh.lyathkula

input buffer contains one record of Raw data.
PDV contains one observation of dataset.

input buffer is created at the time of reading raw data to
store raw data and send to PDV.

Answer / nanda katepalli

PDV is the program Data Vector. It takes each observation at
a time and allocates the length given in the input
statement.The allocation of spaces is done in the
compliation phase and the variables goes in it at the
execution phase.
Example:Builder builds the house but it is used by the people.
It has 2 variables by default which are _n_ and _error_.
_n_ gives us the observation number.
_error_ if their is no error then it is 0 or else it shows 1
even though we have 'n' no.of errors.
And then it creates 'n' no.of variables specified in the
data statement.
Input buffer is only needed for non sas files to
read the raw data and store in it. Where as, sas files do
not need the input buffer.
Example: Converting an Excel file into a sas file i.e while
converting it needs some space for storage.

Answer / vinod swarna

To add to it, Input buffer is the staging area for non sas
input.

How do you test for missing values?

0 Answers   Quintiles,

Name statements that function at both compile and execution time.

7 Answers   Accenture,

how many types of prompts are there? : Sas-bi

0 Answers  

If you?re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?

1 Answers  

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

0 Answers  

How do you debug and test your SAS programs? What can you learn from the SAS log when debugging? How do you test for missing values? How would you create multiple observations from a single observation? What are some good SAS programming practices for processing very large data sets? Briefly describe 5 ways to do a "table lookup" in SAS. Why is SAS considered self-documenting? Are you sensitive to code walk-throughs, peer review, or QC review? What other SAS features do you use for error trapping and data validation? How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

2 Answers  

/* This is example of age caluculate wihtout to display perfect days and years in output window */ data age; retain dob "12jun2003"d now "24may2011"d; age1=now-dob; age=(now-dob)/365.25; years=int(age); days1=round((age-years)*365.25); months=month(now)-1; if days1 gt 30 and months in(12,10,8,6,4,2)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month)*30.4375)+1; drop days1 month1 month; end; else if days1 gt 30 and months in (1,3,5,7,9,11)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month) *30.4375); drop days1 month1 month; end; drop age age1; proc print data=age; format dob now date.; run;

1 Answers   Emerio,

What are the main differences between sas versions 8.2, 9.0, 9.1?

4 Answers  

What is the Program Data Vector (PDV) and What are its functions?

9 Answers  

Name types of category in which SAS Informats are placed?

0 Answers  

%STPbegin;%STPEND; ERROR: No logical assign for filename _WEBOUT. WARNING: No body file. HTML output will not be created. unable to fix it.plz help

2 Answers  

Did you used proc test? when?

0 Answers   Accenture, Quintiles,