Creating Count Variables Corresponding to Values of Character Variables

Data defines the model by dint of genetic programming, producing the best decile table.

Creating Count Variables Corresponding to Values of Character Variables
Bruce Ratner, PhD

Live chat by Bold chat

data buys2;
infile cards dlm=',';
input id $ buy1 $ buy2 $ buy3 $ ;
cards;
ar, apple, banana, apple
br, nut, fig, apple
;
run;

proc print data=buys2; title1 ' ';
title2' input dataset BUYS ';
run;

proc sort data=buys2; by id;
run;

proc transpose data=buys2 out=out(drop=_name_);
by id;
var buy1-buy3;
run;

proc summary data=out nway;
class id col1;
output out=out1(drop=_type_);
run;

proc transpose data=out1 out=FRUITS(drop=_name_);
by id;
var _freq_;
id col1;
run;

options missing='0';
proc print data=FRUITS; title2' output, desired dataset FRUITS ';
run;

For more information about this article, call Bruce Ratner at 516.791.3544 or 1 800 DM STAT-1; or e-mail at br@dmstat1.com.

Sign-up for a free GenIQ webcast: Click here.