Thanks PG, I tried to write some codes and got stuck after 3 codes. proc format;
value $mfmt "JAN","FEB","MAR"="Q1"
"APR","MAY","JUN"="Q2"
"JUL","AUG","SEP"="Q3"
"OCT","NOV","DEC"="Q4";
run;
proc print data=customers ;
format month$mfmt.;
run;
data a;
set customers;
format month $mfmt.;
run;
proc sql;
create table j as select a.*,segment from a left join customer_seg on a.cust_id=customer_seg.cust_id;
quit; please advise how to get the correct output. Thanks varmalh
... View more
