Hi there, I would like to select the code that is both in ALLST and MISNG from the same data set. Any thoughts on how to go about it?   CODE REGION 516934 ALLST 516934 MISNG 328976 ALLST 987504 MISNG 489786 ALLST 489786 MISNG 987601 ALLST 348908 MISNG 890881 ALLST 314689 ALLST 314689 MISNG 348946 ALLST 787654 MISNG 975698 ALLST 975698 MISNG 107896 ALLST   ... View more

Hi, question on merge. I would like to merge 2 data sets DATA_1                 HOME_a DESCRIPTION VEDNOR_a BRAND_a DISTRIBUTOR_a SALES_a QUANTITY_a   HOME 1 MUFFINS VENDOR 1 BRAND 1 DIST 1 $519 10   HOME 2 MUFFINS VENDOR 1 BRAND 1 DIST 2 $536 10 TOTAL           $1,055 20 DATA_2               HOME_b DESCRIPTION VEDNOR_b BRAND_b DISTRIBUTOR QUANTITY_b SALES_b REBATES HOME 2 MUFFINS VENDOR 1 BRAND 1 DIST 2 10 $536 $17   the code I wrote is data COMB; merge data_1 (in=a)            data_2(in=b); by Description if a=1 and b=1; run;   I am getting  HOME_a DESCRIPTION VEDNOR_a BRAND_a DISTRIBUTOR_a SALES_a QUANTITY_a HOME_b DESCRIPTION_b VEDNOR_b BRAND_b QUANTITY_b SALES_b REBATES HOME 1 MUFFINS VENDOR 1 BRAND 1 DIST 1 $519 10 HOME 2 MUFFINS VENDOR 1 BRAND 1 10 $536 $17 HOME 2 MUFFINS VENDOR 1 BRAND 1 DIST 2 $536 10 HOME 2 MUFFINS VENDOR 1 BRAND 1 10 $536 $17  What I want is  HOME DESCRIPTION VEDNOR BRAND DISTRIBUTOR SALES QUANTITY REBATES HOME 2 MUFFINS VENDOR 1 BRAND 1 DIST 2 $536 10 $17 I am not sure why the rebates and sales are getting duplicated. Thanks,   ... View more

Hi SAS Community,   I had a question regarding the layout of a table.   I have a data set, this is obtained after doing a proc summary on BEVERAGES   proc summary data=HAVE nway; class Beverages; var SALES; by FISCAL_PERIOD; output out=TABLE sum=; run;   This is what it looks like FISCAL_PRIOD BEVERAGE SALES JAN Coffee $20 JAN Tea $50 JAN Milk $70 JAN Latte $100 JAN Juice $50 JAN Hot Chocolate $30 JAN Milk $60 JAN Mocha $35 FEB Milk $30 FEB Latte $50 FEB Juice $60 FEB Hot Chocolate $55 MAR Coffee $33 MAR Tea $55 MAR Milk $85 MAR Latte $200 APRIL Milk $70 APRIL Latte $100 APRIL Juice $50 APRIL Hot Chocolate $30 MAY Cappuccino $25 MAY Double expresso $33 MAY latte macchiato $45 MAY Juice $60 MAY Hot Chocolate $55 JUNE Latte $100 JUNE Juice $50 JUNE Hot Chocolate $30 JUNE Milk $60 JUNE Mocha $35   But I would like it to look like the table below     BEVERAGES JAN FEB MARCH APRIL MAY JUNE Cappuccino         $25   Double expresso         $33   Coffee $20   $33       Tea $50   $55       Milk $70 $30 $85 $70     Latte $100 $50 $200 $100   $100 latte macchiato         $45   Juice $50 $60   $50 $60 $50 Hot Chocolate $30 $55   $30 $55 $30 Milk $60         $60 Mocha $35         $35   I have tried PROC FREQ data=TABLE; tables BEVERAGES*FISCAL_PERIOD; run;   The above just gives me the count and not the sum. I would appreciate your help. Thanks   ... View more

Hi there, I have written this code for a simple proc means  proc means data=have SUM stackodsoutput; var E F; class A B C D; run; and I am getting this  A B C D Variable Sum Yellow Yes Italy Coffee E $10         F 3 Yellow Yes London Milk E $100         F 3 Green Yes Ireland Whole Milk E $25         F 3   what I would like is  A B C D E F Yellow Yes Italy Coffe $10 3 Yellow Yes London Milk $100 3 Green Yes Ireland Whole Milk $25 3   to have the var variables side by side instead of one below the other. Is that possible.  I would appreciate your help. Thanks ... View more