i have a dataset with 100000 records. i want 100 records
from that dataset and create a dataset.we need to pick the
observations random order like
100obs,500obs,1020obs,1890obs,2565obs like that i need 100
obs in random order? how can we create this one?
Answers were Sorted based on User's Feedback
Answer / dilip
data A;
do slice = 100,500,1890,256,...100th;
set source point=slice;
output;
end;
stop;
run;
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sasuser
Hi Guys,
I slightly modified Dilip's answer.
I took Sashelp.shoes as the input dataset.
Following is the solution.
data A;
do i=1 to 100;
k=int(51*ranuni(2)+1);
do slice = K;
set sashelp.shoes point=slice;
output;
end;
end;
stop;
drop i k;
run;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pratik
data datasetname;(where you want create new dataset)
set datasetname1;(in which you have 100000 records)
if _N_(100,500,1020,1890,2565);
run;
proc print data=datasetname;
run;
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / suri
1)data ds2;
do i=100,1020,1890,2565;
set ds1 point=i;
output;
end;
stop;
run;
2)data ds2;
set ds1;
where _n_ in(100,1020,1890,2565);
run;
Is This Answer Correct ? | 0 Yes | 1 No |
How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
What is the difference between nodup and nodupkey options?
20 Answers iFlex, Makro, Talwar,
How would you remove a format that has been permanently associated with a variables?
Why double trailing @@ is used in input statement?
What do you feel about hardcoding?
Can you excute a macro within a macro? Describe.
How to read the file names of a text files from a shared drive using SAS?
How necessary is it to be creative in your work?
What is the difference between a PROC step and a DATA step?
What are the different versions of sas that you have used until now? : sas-grid-administration
Of all your work, where have you been the most successful?