I am trying to upload the CDC's BRFSS2015.XPT file.  The file is 917 MB so well within the %GB space allowed.  However, after one hour, SAS ODA times out and the upload is cancelled.  Can I extend the time out to more than one hour?  If so, how? ... View more

Hello,   I am using Surveyfreq to calculate Chi-square results (among other things) for a complex survey data set.  Some of the table cells in a two-way table have zero values, which results in the following warning message:    "Note:  Chi-square tests cannot be computed for table XX by YY because at least one table cell has 0 frequency."   I have tried to suppress the cells with 0 frequency using the NOSPARSE option in the table statement, which does suppress the values for the table, but does not have an effect on the Chi-square tests.  I've tried to find it in the SAS literature, but have not been able to find it so far.   Though I don't think it is necessary to address my question, here is the key section of code:   Proc surveyfreq data=SCM_SORT; by _state; weight _LLCPWT; Tables scntmel1*GHSTATUS/row cl nosparse chisq(secondorder); ODS Output CrossTabs=Freqout1; Format GHSTATUS status. scntmel1 Always.; run;   This must be an easy and fairly common question.  My search of the community identifies one thread from last October, but I was unable to see a solution in that thread.     Thanks in advance for your guidance. ... View more

I am using Surveyfreq for one-way and two-way tables.  I'm interested in the row percentages and particularly the standard deviation of those row percentages.  I have two issues/questions:   1)  The documentation says the default columns are: Frequency Weighted frequency Standard deviation of weighted frequency Percent Standard error of percent. (plus the additional columns for the Row option).   However, instead of "Standard deviation of weighted frequency," I see "standard error of weighted frequency."  Why does my table show Std Err Wgt Freq instead of Std Dev Wgt Freq?  How do I get to the standard deviation?   2)  What option do I need to get to the standard deviation of the weighted row percentages?   Here are the relevant section of code and a sample of a table.   Proc surveyfreq data=SCM_SORT; weight _LLCPWT; Tables _STATE*GHSTATUS/row chisq(secondorder); ODS Output CrossTabs=Freqout1; Format GHSTATUS status.; run;     Thanks in advance for your assistance.     ... View more

Hello,   I have a data set with 78k observations that include two variables: _state and SCNTMEL1. SCNTMEL1 has values that include 1-5.  I am trying to use SGPlot Series to display _States on the x axis and the sum of the Freq Row Pct for values 1 and 2 ("Always" and "Usually") for each (_state) on the y axis.  I can calculate the individual percentages for each value for SCNTMEL1 using Proc Freq, but I am struggling to figure out how to sum the Row Pct for values 1 and 2, then identify those for Proc SGPlot, Series.   Here is the code for the Proc Freq step:   Proc sort data=brfss15.scontext Out=SCM_SORT; by _State; Run; Proc format; Value Always 1='Always' 2='Usually' 3='Sometimes' 4='Rarely' 5='Never' 7='Not Sure' 8='N/A' 9='Refused'; Run; Proc Format; Value State 1='Alabama' 5='Arkansas' 10='Delaware' 11='D.C.' 13='Georgia' 22='Louisiana' 27='Minnesota' 28='Mississippi' 29='Missouri' 44='Rhode Island' 47='Tennessee' 49='Utah'; Run; Proc freq data=SCM_SORT; Tables _STATE*SCNTMEL1/nopercent nocol; Format _State State.; Format SCNTMEL1 Always.; Run; I tried an out= statement to capture the Freq data and I've tried various Proc SGPlot alternatives, including Stat=freq, but don't know how to isolate and combine the Row Pct for values 1 and 2. Hoping this description is sufficiently clear. Thanks in advance.    ... View more