BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Tal
Pyrite | Level 9 Tal
Pyrite | Level 9

i have a  file of students and  each student can appear more than once in it.

 

student score

100        A

100       B

100       C

101       A

101      B

102     A

103    B

103    A

103    C

.......

.........

i need to randomly select maximum to 2 records per student

 

Any idea how to achieve this guys please? 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

I think this might get you started. Since you may have some students with only one score if we want to use surveyselect which is designed for random sampling we need to describe how many records to pull for each student so the Proc Freq and Data step create a record for each student and if they only have one score then you get one requested, otherwise 2. Note that the output dataset from Surveyselect, Want, will have additional variables that can be used for weighting and tell what the probability of selection was.

proc freq data=have noprint;
   tables student/list out=temp;
run;

data samplesize;
   set temp;
   if count > 1 then _nsize_ = 2;
   else _nsize_ = 1;
run;

proc surveyselect data=have out=want
  sampsize=samplesize ;
  strata student;
run;

View solution in original post

5 REPLIES 5
ballardw
Super User

I think this might get you started. Since you may have some students with only one score if we want to use surveyselect which is designed for random sampling we need to describe how many records to pull for each student so the Proc Freq and Data step create a record for each student and if they only have one score then you get one requested, otherwise 2. Note that the output dataset from Surveyselect, Want, will have additional variables that can be used for weighting and tell what the probability of selection was.

proc freq data=have noprint;
   tables student/list out=temp;
run;

data samplesize;
   set temp;
   if count > 1 then _nsize_ = 2;
   else _nsize_ = 1;
run;

proc surveyselect data=have out=want
  sampsize=samplesize ;
  strata student;
run;
Tal
Pyrite | Level 9 Tal
Pyrite | Level 9

thanks ballardw

works  perfectly

interesting approach

 

thx again

data_null__
Jade | Level 19

The SELECTALL option provides a simplier solution.  No counting required.

data student;
   input (student score)($);
   cards;
100 A
100 B
100 C
101 A
101 B
102 A
103 B
103 A
103 C
;;;;
   run;
proc print;
   run;
proc surveyselect data=student seed=4354 n=2 out=sample2 selectall;
   strata student;
   run;
proc print;
   run;

Capture.PNG

ballardw
Super User

Good point @data_null__ I wish I could say that I was providing a more general solution where you had different selection rules based on counts within strata. But I just forgot the SELECTALL option as none of my stratified data gets close to the using all of the records in a stratum.

Tal
Pyrite | Level 9 Tal
Pyrite | Level 9

this is even shorter.

Thanks Data_Null, thanks guys

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 1007 views
  • 8 likes
  • 3 in conversation