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
- 30524 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 |
Can you calculate the mean, median and mode of the following data set using data step logic? Don't use any function or procedure. data a; input age @@; datalines; 22 32 32 32 43 23 24 56 45 54 28 29 27 26 25 28 30 20 18 37 36 47 46 56 19 20 ; run; I have calculated the mean which i have posted in the answer section.
how to add distinctly var variable values ex.. Data a; input var; datalines; 0 1 2 3 -1 -2 -3 ; run; adding all +ve value in one varibale n do the same for -ve too
Do you need to rearrange the order of the data for the report?
How do i read multiple spaces in datasets?
Suppose there is a SAS dataset with following values - Parent Child A B B C D E F G G H H I and so on….. This goes onto 1000s of observations/rows. Now how do we identify from this dataset Grandparents and Grandchildrens ?
5 Answers American Express, Barclays,
How do you specify the number of iterations and specific condition within a single do loop?
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?
What are the automatic variables for macro? : sas-macro
how to rearrange the data as our wish by using dataset block?
What is the difference between verification and validation?
Difference between sum function and using “+” operator?
my problem is to export my report to xsl.i can do that.but the problem is my report has 3 headings first heading should be printed with the merging of (1-5)cells and heading 2 should be of merge(2-4)cells?how to do this condition?
Teradata 
