Hello I want to display values in millions. The row data is displayed in thousands. for example: value 1000 is 1 million, value 2000 is 2 million.... I want that the summary table of proc report will display values(sum ) in millions. Data tbl; input ID Team $ y; cards; 1 a 1000 2 a 2000 3 a 3000 4 b 4000 5 b 5000 ; run; proc report data=tbl nowd; column Team y ; define Team / group; define y / analysis sum; rbreak after / summarize; run; ... View more

Hello Please see this code with proc report. I want to add total row after categories that belongs to same variable (summary row for Female and Male categories and another summary row  for Degree and NotDegree categories) data summary_dataset; input dem $ year apply_count interviewed_mean hired_mean; select(first(dem)); when('M','F') gr=1; otherwise gr=2; end; datalines; Male 2012 288 0.15972 0.21739 Female 2012 61 0.09836 0.33333 Male 2013 279 0.19355 0.2963 Female 2013 59 0.25424 0.26667 Male 2014 293 0.18089 0.28302 Female 2014 61 0.27869 0.17647 Degree 2012 108 0.28704 0.19355 NoDeg 2012 241 0.08714 0.28571 Degree 2013 108 0.36111 0.28205 NoDeg 2013 230 0.13043 0.3 Degree 2014 124 0.23387 0.2069 NoDeg 2014 230 0.17826 0.29268 run; proc report data =summary_dataset list; columns gr dem (("Applied" apply_count),year gap ("Interviewed" interviewed_mean),year gap ("Hired" hired_mean),year); define gr / group ' ' noprint; define dem / group " "; define apply_count / analysis "" format = comma8.; define interviewed_mean / analysis "" format = percent8.; define hired_mean / analysis "" format = percent8.; define year / across ""; define gap / ' ' style={cellwidth=.25in}; compute after gr; line ' '; endcomp; run;   ... View more

Hello I want to create a summary table that contains categories from different variables. I am doing it via proc sql . As you can see in the code it is quite long code. I want to ask if there is a short way to do it via proc summary (or other proc)   thanks Joe data rawdata; input ID Cat1 $ Cat2 $ Cat3 $ Y; cards; 1 a Y AU 100 2 a N AU 110 3 a Y AU 120 4 a N UK 130 5 b Y UK 140 6 b N UK 150 7 b Y USA 160 8 b N USA 170 9 c Y USA 180 10 c N USA 190 ; run; PROC SQL; create table output1 as select Cat1 as cat, count(*) as no_customers, sum(y) as Total_Y from rawdata group by Cat1 ; QUIT; PROC SQL; create table output2 as select Cat2 as cat, count(*) as no_customers, sum(y) as Total_Y from rawdata group by Cat2 ; QUIT; PROC SQL; create table output3 as select Cat3 as cat, count(*) as no_customers, sum(y) as Total_Y from rawdata group by Cat3 ; QUIT; Data output_all; set output1 output2 output3; run;   ... View more

Hello Why this code is not working? I want to use condition of all branches >0   Data tbl; input ID branch; cards; 1 100 2 100 3 200 4 300 5 400 6 500 7 500 8 500 9 500 10 500 ; run; %macro rjoe(x,branchP); PROC SQL; create table outcome_&x. as select * from tbl where branch in (&branchP.) ; QUIT; %mend; %rjoe(x=1,branchP=100); %rjoe(x=2,branchP=200); %rjoe(x=3,branchP=300); %rjoe(x=4,branchP=400); %rjoe(x=5,branchP=500); %rjoe(x=6,branchP=100 200 300 400 500); %rjoe(x=5,branchP=>0);/*It is not working .why??*/ ... View more