topic Re: BY USING ABOVE TABLES FIND OUT QUARTER WISE ...???? in SAS Programming

BY USING ABOVE TABLES FIND OUT QUARTER WISE ...????

varmalh — Tue, 17 Sep 2019 02:11:11 GMT

hi all,

can someone please advise how to get this question "BY USING ABOVE TABLES FIND OUT QUARTER WISE (QUARTER LIKE (FOR (JAN FEB MAR ) Q1, (JAN FEB MAR ) Q2,… and so on ) SEGEMENT WISE DISTINCT COUNT OF CUSTOMER AND THERE TOTAL_SPEND".....?

i have attached a screensort for the reference ......!

thanks and regards

varmalh

Re: BY USING ABOVE TABLES FIND OUT QUARTER WISE ...????

PGStats — Tue, 17 Sep 2019 03:18:59 GMT

1) look up the definition of a quarter

2) look up function QTR() and format QTR.

3) try to at least write some code.

4) submit any question that arises to the Forum

in that order.

Re: BY USING ABOVE TABLES FIND OUT QUARTER WISE ...????

varmalh — Wed, 18 Sep 2019 00:41:54 GMT

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