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
ƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ
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 '
ƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ
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 '
ƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ
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
ƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ
0 ' 15 ' 2 ' 17
' 6.22 ' 0.83 ' 7.05
' 88.24 ' 11.76 '
' 8.77 ' 2.86 '
ƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ
1 ' 1 ' 0 ' 1
' 0.41 ' 0.00 ' 0.41
' 100.00 ' 0.00 '
' 0.58 ' 0.00 '
ƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ
2 ' 1 ' 35 ' 36
' 0.41 ' 14.52 ' 14.94
' 2.78 ' 97.22 '
' 0.58 ' 50.00 '
ƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ
3 ' 98 ' 20 ' 118
' 40.66 ' 8.30 ' 48.96
' 83.05 ' 16.95 '
' 57.31 ' 28.57 '
ƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ
4 ' 56 ' 13 ' 69
' 23.24 ' 5.39 ' 28.63
' 81.16 ' 18.84 '
' 32.75 ' 18.57 '
ƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ
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