COMPGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### Proc freq help

• Email
• Follow

Hi All,

I'm running the proc freq below and keep getting the error message
=91ERROR: The requested table is too large to process.=92  I ran the exact
same syntax but using a different variable and had not problems.  Any
suggestion will be helpful. Thanks a lot.

Note: i have 9,609 matched sets and 38436 observations in total.

proc freq data=3Dtest;
tables groups*treatment*cost / cmh2 scores=3Dmodridit noprint;
Title 'Stratified signed rank test- Cost';
run;

 0

See related articles to this posting

On Nov 1, 5:32=A0pm, Sassy <augusti...@gmail.com> wrote:
> Hi All,
>
> I'm running the proc freq below and keep getting the error message
> =91ERROR: The requested table is too large to process.=92 =A0I ran the ex=
act
> same syntax but using a different variable and had not problems. =A0Any
> suggestion will be helpful. Thanks a lot.
>
> Note: i have 9,609 matched sets and 38436 observations in total.
>
> proc freq data=3Dtest;
> tables groups*treatment*cost / cmh2 scores=3Dmodridit noprint;
> Title 'Stratified signed rank test- Cost';
> run;

How many levels of groups, treatment and cost are there?

Should cost really be a classification variable here? Seems like cost
ought to be treated as a continuous variable.

--
Paige Miller
paige\dot\miller \at\ kodak\dot\com

 0

It looks like you are trying to create a frequency table with at least one
field that is non-integer.  Yes, SAS could run out of memory especially if
you are creating table in several dimension.  Try using PROC FORMAT to
create a finite number of brackets then try again.

"Sassy"  wrote in message

Hi All,

I'm running the proc freq below and keep getting the error message
�ERROR: The requested table is too large to process.�  I ran the exact
same syntax but using a different variable and had not problems.  Any
suggestion will be helpful. Thanks a lot.

Note: i have 9,609 matched sets and 38436 observations in total.

proc freq data=test;
tables groups*treatment*cost / cmh2 scores=modridit noprint;
Title 'Stratified signed rank test- Cost';
run;


 0

On Nov 2, 6:56=A0pm, "Kenneth M. Lin" <kenneth_m_...@sbcglobal.net>
wrote:
> It looks like you are trying to create a frequency table with at least on=
e
> field that is non-integer. =A0Yes, SAS could run out of memory especially=
if
> you are creating table in several dimension. =A0Try using PROC FORMAT to
> create a finite number of brackets then try again.
>
> "Sassy" =A0wrote in message
>
>
> Hi All,
>
> I'm running the proc freq below and keep getting the error message
> =91ERROR: The requested table is too large to process.=92 =A0I ran the ex=
act
> same syntax but using a different variable and had not problems. =A0Any
> suggestion will be helpful. Thanks a lot.
>
> Note: i have 9,609 matched sets and 38436 observations in total.
>
> proc freq data=3Dtest;
> tables groups*treatment*cost / cmh2 scores=3Dmodridit noprint;
> Title 'Stratified signed rank test- Cost';
> run;

Thanks a lot for your suggestions.  How do you use PROC FORMAT to
create a finite number of brackets?


 0