Interested to Buy Any Domain ? << Click Here >> for more details...
At compile time when a SAS data set is read, what items are
created?
- 14 Answers
- 30626 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chiranjeevi.p
SAS compiles the code• At compile time when a SAS data set
is read, what items are created?Automatic variables are
created. Input Buffer, PDV and Descriptor Information•
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / dharmendra sharma
Sas process data steps in two phase.
1) Compilation phase
2) Execution Phase
Compilation phase :- When sas see the 'DATA' statement it get to know that it needs to process this data-steps. During this compilation phase SAS did some pre-house preparation. In this case it set aside some portion of memory for storing sas dataset.
It initially creates input buffer that holds one line (observation) one time.
For this first it read INFILE from the dataset statement and then get to know that all types of variable we are going to read from the infile. It then find out that which variable is of what type and what it the record length. If we are reading list input (infile seperated using space delimeters) then it will assign 8 bytes length to each variable.
for characher 8 bytes means ---->>> 8 character.
for Numeric 8 bytes means ---->>> 14 to 15 significant digits.
Then this all information is stored in to the Descriptor portion. Here Compilation phase ended.
At the starting of Execution phase. Sas reads values from the input buffer and then stores these information in data variables one by one. And the values are stored in PDV, which write value in dataset at the end of the datastep --->>> because automatically sas put a OUTPUT statement at the end of each datastep.
During compilation phase sas also creates two variable autmatically:-
_N_ and _ERROR_
:) I hope we can have some good understanding related to PDV and Input buffer and Descriptor portion.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / priya
During compilation phase:
When an existing dataset is read, PDV and descriptive portion of output dataset will be created.
Input Buffer will be created only when a raw data file is being read.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mallikarjuna reddy
only PDV is generated at compilation time, where as _N_
_ERROR_ are generated at execution time only.
| Is This Answer Correct ? | 5 Yes | 7 No |
How will you assign all the variables of an dataset into a macro variable separated by a space? For example if a dataset has variables A,B,C. Assign them to a macro variable X as X=A B C
Which is the best training Institute for SAS Business Intelligence course?
To what type of programms have you used scratch macros?
What data sets do you need to produce the report?
In sas admin differentiate between roles and capabilities? : sas-grid-administration
How do you generate random samples?
What is the sas data set? : sas-grid-administration
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
explain the concepts and capabilities of business object? : Sas-bi
What is the difference between INPUT and INFILE ?
In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;
What do you feel about hardcoding?
Teradata 
