Hello, I am reading monthly sales data from a SAS dataset called RAW but I need to break it out into its 7 components for that given month. How would I modify my PROC SQL code to allow me to break this out so I can generate the the monthly sales revenue for products 'a' thru 'g' in a given month? For simplicity assume the shares are equal at 14.3% and I want to hard code the revenue shares into the coding. How would I modify the SQL language below to accomplish this? proc sql;
create table other_revenue as
select Date as yyyymm, OtherRevenue as revenue format comma9.
from raw;
alter table other_revenue
add product char (2) ;
insert into other_revenue set product='a'; * there are 6 more products (b,c,d,e,f,g);
quit; Thanks Jack
... View more
