Hi, I'm trying to store all my libraries in one %includes statement, I did that before but unable to think how I did that.   Here is an example of my libraries in sas 9.4.   libname A "C:\\desktop\toys"; libname B "C:\\desktop\price"; libname C "C:\\desktop\orders";   I want to put all these libraries in %include so that I can just use one %include statement in my programs to access all these libraries instead of mentioning all the libraries again in the program.   Can anyone help me in this? I know it is  very simple and easy but unable to figure out how I did before.   Thanks M ... View more

Hi, I have a datset with product, Date and Net sales amount for each quarter. My row totals doesn't sumup while the column totals add up to the total amount.   suppose I have a table like below Product Date NetSales Apples 20160222 400.00 Grapes 20160512 450.20 Oranges 20160812 250.30 Peaches 20160915 500.00 Plums 20161225 350.80 Bananas 20160119 160.60   I want a table like   Product                     Quarter NetSales   Q1 Q2 Q3 Q4   Apples 100 100 150 50 400.00 Grapes 100 150 100.20 100 450.20 Oranges 50 50 50 50.30 250.30 Peaches 100 150 150 100 500.00 Plums 50 50 100 100.80 350.80 Bananas 50 25 25 60.60 160.60 TotalSales 450 525 575.20 461.70 2,111.9   I have a proc report like this:   proc report data=new spanrows missing nowd; column product quarter netsales; define product/group; define quarter/across; define netsales/sum f=comma12.; rbreak after/summarize ul ol; run;   My totals for the row netsales are not adding up to the correct amount while the column totals are correct. What I'm getting is something like this: Product                     Quarter NetSales   Q1 Q2 Q3 Q4   Apples 100 100 150 50 800.00 Grapes 100 150 100.20 100 1,500 Oranges 50 50 50 50.30 2,150 Peaches 100 150 150 100 1,500 Plums 50 50 100 100.80 3,250 Bananas 50 25 25 60.60 4,615 TotalSales 450 525 575.20 461.70 13,815   Can someone help me in understanding why my row totals doesn't match?   Thank you M ... View more

Hi, I'm trying to generate a sales report for each quarter (2015Q1, 2015Q2, 2015Q3 and 2015Q4) with Net sales for each product. I have a varaible called Prod_cat (product category) and prod_grp (product group). I want to nest Prod_cat and prod_grp so that for each Prod_cat I will have the groups( for ex: Prod_cat have RX and under this category I have Derm, Vision and Cancer). I'm trying to use proc report and generate Columns such as Prod_Cat, Quarter (Across) and Netsales (on the right side of the Column and at the bottom for each quarter. The table should look like this: Prod_Cat 2015Q1 2015Q2 2015Q3 2015Q4 NetSales RX               Derm 100,000 105,000 200,000 325,000 730,000    Vision 120,000 102,256 250,200 155,200 627,656    Ears 123,000 205,200 260,100 183,245 771,545 Netsales 343,000 412,456 710,300 663,445 2,129,201   Can someone help me in getting this kind of a report using proc report. I'm just confused with the columns statement so that I get the Prod_cat and under that I get the Prod_grp and Netsales at the bottom and on the side.   Thank you Malathi ... View more