6) Explain about below automatic variables
a) _N_
b) _ERROR_
c) _CHAR_
d) _NUMERIC_
e) _ALL_
f) FIRST.BY VARIABLE
g) LAST.BY VARIABLE
h) _NAME_
i) _TYPE_
j) _FREQ_
k) _STAT_
l) _BREAK



6) Explain about below automatic variables a) _N_ b) _ERROR_ c) _CHAR_ d) _NUMERIC_ e) _ALL_ f..

Answer / vrana95

Automatic variables are created automatically in the data statements and they are added to the PDV but not ouput to
to the resulting dataset which we want.

1)_N_ : number of times the data step has iterated. initially it is 1 and it's counter increases +1 , every time data steps crosses the data statements.

2)_ERROR_: It is 0 by default but is set to 1 every time
the error is encountered.

3)_CHARACTER_ : could be defined in the arrays and other data step programming to include all the character variables.

4)_NUMERIC_ : To include all the numeric variables

5)First.by variable and LAST.By : Whenever, we define a BY parameter with the SET statement, by default two
automatic variables are created in the background and we can utilize them for limiting the rows which we are interested in . {http://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a000761931.htm}

7) _NAME_ : During transpose the variables you define in VAR statment are transposed and they comes in _NAME_ variable.

proc transpose data=x out=y prefix=m;
by variable1;
id variable2;
var variable3;
run;

8)_TYPE_ and _FREQ_: When you use PROC SUMMARY or PROC MEANS and we define Class parameter for two variables, and we use CHARTYPE in our Proc summary options, then
we get two automatic variables _TYPE_ and _FREQ_ . We can utilize it to limit the output we need.

9)_STAT_ :The default output of PROC MEANS, when no statistics are listed in the OUTPUT statement, is a data set containing a _STAT_ variable and the variables listed in the VAR statement. The output data set contains five records, one for each default statistic N, MIN, MAX, MEAN, and STD.

10) _BREAK_ : PROC report automatically create a variable
_BREAK_.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SAS Interview Questions

explain what is data set in sas? : Sas-administrator

0 Answers  


in the flow of data step processing, what is the first action in a typical data step? : Sas programming

0 Answers  


I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...

5 Answers   TCS,


What are the special input delimiters used in SAS?

0 Answers  


What procedure you used to calculate p-value?

2 Answers   Accenture, Quintiles,






What are the features of SAS?

0 Answers  


what are the advantages of using SAS in clinical data mangement? why should not we use other software products in managing clinical data?

2 Answers   Wockhardt,


/* To determine the maximum and minimum of V1 */ data before3; input v1 v2 v3; cards; 3 2 1 4 6 5 2 1 3 6 5 4 1 3 2 5 4 6 ; run;

5 Answers  


how do you validate sas program?

6 Answers   Accenture,


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

9 Answers  


How would you delete observations with duplicate keys?

6 Answers  


How would you identify a macro variable?

0 Answers  


Categories