Hi everyone,   Challenge:  I wanna get the differences in revenues between different management types, in different regions and time periods.    Problem: These are the LS-Means tables and the code I used to get them. I'm interested in the estimate in Table 1 (red), but I'm not sure what it means in terms of dollar revenues (blue) in Table 2? I understand it's the difference in the estimate but, admittedly, I don't get what the estimate refers to, as I look to the mean in dollars.   SAS version: 9.4   Thanks a lot.           Table 1: Differences of Period*Management*Region Least Squares Means Period Management Region _Period _Management _Region Estimate Standard Error z Value Pr > |z| Alpha Lower Upper 3 1 3 3 1 2 -0.6019 0.02224 -27.07 <.0001 0.05 -0.6455 -0.5583       Table 2: Period*Management*Region Least Squares Means Period Management Region Estimate Standard Error z Value Pr > |z| Alpha Lower Upper Mean Standard Error Lower Mean Upper Mean   3 1 3 5.7928 0.01699 340.89 <.0001 0.05 5.7595 5.8262 327.94 5.5729 317.2 339.05 3 1 2 6.3948 0.0144 444.09 <.0001 0.05 6.3665 6.423 598.7 8.6211 582.04 615.84       Code:   proc genmod data=test order=formatted;   class  Store Period Management Region / desc param=glm;   model Revenue = Management Period Region Management*Period*Region  /link=log dist=gamma;      repeated subject=Store/type=ind;   lsmeans Management Region Period Management*Period*Region /ilink lines means diff cl;   slice Management*Period*Region /nof ilink sliceby=Management diff exp cl;   run;       ... View more

Hi everyone,   The challenge: I have the sales and region of each store. I wanna calculate each store's percentage sales of its region's total and add this result as a new variable in the dataset.   What I have so far: I'm assuming this is solvable by PROC SQL yet, as you can probably guess  now, my SQL skills are newbie-level. I only got this far (from another thread here😞   PROC SQL; SELECT Region, COUNT(storeID), SUM(Sales) FROM sample  GROUP BY Region ORDER BY Region; QUIT;   Any help would be much appreciated.   I'm attaching a sample of the data for your convenience. I'm using SAS 9.4.     ... View more