assignment

as.md

• ACCOUNT_TABLE; Data ACCOUNT_TABLE;

  infile DATALINES delimiter=','; INPUT FirstName $ LastName $ Age Gender $;

  DATALINES; x,y,23,Male z,w,45,Female a,b,64,Male a,c,52,Male x,b,33,Female ;

RUN;

• TRANSACTION_TABLE; Data TRANSACTION_TABLE;

  infile DATALINES delimiter=','; INPUT FirstName $ LastName $ SaleMonth $ SaleAmount PROD_ID $; FORMAT SaleAmount dollar10.;

  DATALINES; x,y,JAN,100,P728391 x,y,JAN,240,P458392 x,y,MAR,160,P728393 x,y,APR,80,P728394 a,b,FEB,100,P728391 a,b,MAR,320,P728396 a,b,MAR,160,P728393 x,b,FEB,500,P728398 x,b,FEB,160,P728393 x,b,FEB,500,P728398 x,b,FEB,500,P728398 x,b,FEB,320,P728396 ; RUN;

• PRODUCT_DESC_TABLE; Data PRODUCT_DESC_TABLE; infile DATALINES delimiter=','; INPUT PROD_ID $ DESCRIPTION $ STOCK_JAN1ST2006; format DESCRIPTION $20.;

  DATALINES; P458392,HEATER,20 P728391,REFIGERATOR,13 P728393,SECURITY SYSTEM,24 P728394,MOBILE PHONE,25 P728396,DIGITAL CAMERA,13 P728398,VIDEO CAMERA,5 ; RUN;

PROC PRINT DATA = ACCOUNT_TABLE; TITLE "ACCOUNT_TABLE"; RUN; PROC PRINT DATA = TRANSACTION_TABLE; TITLE "TRANSACTION_TABLE"; RUN; PROC PRINT DATA = PRODUCT_DESC_TABLE; TITLE "PRODUCT_DESC_TABLE"; RUN;

PROC SQL;

create table JanInventory as
select PROD_ID, DESCRIPTION, STOCK_JAN1ST2006
from PRODUCT_DESC_TABLE
;

create table Transactions as
select PROD_ID, count(PROD_ID) as ProductsSold
from TRANSACTION_TABLE
group by PROD_ID
order by PROD_ID
;

create table AprilStock as
select A.*, B.ProductsSold
from JanInventory A
left join Transactions B
on A.PROD_ID = B.PROD_ID
;

QUIT;

PROC PRINT DATA=JanInventory; TITLE "January Inventory"; RUN;

PROC PRINT DATA=Transactions; TITLE "Items Sold In January"; RUN;

PROC PRINT DATA=AprilStock; TITLE "Stock In April"; RUN;