ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  SAS
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
what is pdv? how it is related to input buffer in sas?
 Question Submitted By :: Natrajboga
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is pdv? how it is related to input buffer in sas?
Answer
# 1
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.
 
Is This Answer Correct ?    2 Yes 0 No
Vera Royzman
 
  Re: what is pdv? how it is related to input buffer in sas?
Answer
# 2
To add to it, Input buffer is the staging area for non sas
input.
 
Is This Answer Correct ?    0 Yes 2 No
Vinod Swarna
 
 
 
  Re: what is pdv? how it is related to input buffer in sas?
Answer
# 3
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.
 
Is This Answer Correct ?    0 Yes 0 No
Santhosh.lyathkula
 
  Re: what is pdv? how it is related to input buffer in sas?
Answer
# 4
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.
 
Is This Answer Correct ?    1 Yes 0 No
Anuj Goyal
 

 
 
 
Other SAS Interview Questions
 
  Question Asked @ Answers
 
Are you familiar with special input delimiters How are they used?  2
How do you put an elephant in the refrigerator? Oracle4
how do i read multiple spaces in datasets? eg: vijaya raghava perumal.I tried with using & but it workss if its vijaya raghava but not for raghava perumal.how to do this? Xansa4
What is the one statement to set the criteria of data that can be coded in any step?  2
what are input dataset and output dataset options? HCL5
DATA ABC; INPUT TDATE DATE9. AVG; CARDS; 18APR2008 150.00 19APR2008 167.00 20APR2008 123.00 21APR2008 145.00 ; RUN HOW CAN I FIND THE DIFFERENCE BETWEEN AVG OF 18APR2008 ANF 21APR2008?? IF ANY ONE GETS IT PLS TRY TO POST IT. Verinon-Technology-Solutions5
where will go the observations that were deleted by delete statement?  1
Name statements that are execution only?  6
what is fact table and factless table?  1
%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
what is SAS/Access and SAS/Connect?what are the uses?  2
How would you include common or reuse code to be processed along with your statements? PSCI5
Explain the message 'Merge has one or more datasets with repeats of by variables'.  2
What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file? Accenture1
what is the SAS/ACCESS and SAS/CONNECT? TCS4
define table lookup and how may ways it can be done...explian  2
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?  3
how do you validate sas program? Accenture3
What does a PROC TRANSPOSE do? Accenture2
How to select the observations randomly from a SAS dataset  4
 
For more SAS Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com