|
|
Proc freq help
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
|
|
|
|
Reply
|
Sassy
|
11/1/2010 9:32:54 PM |
|
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
|
|
|
|
Reply
|
Paige
|
11/2/2010 12:31:13 PM
|
|
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
news:82e27f61-8ede-44e2-b133-813f3653a58f@e14g2000yqe.googlegroups.com...
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
|
|
|
|
Reply
|
Kenneth
|
11/2/2010 10:56:27 PM
|
|
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
>
> news:82e27f61-8ede-44e2-b133-813f3653a58f@e14g2000yqe.googlegroups.com...
>
> 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
|
|
|
|
Reply
|
Sassy
|
11/4/2010 6:28:30 PM
|
|
|
3 Replies
972 Views
(page loaded in 0.04 seconds)
|
|
|
|
|
|
|
|
|