Date:         Thu, 15 Feb 2001 11:01:54 +0100
Reply-To:     "Besnier, Gwenael" <Gwenael.Besnier@MEISTERVERLAG.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Besnier, Gwenael" <Gwenael.Besnier@MEISTERVERLAG.DE>
Subject:      proc freq and variable name
Content-Type: multipart/alternative;

Dear Saslers,

I'm working with SAS v8.1 and SYBASE as Database,
I just wanted to do a simple proc freq, but the results are "not complet" !
I don't have values for my second variable : (see following SAS code and
output)

proc freq data=tmp.mailb3;
   tables prnr*shp_art_cnt;
run;

prnr      shp_art_cnt(shp_art_cnt)

               Frequency'
               Percent  '
               Row Pct  '
               Col Pct  '        '        '        '        '        '
Total
               fffffffff^ffffffff^ffffffff^ffffffff^ffffffff^ffffffff^
               5801     '     15 '      1 '      1 '     98 '     56 '
171
                        '   6.22 '   0.41 '   0.41 '  40.66 '  23.24 '
70.95
                        '   8.77 '   0.58 '   0.58 '  57.31 '  32.75 '
                        '  88.24 ' 100.00 '   2.78 '  83.05 '  81.16 '
               fffffffff^ffffffff^ffffffff^ffffffff^ffffffff^ffffffff^
               6701     '      2 '      0 '     35 '     20 '     13 '
70
                        '   0.83 '   0.00 '  14.52 '   8.30 '   5.39 '
29.05
                        '   2.86 '   0.00 '  50.00 '  28.57 '  18.57 '
                        '  11.76 '   0.00 '  97.22 '  16.95 '  18.84 '
               fffffffff^ffffffff^ffffffff^ffffffff^ffffffff^ffffffff^
               Total          17        1       36      118       69
241
                            7.05     0.41    14.94    48.96    28.63
100.00

So I tried in the other way and everything is OK : (see following SAS code
and output)

proc freq data=tmp.mailb3;
   tables shp_art_cnt*prnr;
run;

shp_art_cnt(shp_art_cnt)
                                       prnr

                             Frequency'
                             Percent  '
                             Row Pct  '
                             Col Pct  '5801    '6701    '  Total
                             fffffffff^ffffffff^ffffffff^
                                    0 '     15 '      2 '     17
                                      '   6.22 '   0.83 '   7.05
                                      '  88.24 '  11.76 '
                                      '   8.77 '   2.86 '
                             fffffffff^ffffffff^ffffffff^
                                    1 '      1 '      0 '      1
                                      '   0.41 '   0.00 '   0.41
                                      ' 100.00 '   0.00 '
                                      '   0.58 '   0.00 '
                             fffffffff^ffffffff^ffffffff^
                                    2 '      1 '     35 '     36
                                      '   0.41 '  14.52 '  14.94
                                      '   2.78 '  97.22 '
                                      '   0.58 '  50.00 '
                             fffffffff^ffffffff^ffffffff^
                                    3 '     98 '     20 '    118
                                      '  40.66 '   8.30 '  48.96
                                      '  83.05 '  16.95 '
                                      '  57.31 '  28.57 '
                             fffffffff^ffffffff^ffffffff^
                                    4 '     56 '     13 '     69
                                      '  23.24 '   5.39 '  28.63
                                      '  81.16 '  18.84 '
                                      '  32.75 '  18.57 '
                             fffffffff^ffffffff^ffffffff^
                             Total         171       70      241
                                         70.95    29.05   100.00


Did somebody already have something like that ?
Do you think it's because my second variable hat more than 8 characters ?

Thanks for help
Gwenael Besnier

[text/html]