topic Re: How to obtain weighted estimates from Proc Tabulate in SAS Procedures

How to obtain weighted estimates from Proc Tabulate

Artp — Thu, 01 Jun 2017 18:46:28 GMT

Hello,

Using the code below does not generate weighted estimates. Is there a different way to get the expected results?

proc tabulate data = parents vardef=weight;

weight pwpwgt;

class parseg;

table parseg =' ' all,

n*f=7.0 pctn*f=9.1 /rts=25;

keylabel pctn = 'Percent'

all = 'Total';

format parseg prselfm.;

title 'Weighted Estimates Using vardef=weight in Proc Tabulate';

run;

Reference for vardef=weight:

https://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473731.htm#a000068934

Thanks,

Artp

Re: How to obtain weighted estimates from Proc Tabulate

ballardw — Thu, 01 Jun 2017 19:42:21 GMT

Tabulate N statistic reports just than, the number of values not the weighted n. You may want to consider adding a dummy variable with the value of 1 for each record, use that as a Var variable and request the sum and pctsum of that variable.

Re: How to obtain weighted estimates from Proc Tabulate

Artp — Fri, 02 Jun 2017 11:48:26 GMT

Thank you Grand Advisor for your feedback. This is the first time I am learning Proc Tabulate to analyze a huge survey data set. Can you please be more explicit?

Regards,

Artp

Re: How to obtain weighted estimates from Proc Tabulate

Ksharp — Fri, 02 Jun 2017 14:18:41 GMT

Did you try option of VAR statement.

proc tabulate data=sashelp.class;
class sex;
var height/weight=age;
table sex,height*mean;
run;

Re: How to obtain weighted estimates from Proc Tabulate

ballardw — Fri, 02 Jun 2017 15:59:30 GMT

@Artp wrote:

Thank you Grand Advisor for your feedback. This is the first time I am learning Proc Tabulate to analyze a huge survey data set. Can you please be more explicit?

Regards,

Artp

Is your survey sample from a simple random sample? If not such as a stratified sample, a cluster sample or almost any other sample type you may need to be looking into the Survey procs such as Surveymeans SurveyFreq SurveyLogistic and SurveyReg for analysis.

I would likely only use tabulate for the raw data to get a feel for sample counts, which your code did, and check skip patterns or recoding of variables.

Or display of values summarized from the survey procs.

Re: How to obtain weighted estimates from Proc Tabulate

Artp — Fri, 02 Jun 2017 16:25:39 GMT

Hello ballardw,

Your contribution is uplifting! I don't like going on weekends with unsolved mysteries. My problem was how to present the outputs from survey procedures (Surveyfreq and Surveymeans) - weighted freqs/estimates - in refined tables like those from Proc Tabulate or Report.

Archer R. Gravely's book "Your Guide To Survey Research Using the SAS System" does an excellent job presenting survey data tables/reports.

Have a great weekend,

Artp

Re: How to obtain weighted estimates from Proc Tabulate

Artp — Fri, 02 Jun 2017 17:18:08 GMT

Hi Ksharp,

SAS did not like the inclusion of "/weight=age" ; log said, "unknown variable."

Thank you,

Artp

Re: How to obtain weighted estimates from Proc Tabulate

ballardw — Fri, 02 Jun 2017 19:26:22 GMT

@Artp wrote:

Hi Ksharp,

SAS did not like the inclusion of "/weight=age" ; log said, "unknown variable."

Thank you,

Artp

The variable name after Weight= should be YOUR weight variable. Age was an example for the SASHELP.CLASS data set.