Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

Answers were Sorted based on User's Feedback



i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we ..

Answer / solasa

we can use PROC SURVEY SELECT

Is This Answer Correct ?    8 Yes 2 No

i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we ..

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

i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we ..

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

i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we ..

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

i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we ..

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

Post New Answer

More SAS Interview Questions

What would be the value of month at the end of data step execution and how many observations would be there?

0 Answers  


What is the difference between a PROC step and a DATA step?

14 Answers   Accenture, HSBC,


· What are some good SAS programming practices for processing very large data sets?

6 Answers   Quintiles,


diff between nodup rec and ondup key???

3 Answers   AON, Sciformix,


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?

7 Answers   Accenture,


what is AE onset date and what is RDS?

4 Answers   Accenture,


what is the difference between proc means and proc tabulate?

3 Answers   Cognizant, CTS,


How many ways to overcome a missing values???

0 Answers   HSBC,


What does a PROC TRANSPOSE do?

8 Answers   Accenture,


Name few SAS functions?

0 Answers  


What is difference between sas rename and lable?

4 Answers  


Briefly describe 5 ways to do a "table lookup" in sas.

4 Answers   Quintiles,


Categories