Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 10114 Views
- L&T, I also Faced
- E-Mail Answers
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 do you write a test plan?
which date function advances a date, time or datetime value by a given interval? : Sas programming
what is sas data set?
I have 2 data sets A & B. Both have a variable called Age in them, each of them specifying a different functionality. In my program I use bot these data sets. How do I specify which Age variable I want to use?
Have you been involved in editing the data or writing data queries?
1 Answers BioServe, Oracle, Sasken,
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
Explain the purpose of substr functions in sas programming.
What is the basic syntax of a sas program?
Difference between informat and format?
What are symget and symput? : sas-macro
how can you improve the performance of a query, If it is excuting very slowly?
What is the difference between INPUT and INFILE ?
Teradata 
