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 |
Describe the function and untility of the most difficult SAS macro that you have written.
is QUALCOMM using SAS ?
name the scheduler for scheduling job and explain the scheduler? : Sas-di
what is in stream data in SAS?
Are you familiar with special input delimiters? How are they used?
Did you used proc test? when?
0 Answers Accenture, Quintiles,
HOW DO WE CREATE A SAS STORED PROCESS IN SAS EG ?
What is the one statement to set the criteria of data that can be coded in any step?
how do you debug and test your sas programs? : Sas programming
If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?
Differentiate between sas functions and sas procedures.
How would you identify a macro variable?