The following will work also: options nocenter; data test; infile cards missover; input key (blue red yellow grey) (+1 $char1.); cards; 12 x z p y 25 x z p 34 x p y 87 x ; run; ods html close; ods html; proc sql; select 'b' as Colour, sum(blue is not null) as Number from _last_ outer union corr select 'r' as Colour, sum(red is not null) as Number from _last_ outer union corr select 'y' as Colour, sum(yellow is not null) as Number from _last_ outer union corr select 'g' as Colour, sum(grey is not null) as Number from _last_ ; quit;
... View more