Here is a sample of variables from the format table. As you can see, the number of groups by variable can be lower than 10. data format_table;
informat avg_trans_value $50. avg_val_day $50. avg_val_day_mcc $50. avg_val_day_pos $50. avg_vol_day $50. avg_vol_day_mcc $50.;
infile datalines delimiter='|';
input avg_trans_value avg_val_day avg_val_day_mcc avg_val_day_pos avg_vol_day avg_vol_day_mcc;
datalines;
avg_trans_value < 13 |avg_val_day < 4.83 |avg_val_day_mcc < 19.98 |avg_val_day_pos < 35.43 |avg_vol_day < 2, _MISSING_ |avg_vol_day_mcc < 1.93
13 <= avg_trans_value < 17 |4.83 <= avg_val_day < 9 |19.98 <= avg_val_day_mcc < 24.54 |35.43 <= avg_val_day_pos < 38.77, _MISSING_ |2 <= avg_vol_day < 3 |1.93 <= avg_vol_day_mcc < 2.27
17 <= avg_trans_value < 19 |9 <= avg_val_day < 10.51 |24.54 <= avg_val_day_mcc < 25.84 |38.77 <= avg_val_day_pos < 66.05 |3 <= avg_vol_day < 4 |2.27 <= avg_vol_day_mcc < 2.32
19 <= avg_trans_value < 23 |10.51 <= avg_val_day < 16.79 |25.84 <= avg_val_day_mcc < 26.52 |66.05 <= avg_val_day_pos |4 <= avg_vol_day < 6 |2.32 <= avg_vol_day_mcc < 2.48, _MISSING_
23 <= avg_trans_value < 27 |16.79 <= avg_val_day < 24.69, _MISSING_ |26.52 <= avg_val_day_mcc < 28.15 | |6 <= avg_vol_day |2.48 <= avg_vol_day_mcc < 2.65
27 <= avg_trans_value < 30 |24.69 <= avg_val_day < 37.96 |28.15 <= avg_val_day_mcc < 34.42 | | |2.65 <= avg_vol_day_mcc < 2.8
30 <= avg_trans_value < 36 |37.96 <= avg_val_day < 51.8 |34.42 <= avg_val_day_mcc < 36.4 | | |2.8 <= avg_vol_day_mcc < 2.93
36 <= avg_trans_value < 44 |51.8 <= avg_val_day < 83.42 |36.4 <= avg_val_day_mcc < 42.05 | | |2.93 <= avg_vol_day_mcc < 3.11
44 <= avg_trans_value < 78, _MISSING_ |83.42 <= avg_val_day |42.05 <= avg_val_day_mcc < 48.14 | | |3.11 <= avg_vol_day_mcc < 3.6
78 <= avg_trans_value | |48.14 <= avg_val_day_mcc, _MISSING_ | | |3.6 <= avg_vol_day_mcc
;
run;
... View more
