How to select the observations randomly from a SAS dataset
Answers were Sorted based on User's Feedback
Answer / srinath
Proc surveyselect;
this gives the random selection of observations.
| Is This Answer Correct ? | 23 Yes | 1 No |
Answer / learner
By using ranuni function. for example you want select 30
percent of data randamly from a data set.
data x;
set y;
if ranuni(100)<.3 ;
run;
here 100 is the seed. the number generated depends on this
seed .
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / srikanth
you can use the RANUNI function to select observations
randomly.
Ex:-
data test;
input number @@;
cards;
2.1 3.1 4 6 2.2 4.9 4 5 3 3.3 4 5 3 4.3 5 7 3 3 9 11
;
data test1;
set test;
random=ranuni(1);
run;
%let k=10;
PROC SORT DATA=TEST1;
BY random;/*SORT OBSERVATIONS*/
run;
DATA TEST2;
SET TEST2 (DROP=RANDOM);
IF _N_ LE &K;
RUN;
PROC PRINT ;
RUN;
| Is This Answer Correct ? | 8 Yes | 6 No |
Answer / chowdary vamsi
using rununni function generate random sample observations
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / name is no need
I think by using mod operator we can select the random
observations.
syntax:mod(_n_,number);
| Is This Answer Correct ? | 5 Yes | 6 No |
i have a dataset with 25 obs; 10th obs has like ramu,anji,ramu,azad,ramu like this. i want to know how many times the word repeats in that obs?
what is change analysis in sas di ? : Sas-di
how to display duplicated observations in a data using base sas.
13 Answers HCL, TCS,
what is chi-square test? have you used that?
1 Answers Accenture, Quintiles,
what are all the reports you generated in your recent project?
0 Answers Accenture, Quintiles,
Best trainer in hyderabad for sas banking.if any one have details pls provide contact details.
There are 200 observations in a dataset, i want to pull out the observation no's 100, 150,180,190 by using Proc SQL? How you can get it?
Tell e how how dealt with..
Hi , which book should i refer to for preaparing SAS statistical Exam. Searched a lot on books but still did n't find relevant books
why is a stop statement needed for the point=option on a set statement? : Sas programming
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
What does the trace option do?