Proc Surveyfreq Example

Method: Run both FREQ and SURVEYFREQ. It calculates count/frequency and cumulative frequency of categories of a categorical variable. Make different output dat sets. As an example, suppose that you intend to use PROC REG to perform a linear regression, and you want to capture the R-square value in a SAS data set. This modification substitutes the degrees-of-freedom adjusted effective sample size for the original sample size in the confidence limit computations. We choose the STD option with the PROC means step. 6 million ED visits nationally over that same period. There should be 2 variables (Treatment and Result), each has two categories (X/Y; cured/not cured). The sample data consist of matched pairs. In other words, it returns the number and percentage of cases falling in. NLTS2 Study Overview 3. Function: to print the content of the data set. PROC SURVEYFREQ TABLE Statement. The SURVEYFREQ Procedure. Most of code shown in this seminar will work in earlier versions of SAS and SAS/Stat. I output all 5 test. 13% (but the output gives 25%) it should be 'proc. Biostat Methods STAT 5820/6910 - Handout #9 - Meta-Analysis Examples Example 1 A RCT was conducted to consider whether steroid therapy for expectant mothers affects death rate of premature [less than 37 weeks] newborns. The example uses data from a customer satisfaction survey for a student information system (SIS), a software product that provides modules for student registration, class scheduling, attendance, grade reporting, and other functions. Therefore, creating one table per one PROC SURVEYFREQ procedure is recommended:. The frequency count can be organized into a 2 X 2 table shown above. By extension, the Pearson Correlation evaluates whether there is statistical evidence for a linear relationship among the same pairs of variables in the population, represented by a population correlation. Simple Random Sampling This example illustrates how you can use PROC SURVEYMEANS to estimate pop-ulation means and proportions from sample survey. first example (PROC SURVEYFREQ), we provide code for how to analyze both the confidential and public CHIS data. Normalized weights: Is using them enough? zThe use of normalized (standardized) weights is an attempt to make adjustments in order to continue using one's usual software. We choose the STD option with the PROC means step. This is the primary reason for using PROC SURVEYFREQ instead of PROC FREQ. • Example: a survey of 50 SAS programmers finds that the average IQ is 130 + 10 • If we did 100 surveys, the average IQ should be between 120 and 140 in 95 of. To prepare the data, we completed the following steps:. The example above shows the statistics PROC SURVEYFREQ outputs by default. These tables include estimates of population totals and proportions , and the corresponding standard errors. Analyzing MCBS Data with PROC SURVEYFREQ The Maybe Cheesy but Simple Approach Christine E. This tutorial explains how to use PROC FREQ with various examples. Getting Started: SURVEYFREQ Procedure. As an example, suppose that you intend to use PROC REG to perform a linear regression, and you want to capture the R-square value in a SAS data set. To specify multiple table requests quickly, use a grouping syntax by placing parentheses around several variables and joining other variables or. PROC SURVEYFREQ excludes an observation from a cross-tabulation table if that observation has a missing value for any of the table, weight, or required sample design variables unless you specify the MISSING option. 0 procedures. METHODS: Wave 1 of the nationally representative PATH (Population Assessment of Tobacco and Health) study interviewed 10. IMPAIRED PRE- AND POST-INTERVENTION 18:58 Sunday,. BACKGROUND AND OBJECTIVES: Non-cigarette tobacco marketing is less regulated and may promote cigarette smoking among adolescents. Dead (0) Alive (1) Steroid (1) 36 496 Placebo (0) 60 478. Until recently, SAS programmers had to rely on other statistical software packages, such as SUDAAN, WesVar, and STATA, to produce accurate estimates of such statistics. Therefore, creating one table per one PROC SURVEY-FREQ procedure is recommended:. The following example shows how you can use PROC SURVEYFREQ to analyze sample survey data. DIFFERENCES IN THE PROC SURVEYFREQ AND PROC FREQ CODE. I'm studying on a large sample size (N: 500+) and when I do normality test (Kolmogorov-Simirnov and Shapiro-Wilk) the results make me confused because sig val. Histograms. Use the strata statement to specify the strata variable (sdmvstra) and account for design effects of stratification. Another goal was to assess the influence of several potential confounding variables on the strength training and insulin resistance relationship. How do I do the R equivalent of the SAS procedure 'PROC SURVEYFREQ', which creates frequency tables of sample survey data while accounting for stratum, cluster, and weight variables? I've been doing analysis in SAS that I'd prefer to do in R but I'm not sure what the equivalent function is. first example (PROC SURVEYFREQ), we provide code for how to analyze both the confidential and public CHIS data. In statistics, a histogram is a graphical display of tabulated frequency. This data set has 770 observations. However domain specific analysis can be obtained using Proc Surveyfreq by incorporating domain category in the table statement. PROC SurveyReg Examples | SAS Code Fragments /*Suppose that, in a junior high school, there are a total of 4,000 students in grades 7, 8, and 9. 44 and SAS/Stat 14. The following. Node 116 of 131. The SURVEYFREQ Procedure Tree level 1. This is a departure from older SAS procedures that provide OUT-PUT statements for similar functionality. Predictive In other sections of this chapter, you submit PROC TEMPLATE statements (either directly or through macros) to compile and save graph and style templates. The NHANES target population is the. Additional statistical keywords are available after the slash in the TABLE statement, many of which are counterparts to those available in the PROC SURVEYMEANS statement. 3220 Chapter 62. However domain specific analysis can be obtained using Proc Surveyfreq by incorporating domain category in the table statement. Alternatively, PROC SURVEYFREQ may be useful especially for the variables with more than two categories. The core of the macro %SINGLE contains two PROC SURVEYFREQ‟s and one PROC FREQ. If you request a replication method (bootstrap, BRR, jackknife, or replicate weights), the procedure estimates the variances as described in the section Replication Variance Estimation. Sample design information is provided in the WEIGHT, STRATA, and CLUSTER statements, and in the RATE= option in the PROC SURVEYFREQ statement. run; vbar tells SAS to produce a vertical bar chart/histogram. Example 1 A RCT was conducted to consider whether steroid therapy for expectant mothers affects death rate of premature [less than 37 weeks] newborns. 3% of all ED visits during that period. Destination. VAR : The Var statement tells SAS that these variables are analysis variables. The TABLES statement specifies frequency or crosstabulation tables and requests tests and statistics for those tables. statement is included within the. The following how - to - do example shows how to get domain specific results using Proc Surveyfreq. The chi-square test for association in PROC FREQ. This session will cover an overview of issues in analysis of complex sample data and illustrate use of some of these concepts using CPES data Analysis topics demonstrated with complex sample data adjustments during the CPES training. The system returned: (22) Invalid argument The Proc Surveyfreq Confidence Interval used for "post linear model" analyses. I am doing a 3 way comparison using PROC SURVEYFREQ - TABLES flag*year*age_cat*injury; This produces a table w/ the frequency of injuries in each age category (i. The chi-square statistic is requested from the SAS Survey Procedures procedure proc surveyfreq. Node 117 of 131. list in 1. Analysis of Complex Survey Data and Survival Analysis. I would consider using Proc Report rather than put statements to print it; once you get that going then you can put it into a macro and use macro variables to label the. Procedure Step. Census Bureau Nested multi -year estimates, a special case of estimates from overlapping samples in which one sample is wholly represented in the second sample, may be compared statistically using a t-test for overlapping groups. For the AHS, this method is Fay’s variation of the balanced repeated replications method. The SURVEYFREQ procedure produces one-way to n -way frequency and crosstabulation tables from sample survey data. The example uses data from a customer satisfaction survey for a student information system (SIS), which is a software product that provides modules for student registration, class scheduling, attendance, grade reporting, and other functions. The PROC SURVEYFREQ procedure is used in SAS to examine the relationship between two categorical variables and obtain chi-square statistics. age_cat) by year. With my first couple data extracts, PROC SURVEYFREQ and other survey procedures worked but then stopped. The following. In SAS, the easy way to compute the chi-square test for association is to use PROC FREQ. Node 116 of 131. This example then requests the same plot with some modifications. Function: to plot graphs. varmethod, strata, and. SPECIFYING YOUR SURVEY’S DESIGN IN SAS The rules used to select units from a population constitute a survey’s sample design and must be accounted for in SAS. Note that the Base SAS procedures (PROC MEANS, PROC FREQ, etc. Appendixes A through D provide examples (exact code and results) of using replicate weights for four different SAS statistical procedures: PROC SURVEYMEANS, PROC SURVEYFREQ, PROC SURVEYREG, and PROC SURVEYLOGISTIC. Getting Started: SURVEYFREQ Procedure. The Fisher Exact test in SAS is a test of significance that is used in the place of chi-square test SAS in 2 by 2 tables, especially in cases of small samples. The system returned: (22) Invalid argument The Proc Surveyfreq Confidence Interval used for "post linear model" analyses. Most of code shown in this seminar will work in earlier versions of SAS and SAS/Stat. Method: Run both FREQ and SURVEYFREQ. Overview; Getting Started; Specifying the Sample Design Domain Analysis Missing Values Statistical Computations Output Data Sets Displayed Output ODS Table Names ODS Graphics. The basic structure of PROC SURVEYFREQ code has some similarities to PROC FREQ, but also has several key differences: PROC FREQ < options > ; BY variables ; EXACT statistic-options < / computation-options > ;. Alternatively, PROC SURVEYFREQ may be useful especially for the variables with more than two categories. The example given on that page is PROC SURVEYREG, and it uses the IPUMS-USA variable names rather than the Census Bureau's variable names. The SURVEYFREQ procedure produces one-way to n-way frequency and crosstabulation tables from sample survey data. 0 procedures. To find out what version of SAS and SAS/Stat you are running, open SAS and look at the information in the log file. 0, which is the sum of the Wilcoxon scores for the smaller sample (Active). PROC SURVEYFREQ TABLE Statement. They are used to create summary statistics. This example uses #BYVAL1 for the SHEET_NAME suboption so that the name is the value of the MAKE variable. proc freq data = "c:\book\help. Is there is a way to use the Cochran-Armitage trend test in *proc surveyfreq* and make it works. A BY statement is added to the PROC REPORT step so that one table is created for each value of MAKE. EXAMPLE 2 - FREQUENCY ANALYSIS OF MULTI-WAY TABLE WITH ODS GRAPHICS AND ODDS RATIO PLOT Example 2 demonstrates a weighted frequency table analysis with odds ratios and complex sample design corrected confidence intervals produced by PROC SURVEYFREQ. Overview; Getting Started; Specifying the Sample Design Domain Analysis Missing Values Statistical Computations Output Data Sets Displayed Output ODS Table Names ODS Graphics. To find out what version of SAS and SAS/Stat you are running, open SAS and look at the information in the log file. The WEIGHT and REPWEIGHT variables are the same as the PROC SURVEYFREQ example above. The first PROC SURVEYFREQ calculates the weighted percent of a given category‟s population that is identified as treated (weighted row percent), with a 95% confidence interval: PROC SURVEYFREQ data=f nosummary; tables &var*TX/cl row nostd;. vbar varl var2;. The following. shoes (where= (stores < 20) obs= 10); run; The above code lists the first 10 observations where (stores < 20). sas is also included to label your dataset. A BY statement is added to the PROC REPORT step so that one table is created for each value of MAKE. first example (PROC SURVEYFREQ), we provide code for how to analyze both the confidential and public CHIS data. Proc Gplot. This example then requests the same plot with some modifications. varmethod=taylor. Here are examples of the codes I am attempting to run: proc SURVEYFREQ data=IHISR; strata STRATA; cluster PSU; weight SAMPWEIGHT; TABLES SEXORIEN; run ; proc SURVEYREG data=IHISR ALPHA=. Therefore, creating one table per one PROC SURVEY-FREQ procedure is recommended:. sas7bdat"; tables female*homeless / chisq; run; resulting in Statistics for Table of FEMALE by HOMELESS. sas7bdat"; tables female*homeless / chisq; run; resulting in Statistics for Table of FEMALE by HOMELESS. 0 procedures. The example uses data from a customer satisfaction survey for a student information system (SIS), which is a software product that provides modules for student registration, class scheduling, attendance, grade reporting, and other functions. Thus, the option is always VARMETHOD=BRR(FAY). Histograms. The SAS library in which the DS_147 file is placed for the syntax examples is named work. However domain specific analysis can be obtained using Proc Surveyfreq by incorporating domain category in the table statement. I don't use SAS; so I can't comment on whether the following replicate SAS PROC FREQ, but these are two quick strategies for describing variables in a data. The example above shows the statistics PROC SURVEYFREQ outputs by default. Frequencies The example syntax below uses the SURVEYFREQ procedure to obtain frequencies (incidence estimates) for variable PAH (Physical Abuse: Harm Standard). Most of code shown in this seminar will work in earlier versions of SAS and SAS/Stat. sas7bdat"; tables female*homeless / chisq; run; resulting in Statistics for Table of FEMALE by HOMELESS. proc chart data =name;. The following. Chi Square Tutorial. The SURVEYFREQ Procedure The SURVEYIMPUTE Procedure Power and Sample Size Tree level 1. Ulitmately, I want an outputted dataset with the Weighted Freqency and Percent for injury for each age category and year. Therefore, creating one table per one PROC SURVEY-FREQ procedure is recommended:. Use the options sum, clsum, mean, and clm to request the sum, confidence interval for the sum, mean, and confidence limit of the mean, respectively, of the variable TOTALBTUSPH. Proc freq is an excellent tool to check for missing values in your dataset. This estimate corresponds to 2. And shouldn't the the. The SURVEYREG Procedure. The main objective of the present study was to assess the association between participation in strength training and insulin resistance. 3 User's Guide. PROC SurveyReg Examples | SAS Code Fragments /*Suppose that, in a junior high school, there are a total of 4,000 students in grades 7, 8, and 9. Ice Cream Spending Analysis Simple Random Sampling Design The SURVEYREG Procedure. The bivariate Pearson Correlation produces a sample correlation coefficient, r, which measures the strength and direction of linear relationships between pairs of continuous variables. The differences between the FREQ procedure and PROC SURVEYFREQ are highlighted in yellow above. age_cat) by year. Proc Tabulate is mainly used to create a professional looking table. ) do not account for the complex sample design. PROC means DATA = dataset STD; Following is the description of the parameters used − Dataset − is the name of the dataset. Make different output dat sets. TABLE : The Table statement tells SAS which. The CLUSTER statement specifies cluster identification variables in a clustered sample design. This estimate corresponds to 2. The PROC SURVEYFREQ procedure is used in SAS to examine the relationship between two categorical variables and obtain chi-square statistics. Proc Gplot. The chi-square statistic is requested from the SAS Survey Procedures procedure proc surveyfreq. (REGIONC) is added. The Fisher Exact test in SAS is a test of significance that is used in the place of chi-square test SAS in 2 by 2 tables, especially in cases of small samples. Overview; Getting Started; Specifying the Sample Design Domain Analysis Missing Values Statistical Computations Output Data Sets Displayed Output ODS Table Names ODS Graphics. The following how - to - do example shows how to get domain specific results using Proc Surveyfreq. One caveat in creating multiple tables in one PROC SURVEYFREQ procedure is that the procedure takes the smallest applicable sample sizes among all va riables. Use the strata statement to specify the strata variable (sdmvstra) and account for design effects of stratification. To adapt the PROC SURVEYFREQ code you've written here, you can just drop the STRATA statement and use the REPWEIGHTS statement found in the IPUMS-USA example. The following example shows how you can use PROC SURVEYFREQ to analyze sample survey data. Stack Overflow for Teams is a private, secure spot for you and your coworkers to find and share information. The following how - to - do example shows how to get domain specific results using Proc Surveyfreq. Example 1 A RCT was conducted to consider whether steroid therapy for expectant mothers affects death rate of premature [less than 37 weeks] newborns. PROC statement to indicate the method to develop the replicate weights. This modification substitutes the degrees-of-freedom adjusted effective sample size for the original sample size in the confidence limit computations. The SASHELP. The system returned: (22) Invalid argument The the discussions of the FORMAT statement and SAS formats in SAS Language Reference: Dictionary. The WEIGHT and REPWEIGHT variables are the same as the PROC SURVEYFREQ example above. 0006 Sample Size = 15121. Among these, 92% were coded with dizziness as a presenting symptom (Figure 1). Understanding and Using NAMCS and NHAMCS Data Part 2 –Using public-use files Eric Nawar Ambulatory Care Statistics Branch Division of Health Care Statistics U. run; vbar tells SAS to produce a vertical bar chart/histogram. Elements of SAS/GRAPH Overview Taken from SAS 9. The purpose of this workshop is to explore some issues in the analysis of survey data using SAS 9. The PROC SURVEYFREQ procedure is used in SAS to examine the relationship between two categorical variables and obtain chi-square statistics. However, when the proportional odds. The following. The SURVEYFREQ Procedure Tree level 1. Ice Cream Spending Analysis Simple Random Sampling Design The SURVEYREG Procedure. Function: to perform regression analysis. proc freq data = "c:\book\help. 9797 Num DF 3 Den DF 27 Pr > Adj F 0. This estimate corresponds to 2. PROC SURVEYFREQ uses the modification described in Korn and Graubard to compute design-based Clopper-Pearson (exact) and Wilson (score) confidence limits. Learn more How to conduct SAS Proc SurveyFreq with strata in Python?. proc surveyfreq data=food; For example, Sex 1 and Status 1 =36. The SURVEYFREQ Procedure. In summary, McNemar's test is appropiate if the following assumptions are met: The sample data have been randomly selected. This estimate corresponds to 2. Additional statistical keywords are available after the slash in the TABLE statement, many of which are counterparts to those available in the PROC SURVEYMEANS statement. This procedure can handle complex survey sample designs, including designs with stratification, clustering, and unequal weighting. As an example, we'll revisit the table of homelessness vs. In SAS, the easy way to compute the chi-square test for association is to use PROC FREQ. com The SURVEYFREQ Procedure. There should be 2 variables (Treatment and Result), each has two categories (X/Y; cured/not cured). One caveat in creating multiple tables in one PROC SURVEYFREQ procedure is that the procedure takes the smallest applicable sample sizes among all va riables. The SAS library in which the DS_147 file is placed for the syntax examples is named work. If things go well hopefully the data will be matched one for each by-variable. For this example, the SASHELP. The core of the macro %SINGLE contains two PROC SURVEYFREQ‟s and one PROC FREQ. The following example shows how you can use PROC SURVEYFREQ to analyze sample survey data. Statistical Graphics Using ODS. I don't use SAS; so I can't comment on whether the following replicate SAS PROC FREQ, but these are two quick strategies for describing variables in a data. SAS histogram differs from a bar chart in that it is the area of the bar that denotes the value, not the height. I could not make it work with it. pdf Read/Download File Report Abuse. They are used to create summary statistics. Node 21 of 0. ESTIMATE PROP. Ulitmately, I want an outputted dataset with the Weighted Freqency and Percent for injury for each age category and year. The basic structure of PROC SURVEYFREQ code has some similarities to PROC FREQ, but also has several key differences: PROC FREQ < options > ; BY variables ; EXACT statistic-options < / computation-options > ;. 0003 Adj F Value 7. 05 but skewness and curtosis. For this example, Census region (REGIONC) is added. The following example shows how you can use PROC SURVEYFREQ to analyze sample survey data. The purpose of this workshop is to explore some issues in the analysis of survey data using SAS 9. DEPARTMENT OF HEALTH AND HUMAN SERVICES Centers for Disease Control and Prevention National Center for Health Statistics. proc freq is used to produce frequency tables (categorical data only). Print a subset of observations when a condition is true just to see examples (not all situations) where the condition exists in your data: /** WHERE subsets the data * * before OBS subsets the data */ proc print data= sashelp. Procedure Step. The SURVEYFREQ procedure produces one-way to n -way frequency and crosstabulation tables from sample survey data. One caveat in creating multiple tables in one PROC SURVEYFREQ procedure is that the procedure takes the smallest applicable sample sizes among all va riables. To prepare the data, we completed the following steps:. You can ask PROC FREQ to construct and print frequency and crosstab tables for selected variables in the data set by using the TABLES statement. 0006 Sample Size = 15121. TABLE : The Table statement tells SAS which. I'm studying on a large sample size (N: 500+) and when I do normality test (Kolmogorov-Simirnov and Shapiro-Wilk) the results make me confused because sig val. If you request a replication method (bootstrap, BRR, jackknife, or replicate weights), the procedure estimates the variances as described in the section Replication Variance Estimation. SAS In SAS, Cramer's V is provided when the chisq option to the tables statement is used, in proc freq. age_cat) by year. PROC SURVEYFREQ uses the modification described in Korn and Graubard to compute design-based Clopper-Pearson (exact) and Wilson (score) confidence limits. gender we present in Section 2. The SURVEYFREQ Procedure. The following. Getting Started: SURVEYFREQ Procedure. Thus, the option is always VARMETHOD=BRR(FAY). The first PROC SURVEYFREQ calculates the weighted percent of a given category‟s population that is identified as treated (weighted row percent), with a 95% confidence interval: PROC SURVEYFREQ data=f nosummary; tables &var*TX/cl row nostd;. Procedure Step. Introduction to Power and Sample Size Analysis. IMPAIRED PRE- AND POST-INTERVENTION 18:58 Sunday, July 26, 2015 1 FOR THIN LIQUID SWALLOW TASKS The SURVEYFREQ Procedure Data Summary Number of Clusters 30 Number of Observations 360 Table of time_cat by pas_ind time_cat pas_ind Frequency Percent Std Err of Sample Size = 355. Take advantage of PROC FREQ output, since tis labeled ok, MERGE with surveyfreq output WITHOUT A BY VARIABLE (!!!). In this example, the PLOT statement uses a plot request of the type y-variable*x-variable to plot the variable HEIGHT against the variable WEIGHT. The example above shows the statistics PROC SURVEYFREQ outputs by default. The SURVEYFREQ procedure produces one-way to n-way frequency and crosstabulation tables from sample survey data. Print a subset of observations when a condition is true just to see examples (not all situations) where the condition exists in your data: /** WHERE subsets the data * * before OBS subsets the data */ proc print data= sashelp. The SASHELP. The purpose of this workshop is to explore some issues in the analysis of survey data using SAS 9. Re: manipulating Proc SurveyFreq ODS table output #4 On Thu, 22 Jan 2009 15:09:39 -0600, Mary wrote: It looks like you are headed in the right direction. PROC SURVEYMEANS, PROC SURVEYFREQ, PROC SURVEYREG and PROC SURVEYLOGISTIC) to address this issue. " and not in the way as it was in other examples I am. 3% of all ED visits during that period. It will also discuss the available options and limitations of each package. Most of code shown in this seminar will work in earlier versions of SAS and SAS/Stat. NLTS2 Study Overview 3. NLTS2 Study Design and Sampling NLTS2 Data Sources, either 4. varmethod, strata, and. The following data are from several examples in the PROC FREQ documentation. The SURVEYPHREG Procedure. (REGIONC) is added. SAS In SAS, Cramer's V is provided when the chisq option to the tables statement is used, in proc freq. For this example, the SASHELP. I am doing a 3 way comparison using PROC SURVEYFREQ - TABLES flag*year*age_cat*injury; This produces a table w/ the frequency of injuries in each age category (i. The PROC SURVEYFREQ procedure is used in SAS to examine the relationship between two categorical variables and obtain chi-square statistics. Here, PROC FREQ can also be very helpful. Expectant mothers at risk were randomly assigned to steroid and placebo. The SURVEYIMPUTE Procedure Tree level 1. This example uses #BYVAL1 for the SHEET_NAME suboption so that the name is the value of the MAKE variable. ) do not account for the complex sample design. A BY statement is added to the PROC REPORT step so that one table is created for each value of MAKE. The SASHELP. 05 but skewness and curtosis. The main objective of the present study was to assess the association between participation in strength training and insulin resistance. One caveat in creating multiple tables in one PROC SURVEYFREQ procedure is that the procedure takes the smallest applicable sample sizes among all variables. The following how - to - do example shows how to get domain specific results using Proc Surveyfreq. sas7bdat"; tables female*homeless / chisq; run; resulting in Statistics for Table of FEMALE by HOMELESS. PROC SURVEY Procedures in SAS ®. The effect Income is significant in the linear regression model, while the effect Kids is not significant at the 5% level. Frequencies for demographics, risk behaviors, and mental health variables are all provided and reviewed. This tutorial explains how to use PROC FREQ with various examples. The SURVEYFREQ Procedure Tree level 1. Additional statistical keywords are available after the slash in the TABLE statement, many of which are counterparts to those available in the PROC SURVEYMEANS statement. Among these, 92% were coded with dizziness as a presenting symptom (Figure 1). Introduction to Power and Sample Size Analysis. The SURVEYLOGISTIC procedure fits logistic regression models for discrete response survey data by maximum likelihood, incorporating the sample design into the analysis. A BY statement is added to the PROC REPORT step so that one table is created for each value of MAKE. proc surveyfreq data=df; table C01Q01 / cl; strata strata; weight wtfinal; run; I'm currently searching for answers/packages and have found some for weighted analysis but so far I'm not sure how to incorporate strata into the analysis. It will also discuss the available options and limitations of each package. The SURVEYFREQ Procedure. Getting Started: SURVEYFREQ Procedure. Global Statements. Getting Started: SURVEYFREQ Procedure. However domain specific analysis can be obtained using Proc Surveyfreq by incorporating domain category in the table statement. proc crosstab (SUDAAN) versus SAS proc surveyfreq Is there anyone who has experience with SUDAAN's proc crosstab and SAS' pro= c surveyfreq? I ran the two procedures on the same data to get proportions = and chi square=2C but the chi square p values differ greatly. This is the primary reason for using PROC SURVEYFREQ instead of PROC FREQ. HBSv48; 1226 tables demodata*sex /col row nostd nowt wchisq chisq1 expected; 1227 stratum sdmvstra; 1228 cluster sdmvpsu; 1229 weight MEC6YR; 1230 run; NOTE: 578 observations were omitted due to nonpositive weights. Statistical Graphics Using ODS. 0, which is the sum of the Wilcoxon scores for the smaller sample (Active). If the assumptions for using the chi-square test are not met (i. com The SURVEYFREQ Procedure. PROC means DATA = dataset STD; Following is the description of the parameters used − Dataset − is the name of the dataset. Elements of SAS/GRAPH Overview Taken from SAS 9. Introduction to Power and Sample Size Analysis. Note that the Base SAS procedures (PROC MEANS, PROC FREQ, etc. Therefore, creating one table per one PROC SURVEYFREQ procedure is recommended:. The “Examples” section on page 3205 provides more complicated examples to illustrate the applications of PROC SURVEYMEANS. The SURVEYFREQ Procedure Table of RIAGENDR by BPACSZ Controlling for sel=Age lt 20 Wald Log-Linear Chi-Square Test Chi-Square 25. Among these, 92% were coded with dizziness as a presenting symptom (Figure 1). Histograms in SAS allow you to explore your data by displaying the distribution of a continuous variable (percentage of a sample) against categories of the. The following example shows how you can use PROC SURVEYFREQ to analyze sample survey data. The frequency count can be organized into a 2 X 2 table shown above. 3 User's Guide. 44 and SAS/Stat 14. If things go well hopefully the data will be matched one for each by-variable. They must be numeric. Another goal was to assess the influence of several potential confounding variables on the strength training and insulin resistance relationship. The following statements must be included to provide the stratification and. 0, which is the expected value under the. This session will cover an overview of issues in analysis of complex sample data and illustrate use of some of these concepts using CPES data Analysis topics demonstrated with complex sample data adjustments during the CPES training. 0 procedures. age_cat) by year. The SURVEYPHREG Procedure. Proc freq is an excellent tool to check for missing values in your dataset. Here, PROC FREQ can also be very helpful. PROC SURVEY Procedures in SAS ®. This paper examines the differences between the Proc Surveymeans and Proc Surveyfreq procedures and the corresponding SAS®-callable SUDAAN v8. The summary table below provides an example of how to code for a chi-square test in SAS. The SURVEYFREQ Procedure. 3 User's Guide. As an example, suppose that you intend to use PROC REG to perform a linear regression, and you want to capture the R-square value in a SAS data set. This modification substitutes the degrees-of-freedom adjusted effective sample size for the original sample size in the confidence limit computations. example below. Use the options sum, clsum, mean, and clm to request the sum, confidence interval for the sum, mean, and confidence limit of the mean, respectively, of the variable TOTALBTUSPH. Histograms. varmethod, strata, and. At some set time after. Multinomial Logistic Regression Models with SAS® PROC SURVEYLOGISTIC Marina Komaroff, Noven Pharmaceuticals, New York, NY ABSTRACT Proportional odds logistic regressions are popular models to analyze data from the complex population survey design that includes strata, clusters, and weights. One caveat in creating multiple tables in one PROC SURVEYFREQ procedure is that the procedure takes the smallest applicable sample sizes among all variables. The basic syntax for applying cross tabulation in SAS is − PROC FREQ DATA = dataset; TABLES variable_1*Variable_2;. The first PROC SURVEYFREQ calculates the weighted percent of a given category‟s population that is identified as treated (weighted row percent), with a 95% confidence interval: PROC SURVEYFREQ data=f nosummary; tables &var*TX/cl row nostd;. I am doing a 3 way comparison using PROC SURVEYFREQ - TABLES flag*year*age_cat*injury; This produces a table w/ the frequency of injuries in each age category (i. DIFFERENCES IN THE PROC SURVEYFREQ AND PROC FREQ CODE. This tutorial explains how to use PROC FREQ with various examples. Is there is a way to use the Cochran-Armitage trend test in *proc surveyfreq* and make it works. Like the other survey procedures, PROC SURVEYFREQ computes these variance estimates based on the sample design used to obtain the survey data. SAS: Proc GPLOT Computing for Research I Robert Allison 's SAS Graph Examples. There should be 2 variables (Treatment and Result), each has two categories (X/Y; cured/not cured). In the example below I have taken the liberty of including a variable. Node 116 of 131. Leonard, Data Consultant, Dover*, New Hampshire ABSTRACT PROC SURVEYFREQ comes to the rescue for SAS® programmers who need to analyze stratified and weighted data such as the MCBS (Medicare Current Beneficiary Survey) 1. The frequency count can be organized into a 2 X 2 table shown above. The “Examples” section on page 3205 provides more complicated examples to illustrate the applications of PROC SURVEYMEANS. Alternatively, PROC SURVEYFREQ may be useful especially for variables with more than two categories. One caveat in creating multiple tables in one PROC SURVEYFREQ procedure is that the procedure takes the smallest applicable sample sizes among all va riables. The chapter begins with a simple example pointing out how PROC SURVEYMEANS and PROC SURVEYFREQ produce equivalent results for certain univariate, descriptive statistics. The bivariate Pearson Correlation produces a sample correlation coefficient, r, which measures the strength and direction of linear relationships between pairs of continuous variables. Note that the Base SAS procedures (PROC MEANS, PROC FREQ, etc. The NHANES target population is the. 2 documentation ODS. Print a subset of observations when a condition is true just to see examples (not all situations) where the condition exists in your data: /** WHERE subsets the data * * before OBS subsets the data */ proc print data= sashelp. To adapt the PROC SURVEYFREQ code you've written here, you can just drop the STRATA statement and use the REPWEIGHTS statement found in the IPUMS-USA example. Expectant mothers at risk were randomly assigned to steroid and placebo. PROC SURVEYFREQ TABLE Statement. You want to now how household income and the number of children in a household affect students' average weekly spending for ice cream. example below. Therefore, creating one table per one PROC SURVEY-FREQ procedure is recommended:. The SURVEYFREQ procedure produces one-way to n -way frequency and crosstabulation tables from sample survey data. The documentation for the procedure lists all ODS tables that the procedure can create , or you can use the ODS TRACE ON statement to display the table names that are produced by PROC REG. Analyzing MCBS Data with PROC SURVEYFREQ The Maybe Cheesy but Simple Approach Christine E. Introduction to Power and Sample Size Analysis Tree level 1. I would consider using Proc Report rather than put statements to print it; once you get that going then you can put it into a macro and use macro variables to label the. Besides, it should be 'proc surveyfreq' and not just 'proc freq' as I am trying to generate estimates for entire population. Use the options sum, clsum, mean, and clm to request the sum, confidence interval for the sum, mean, and confidence limit of the mean, respectively, of the variable TOTALBTUSPH. Elements of SAS/GRAPH PROC GPLOT: Specifying an input data set Similar to all other SAS PROC's. Proc Tabulate is mainly used to create a professional looking table. Getting Started: SURVEYFREQ Procedure. Expectant mothers at risk were randomly assigned to steroid and placebo. , small expected numbers in one or more cells), then an alternative hypothesis test to use is Fisher exact test. PROC statement to indicate the method to develop the replicate weights. To specify multiple table requests quickly, use a grouping syntax by placing parentheses around several variables and joining other variables or. ) do not account for the complex sample design. 05 but skewness and curtosis. A formats file DS_147f. To produce a horizontal bar chart/histogram replace vbar with hbar. The example uses data from a customer satisfaction survey for a student information system (SIS), which is a software product that provides modules for student registration, class scheduling, attendance, grade reporting, and other functions. To adapt the PROC SURVEYFREQ code you've written here, you can just drop the STRATA statement and use the REPWEIGHTS statement found in the IPUMS-USA example. I'm studying on a large sample size (N: 500+) and when I do normality test (Kolmogorov-Simirnov and Shapiro-Wilk) the results make me confused because sig val. The bivariate Pearson Correlation produces a sample correlation coefficient, r, which measures the strength and direction of linear relationships between pairs of continuous variables. PROC SURVEYFREQ: Examples :: SAS/STAT(R) 9. 1, there is now a survey module (e. The PROC SURVEYFREQ statement invokes the procedure, identifies the data set to be analyzed , and provides sample design information. PROC SURVEY Procedures in SAS ®. PROC SURVEYFREQ also provides design-based tests of association between variables. The PROC FREQ is one of the most frequently used SAS procedures which helps to summarize categorical variable. PROC SURVEYFREQ uses the modification described in Korn and Graubard to compute design-based Clopper-Pearson (exact) and Wilson (score) confidence limits. The SURVEYMEANS Procedure. This example uses #BYVAL1 for the SHEET_NAME suboption so that the name is the value of the MAKE variable. Census Bureau Nested multi -year estimates, a special case of estimates from overlapping samples in which one sample is wholly represented in the second sample, may be compared statistically using a t-test for overlapping groups. PROC FREQ builds all the table requests in one pass of the data so that there is essentially no loss of efficiency. Overview; Getting Started; Syntax PROC SURVEYFREQ Statement BY Statement CLUSTER Statement REPWEIGHTS Statement STRATA Statement TABLES Statement WEIGHT Statement. Use the strata statement to specify the strata variable (sdmvstra) and account for design effects of stratification. 3 User's Guide. Re: manipulating Proc SurveyFreq ODS table output #4 On Thu, 22 Jan 2009 15:09:39 -0600, Mary wrote: It looks like you are headed in the right direction. Getting Started: SURVEYFREQ Procedure. Lastly, the influence of waist circumference, fat-free mass (kg), body fat percentage, and the fat-free mass. NLTS2 Study Overview 3. SAS: Proc GPLOT Computing for Research I Robert Allison 's SAS Graph Examples. 1224 *Sex*; 1225 proc surveyfreq DATA=Botsup. By default, PROC SURVEYFREQ estimates variances by using the Taylor series method (which you can also. PROC SURVEYFREQ excludes an observation from a cross-tabulation table if that observation has a missing value for any of the table, weight, or required sample design variables unless you specify the MISSING option. PROC means DATA = dataset STD; Following is the description of the parameters used − Dataset − is the name of the dataset. Besides, it should be 'proc surveyfreq' and not just 'proc freq' as I am trying to generate estimates for entire population. Expectant mothers at risk were randomly assigned to steroid and placebo. The SURVEYFREQ Procedure. In this example, the PLOT statement uses a plot request of the type y-variable*x-variable to plot the variable HEIGHT against the variable WEIGHT. Node 22 of 0. This is required due to the complex sample design of the NCS-R data set. These tables include estimates of population totals, population. PROC SURVEYFREQ estimates the variances of totals by using the variance estimation method that you request. values are unique, e. In the following examples, we use the categorical variables of current use of e-cigarettes (yes, no) and age (18-25, 26-29, 30-34, and 35+), and the continuous variable BMI. The following example shows how you can use PROC SURVEYFREQ to analyze sample survey data. SPECIFYING YOUR SURVEY’S DESIGN IN SAS The rules used to select units from a population constitute a survey’s sample design and must be accounted for in SAS. Use the options sum, clsum, mean, and clm to request the sum, confidence interval for the sum, mean, and confidence limit of the mean, respectively, of the variable TOTALBTUSPH. SAS In SAS, Cramer's V is provided when the chisq option to the tables statement is used, in proc freq. The WEIGHT and REPWEIGHT variables are the same as the PROC SURVEYFREQ example above. The SAS library in which the DS_147 file is placed for the syntax examples is named work. The example given on that page is PROC SURVEYREG, and it uses the IPUMS-USA variable names rather than the Census Bureau's variable names. If you do not name an OUT= output data set to contain the sample of selected units, the procedure still creates an output data set and names it according to the DATAn convention. PROC SURVEYMEANS, PROC SURVEYFREQ, PROC SURVEYREG and PROC SURVEYLOGISTIC) to address this issue. 7125 F Value 8. Alternatively, PROC SURVEYFREQ may be useful especially for the variables with more than two categories. Most of code shown in this seminar will work in earlier versions of SAS and SAS/Stat. PROC SURVEYFREQ excludes an observation from a cross-tabulation table if that observation has a missing value for any of the table, weight, or required sample design variables unless you specify the MISSING option. IMPAIRED PRE- AND POST-INTERVENTION 18:58 Sunday, July 26, 2015 1 FOR THIN LIQUID SWALLOW TASKS The SURVEYFREQ Procedure Data Summary Number of Clusters 30 Number of Observations 360 Table of time_cat by pas_ind time_cat pas_ind Frequency Percent Std Err of Sample Size = 355. In SAS, the easy way to compute the chi-square test for association is to use PROC FREQ. 6 million ED visits nationally over that same period. PROC SURVEYFREQ also provides design-based tests of association between variables. One caveat in creating multiple tables in one PROC SURVEYFREQ procedure is that the procedure takes the smallest applicable sample sizes among all va riables. In other words, it returns the number and percentage of cases falling in. The WEIGHT and REPWEIGHT variables are the same as the PROC SURVEYFREQ example. The following example shows how you can use PROC SURVEYFREQ to analyze sample survey data. first example (PROC SURVEYFREQ), we provide code for how to analyze both the confidential and public CHIS data. 2018 National Survey of Children's Health U. Destination. varmethod, strata, and. With the release of SAS/STAT ® Version 9. Using data examples, the paper highlights the differences in syntax and output. The procedure fits linear models for. Until recently, SAS programmers had to rely on other statistical software packages, such as SUDAAN, WesVar, and STATA, to produce accurate estimates of such statistics. One caveat in creating multiple tables in one PROC SURVEYFREQ procedure is that the procedure takes the smallest applicable sample sizes among all va riables. Node 23 of 0. 44 and SAS/Stat 14. Use the * (asterisk) between the two variables; otherwise the program will generate two individual frequency tables. This example then requests the same plot with some modifications. NLTS2 Study Design and Sampling NLTS2 Data Sources, either 4. proc chart data =name;. The following statements must be included to provide the stratification and. Using proc surveyfreq, I have generated the cross tabs for the For example, Sex 1 and Status 1 =36. Use the * (asterisk) between the two variables; otherwise the program will generate two individual frequency tables. Ulitmately, I want an outputted dataset with the Weighted Freqency and Percent for injury for each age category and year. Function: to create pie chart or histogram. In summary, McNemar's test is appropiate if the following assumptions are met: The sample data have been randomly selected. SPECIFYING YOUR SURVEY’S DESIGN IN SAS The rules used to select units from a population constitute a survey’s sample design and must be accounted for in SAS. The following how - to - do example shows how to get domain specific results using Proc Surveyfreq. METHODS: Wave 1 of the nationally representative PATH (Population Assessment of Tobacco and Health) study interviewed 10. The following data are from several examples in the PROC FREQ documentation. There should be 2 variables (Treatment and Result), each has two categories (X/Y; cured/not cured). The total 13-year sample of dizziness cases was 9472, yielding a weighted estimate of 33. Table 1 summarizes the ones that are directly interchangeable. A BY statement is added to the PROC REPORT step so that one table is created for each value of MAKE. Java Project Tutorial - Make Login and Register Form Step by Step Using NetBeans And MySQL Database - Duration: 3:43:32. 44 and SAS/Stat 14. If you do not name an OUT= output data set to contain the sample of selected units, the procedure still creates an output data set and names it according to the DATAn convention. The examples assume that the reader has a general familiarity with SAS, the BASE SAS statistical procedures, and the statistical. The documentation for the procedure lists all ODS tables that the procedure can create , or you can use the ODS TRACE ON statement to display the table names that are produced by PROC REG. PROC statement to indicate the method to develop the replicate weights. The SURVEYIMPUTE Procedure Tree level 1. I am doing a 3 way comparison using PROC SURVEYFREQ - TABLES flag*year*age_cat*injury; This produces a table w/ the frequency of injuries in each age category (i. DIFFERENCES IN THE PROC SURVEYFREQ AND PROC FREQ CODE. You can ask PROC FREQ to construct and print frequency and crosstab tables for selected variables in the data set by using the TABLES statement. The first PROC SURVEYFREQ calculates the weighted percent of a given category‟s population that is identified as treated (weighted row percent), with a 95% confidence interval: PROC SURVEYFREQ data=f nosummary; tables &var*TX/cl row nostd;. These tables include estimates of population totals and proportions , and the corresponding standard errors. I'm studying on a large sample size (N: 500+) and when I do normality test (Kolmogorov-Simirnov and Shapiro-Wilk) the results make me confused because sig val. To adapt the PROC SURVEYFREQ code you've written here, you can just drop the STRATA statement and use the REPWEIGHTS statement found in the IPUMS-USA example. com The SURVEYFREQ Procedure. The TABLES statement specifies frequency or crosstabulation tables and requests tests and statistics for those tables. In particular, although PROC SURVEYFREQ has an option to compute Clopper-Pearson confidence limits for proportions according to the approach of Korn and Graubard (type=clopperpearson option on the TABLES statement), these confidence intervals are not based on the correct degrees of freedom for subgroups where not all strata and PSUs are. In the example below I have taken the liberty of including a variable. proc chart data =name;. Alternatively, PROC SURVEYFREQ may be useful especially for variables with more than two categories. PROC SURVEYFREQ uses the modification described in Korn and Graubard to compute design-based Clopper-Pearson (exact) and Wilson (score) confidence limits. Frequencies for demographics, risk behaviors, and mental health variables are all provided and reviewed. NLTS2 Study Design and Sampling NLTS2 Data Sources, either 4. This is the primary reason for using PROC SURVEYFREQ instead of PROC FREQ. In the example below I have taken the liberty of including a variable. The differences between the FREQ procedure and PROC SURVEYFREQ are highlighted in yellow above. sas7bdat"; tables female*homeless / chisq; run; resulting in Statistics for Table of FEMALE by HOMELESS. The SURVEYIMPUTE Procedure Tree level 1. PROC SURVEYFREQ also provides design-based tests of association between variables. HBSv48; 1226 tables demodata*sex /col row nostd nowt wchisq chisq1 expected; 1227 stratum sdmvstra; 1228 cluster sdmvpsu; 1229 weight MEC6YR; 1230 run; NOTE: 578 observations were omitted due to nonpositive weights. Node 117 of 131. Simple Random Sampling This example illustrates how you can use PROC SURVEYMEANS to estimate pop-ulation means and proportions from sample survey. This example then requests the same plot with some modifications. 2018 National Survey of Children's Health U. Analysis of Complex Survey Data and Survival Analysis. This modification substitutes the degrees-of-freedom adjusted effective sample size for the original sample size in the confidence limit computations. run; vbar tells SAS to produce a vertical bar chart/histogram. Biostat Methods STAT 5820/6910 - Handout #9 - Meta-Analysis Examples Example 1 A RCT was conducted to consider whether steroid therapy for expectant mothers affects death rate of premature [less than 37 weeks] newborns. The SURVEYFREQ Procedure. Analyzing MCBS Data with PROC SURVEYFREQ The Maybe Cheesy but Simple Approach Christine E. Method: Run both FREQ and SURVEYFREQ. You can ask PROC FREQ to construct and print frequency and crosstab tables for selected variables in the data set by using the TABLES statement. frame that I often use: describe in Hmisc provides a useful summary of variables including numeric and non-numeric data; describe in psych provides descriptive statistics for numeric data; R. 6 million ED visits nationally over that same period. And shouldn't the the. In this example, the PLOT statement uses a plot request of the type y-variable*x-variable to plot the variable HEIGHT against the variable WEIGHT. This example then requests the same plot with some modifications. 2 documentation ODS. proc freq is used to produce frequency tables (categorical data only). If things go well hopefully the data will be matched one for each by-variable. This procedure can handle complex survey sample designs, including designs with stratification, clustering, and unequal weighting. The following data are from several examples in the PROC FREQ documentation. The following how - to - do example shows how to get domain specific results using Proc Surveyfreq. A BY statement is added to the PROC REPORT step so that one table is created for each value of MAKE. frame that I often use: describe in Hmisc provides a useful summary of variables including numeric and non-numeric data; describe in psych provides descriptive statistics for numeric data; R. The CLUSTER statement specifies cluster identification variables in a clustered sample design. We choose the STD option with the PROC means step. Using data examples, the paper highlights the differences in syntax and output. We quantified receptivity to advertising for multiple tobacco products and hypothesized associations with susceptibility to cigarette smoking. Simple Random Sampling This example illustrates how you can use PROC SURVEYMEANS to estimate pop-ulation means and proportions from sample survey. To produce a horizontal bar chart/histogram replace vbar with hbar. 1, there is now a survey module (e. We quantified receptivity to advertising for multiple tobacco products and hypothesized associations with susceptibility to cigarette smoking. 44 and SAS/Stat 14. The following example shows how you can use PROC SURVEYFREQ to analyze sample survey data. Leonard, Data Consultant, Dover*, New Hampshire ABSTRACT PROC SURVEYFREQ comes to the rescue for SAS® programmers who need to analyze stratified and weighted data such as the MCBS (Medicare Current Beneficiary Survey) 1. I have tried closing and reopening SAS and re-downloading my dataset. Introduction to Power and Sample Size Analysis Tree level 1. The core of the macro %SINGLE contains two PROC SURVEYFREQ‟s and one PROC FREQ. I could not make it work with it. For example, in PROC SURVEYMEANS, one writes— PROC SURVEYMEANS DATA= VARMETHOD=BRR(FAY) ; 3. The chapter begins with a simple example pointing out how PROC SURVEYMEANS and PROC SURVEYFREQ produce equivalent results for certain univariate, descriptive statistics. sas7bdat"; tables female*homeless / chisq; run; resulting in Statistics for Table of FEMALE by HOMELESS. The procedure fits linear models for. In SAS, the easy way to compute the chi-square test for association is to use PROC FREQ. PROC SURVEYMEANS, please refer to the “Syntax” section on page 3189. Any number of TABLES statements may be included in one execution of PROC FREQ. COM> Date: 2013-06-15 14:50:01 Message-ID: CAHDp66BZ1hSe205GqKXC+UeGiwjBXPNp-4B8xpYqDMDfcPnoCQ mail ! gmail ! com [Download RAW message or body] Dear Ryan: I am using *proc surveyfreq*. The “Examples” section on page 3205 provides more complicated examples to illustrate the applications of PROC SURVEYMEANS. This is the primary reason for using PROC SURVEYFREQ instead of PROC FREQ. PROC SURVEYFREQ excludes an observation from a cross-tabulation table if that observation has a missing value for any of the table, weight, or required sample design variables unless you specify the MISSING option. Lastly, the influence of waist circumference, fat-free mass (kg), body fat percentage, and the fat-free mass. example below. This example then requests the same plot with some modifications. The design can be a complex sample survey design with stratification, clustering, and unequal weighting. Ulitmately, I want an outputted dataset with the Weighted Freqency and Percent for injury for each age category and year. One caveat in creating multiple tables in one PROC SURVEYFREQ procedure is that the procedure takes the smallest applicable sample sizes among all variables. This is a departure from older SAS procedures that provide OUT-PUT statements for similar functionality. sas7bdat"; tables female*homeless / chisq; run; resulting in Statistics for Table of FEMALE by HOMELESS. Here, PROC FREQ can also be very helpful. Census Bureau Nested multi -year estimates, a special case of estimates from overlapping samples in which one sample is wholly represented in the second sample, may be compared statistically using a t-test for overlapping groups. These tables include estimates of population totals, population. The example uses data from a customer satisfaction survey for a student information system (SIS), which is a software product that provides modules for student registration, class scheduling, attendance, grade reporting, and other functions. PROC FREQ FOR DATA CLEANING While PROC FREQ is extremely useful for statistical analysis, the first step is always to evaluate the quality of the data. The system returned: (22) Invalid argument The Proc Surveyfreq Confidence Interval used for "post linear model" analyses. This tutorial explains how to use PROC FREQ with various examples. The PROC FREQ is one of the most frequently used SAS procedures which helps to summarize categorical variable. Proc Surveyfreq To begin the analysis, the researcher used proc surveyfreq to find the frequency of occurrence for each variable response in the data set. PROC SURVEYFREQ also provides design-based tests of association between variables. Chi Square Tutorial. Among these, 92% were coded with dizziness as a presenting symptom (Figure 1). Using proc surveyfreq, I have generated the cross tabs for the population.