STRATIFIED RANDOM SELCTION ISSUE

[Blandine]

I am doing a stratified random selection of 385 bridge based on 2 strata STRUCTURE_KIND_043A OWNER_022 and my data have STRUCTURE_NUMBER_008,STRUCTURE_KIND_043A, OWNER_022. the goal is to select a proportionate sample bridge based on the strata and I want to have the bridge number so I can make an analysis later on. however, with my code, I lost the bridge number somehow and I do not see the 385 bridge samples I was looking for. How do I retrieve it or is there a better way to do the stratified random selection with 2 different sample sizes of the strata?

here is my code

proc sort data=SUP.IDNBI_PSC_FILESTEST
out=SUP.IDNBI_PSCsort;
by STRUCTURE_KIND_043A OWNER_022; 
run;

proc surveyselect data=SUP.IDNBI_PSCsort n=385
out=SUP.IDNBI_PSCsamp; 
strata STRUCTURE_KIND_043A OWNER_022/ alloc=prop nosample;
run;

here is the result

[ballardw]

Check to make sure the variable is in the input data set.

If you do not include an ID statement to request specific variables then the procedure will have all variables from the input set in the output.

[Blandine]

I just did and all the input variable are there

[Blandine]

My output is still the same not sure why I am getting this issue.

any idea?

[ballardw]

Try adding an ID statement with the names of any variables that you do want in the output.

[Watts]

It looks like your code specifies the NOSAMPLE option in the STRATA statement. This option computes the allocation of the total sample size (among the strata) but doesn't select the sample. Your result is an allocation output data set, which provides the sample sizes for the strata. (The levels of your 2 STRATA variables form 19 strata.)

If you want to select the sample, you can just remove the NOSAMPLE option from the STRATA statement.