- proc sql;
- create table pa as
- select product_category, weekid, area
- , count(product name) as variable1
- from res_data.p
- where price discount>0
- group by product_category, weekid, area;
- quit;
- proc sql;
- create table pb as
- select product_category, weekid, area
- , count(product name) as variable2
- from res_data.p
- group by product_category, weekid, area;
- quit;