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
- 10337 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 |
Explain the difference between informat and format with an example.
What are the different versions of sas that you have used until now? : sas-grid-administration
What is data _null_?
how many types of prompts are there? : Sas-bi
what is the primary variable in your study?
I have a dataset with variables empid and doj how to calculate retirement age?
how to get second highest salary from a employee table and how get a 5th highest salary from a employee table?
How do you write a test plan?
what is null hypothesis? why do you consider that?
0 Answers Accenture, Quintiles,
How would you compile all macros from a folder in a study, within the autoexec program?
how to change the execute of macro
Is it possible to do sorting tranformation in charecter variable??if can tell me one eg..
Teradata 
