Date: Thu, 15 Feb 2001 15:51:47 +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: AW: proc freq and variable name
Content-Type: multipart/alternative;
Hi SASlers,
Thanks to all who respond me.
I read the following note in SAS internet site
http://www.sas.com/service/techsup/unotes/V6/G/G079.html
<http://www.sas.com/service/techsup/unotes/V6/G/G079.html>
It's written : apply a format length at least as long as the variable name
length,
so i tried with : format shp_art_cnt 12.;
and it's running OK
Gwen
-----Original Message-----
From: Besnier, Gwenael [mailto:Gwenael.Besnier@MEISTERVERLAG.DE]
Sent: Thursday, February 15, 2001 5:02 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: proc freq and variable name
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]
