What is _n_?
Answers were Sorted based on User's Feedback
Answer / chandra sekar
_N_ gives the record number. You can access any record in
the dataset using _N_ if you know the record number. It is
set as 1 for the first record and incremented for every
subsequent record. It is an automatic variable and is not
visible when you open a dataset. This can also be used to
subset a data. For ex, if you want to access the first 100
records then you can say "if _N_ <= 100".
| Is This Answer Correct ? | 63 Yes | 2 No |
Answer / vijay
suresh is write.
_n_ : gives the number of times SAS system looped through a
data step
Sudheer's answer is for _error_ :
_error_ : gives value of 0 or 1 depending on it is error or
not..if it is an error _error_ value will be 1 else 0
| Is This Answer Correct ? | 35 Yes | 10 No |
Answer / yadi acho
_n_ is auto number drive in SAS...
if use fro data step look like this
data test1;
set test;
test_field=_n_;
run;
diferent if auto number for SQL procedure u can use this
proc sql;
create table test1 as
select *,monotonic() as test_field
from test;
quit;
cheers!!
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / mallikarjuna raju
This is an automatic variable of PDV that returns the no of
observations that it has iterated.There are such variables
like _Error_,end=,in=,first.by-variable,last.by-variable,..etc
All these variables will not be displayed in the target output.
Ex:
Data new;
set <existed>;
if _n_>=2 and <=6 then output;
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / amaran
Can i used _n_ in proc sql; Or its only for Datasteo
_n_ is a Autometic variable created in a datastep. It is a
part of PDV. It is used to store the iteration count of the
Input statement.
Proc SQL doesnot create a PDV. so _n_ variable cannot be
used there.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / ragivenk189
It acts like a pointer and can be used to subset your data
set _n_=10 in data step will force SAS to process the data
until first 10 observations
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rajesh
Compiling time of the program in PDV automatically some
variables will generate, like _N_ and _Error_, _numeric_
_N_ will give the observation in the program. by default
_N_ value is 0, after compiling it will chage according to
the observations in the program.
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / guest
Can i used _n_ in proc sql; Or its only for Datasteo
| Is This Answer Correct ? | 0 Yes | 1 No |
data study; input Subj : $3. Group : $1. Dose : $4. Weight : $8. Subgroup; x= input(Weight,5.1); datalines; 001 A Low 220 2 002 A High 90 1 003 B Low 193.6 1 004 B High 165 2 005 A Low 123.4 1 ; Why does X get truncated? X shows up as 22 instead of 220,9 instead of 90 and 19.8 instead of 198? This problem doesnt happen with the values 193.6 and 123.4. This does not happen if x is read on the 5. informat instead of the 5.1 informat
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
Does anybody has SAS Platform Administration certification dumps. pls send to hariithepalli@gmail.com
what is washout period?
data abc; input x y ; cards; 1 2 5 6 7 8 7 8 1 7 5 7 ; run; Proc Freq data=abc; tables x*y / chisq nopercent nocol norow PLCORR; RUN; If we run the code, we have Polychoric Correlation = 0.9054 in the last table. I want to extract this particular entry with the value. Means I will create one dataset in which this value will be stored/extracted. I need your help in coding this. Please help me out.
explain the proc in sas? : Sas-administrator
why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?
how to assign a macro value to a variable?
wat has been most common programming mistake?
Difference between sum function and using “+” operator?
List out some key concept of SAS
i am importing large data from oracle to work library. in log there is a error message worklibrary space is not enough. then how to import the data safely to sas environment.