At compile time when a SAS data set is read, what items are
created?
Answer Posted / venkatesh.layam
when ever compiling time only inputbuffer will be created
while data set creation generally 3 steps been occureed
1.inputbuffer
2.pdv.
3.discription poortion
for external file:
when ever we import the external file that time input
buffer will be created.it happends in compilation phase
in the execution process the the pdv will be created
while execution 2 types of automatic variable will be
created.
_N_ :how many times datastep has been executed
_error_=by default the erroe=0 if have any errors more than
one it displays 1
data discriptior portion:in the data set column header
called data portion
and values portions called discription portion
using datalines:
when ever you use dataline for compilation and execution
directly pdv will be created but input buffer wil not be
created because only expternal data inputbuffer will be
created.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
describe about metadata object? : Sas-di
Give some examples where proc report’s defaults are same as proc print’s defaults?
What are the scrubbing procedures in sas?
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
Have you used macros? For what purpose you have used? : sas-macro
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
Explain the difference between informat and format with an example.
what is sas olap server? : Sas-di
Are you sensitive to code walk-throughs peer review or QC review?
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
what are the benefits of data integration? : Sas-di
how to remove duplicates using proc sql?
do you need to know if there are any missing values? : Sas programming
what can you learn from the sas log when debugging? : Sas programming
which date functions advances a date time or date/time value by a given interval? : Sas programming