topic Re: How to select the dataset out of survey function in SAS Programming

How to select the dataset out of survey function

Gustavo8 — Mon, 04 Nov 2019 19:47:59 GMT

Hi all :

Thanks for helps in this SAS community.

I have one more question that:

I used proc survey function to select some data from the data set, but I wan to change the rest of this dataset's variable to 9999 (which is a dummy number) and merge them back to one data set.

I tried to use the SQL function, but it doesn't work because the first survey dataset includes other output variables.

Here is the code and the dataset:

proc surveyselect data=ORD;

method=pps sampsize=125 out = randomsurvey_PPS ;

size b ;

run;

Thanks for your help!(I want to select the rest of 875 numbers as a new dataset and change the b =9999)

Re: How to select the dataset out of survey function

ballardw — Mon, 04 Nov 2019 20:13:36 GMT

Your example code won't run as shown. The semicolon after the input data set name will cause problems as the method, sampsize and out parameters are part of the Proc statement.

I thing that you want the OUTALL option on the Proc statement. Then all of the records of the input set are in the output with a variable, Selected, that indicates which records are the selected records with a value of 1 and 0 when not selected.

Then use a data step to set the variables as needed when Selected=0.

Re: How to select the dataset out of survey function

Watts — Wed, 06 Nov 2019 17:40:50 GMT

The OUTALL option isn't currently available with METHOD=PPS. (It's available with equal-probability selection methods.)

The approach in this post by @PeterClemmensen might do what you need.

Re: How to select the dataset out of survey function

PeterClemmensen — Wed, 06 Nov 2019 17:42:59 GMT

@Watts, boy do I wish I was the guy that wrote that answer. However, all the credit must go to @FreelanceReinh 🙂

Re: How to select the dataset out of survey function

Watts — Wed, 06 Nov 2019 17:47:01 GMT

Thanks for the correction. And thanks to @FreelanceReinh