Hello I want to ask a general question. Many times I am asked to create a summary report for different populations. In order to do it efficiency I am using macro. In the Macro I define a parameter that define the population. The problem is that sometimes I need that there will not be any rows screen. The code here just show you what i want but the way it is written is wrong   for example: Data tbl; input ID X $ Z; cards; 1 a 2 2 a 2 3 a 1 4 b 1 5 b 2 6 c 2 7 c 1 8 c 1 9 c 2 10 c 2 ; run; %macro mmacro(condition); PROC SQL; create table xxx as select from tbl where &condition. ; QUIT; %mend; /*Run1*/ %mmacro(condition=(x='a' and z='1'); /*Run2*/ %mmacro(condition=(x='a' and z='2'); /*Run3*/ %mmacro(condition=((x='b' OR x='c') and z='2'); /*Run4*/ %mmacro(condition=((x='b' OR x='c')); /*Run5*/ %mmacro(condition=((x='b' OR x='c')); /*Run6*/ %mmacro(condition=((no condition));   ... View more

Hello I want to calculate counts(count members) and percentage from total  for each group. The calculation is made from raw data table. I know how to do it with proc sql but as you can see it is very long code. I wonder if anyone suggest a better way(less code) to get same result. The result is in a table called  Final /******Calculate counts and percentage from total*******/ /******Calculate counts and percentage from total*******/ /******Calculate counts and percentage from total*******/ /******Calculate counts and percentage from total*******/ /******Calculate counts and percentage from total*******/ data have; input ID score ; cards; 1 0 2 0 3 2 4 3 5 0 6 2 7 11 8 11 9 2 10 0 ; run; PROC SQL; create table t1 as select score,1 as help, count(*) as No_customers from have group by score ; QUIT; PROC SQL; create table t2 as select 1 as help, sum( No_customers) as Grand_Total_customers from t1 ; QUIT; PROC SQL; create table t3 as select a.score,a.No_customers, a.No_customers/b.Grand_Total_customers as PCT_From_Total format=percent7.1 from t1 as a left join t2 as b on a.help=b.help ; QUIT; PROC SQL; create table t4 as select . as score , sum(No_customers) as No_customers, sum(PCT_From_Total) as PCT_From_Total format=percent7.1 from t3 ; QUIT; Data Final; Set t3 t4; Run; title; proc print data=Final noobs;run; ... View more

Hello I cannot go to all process so I will ask the question from this step only.   %macro mmacro; %do j=1 %to &k.; &Xj. %end; %mend;   I want to create a parameter that get the value:  X1,X2,X3,X4......................... (As you can see the number of arguments are not fixed and depends on value of parameter &k.)         ... View more

Hello Let's say that a user defined a parameter %let x=1801 1802 1803 1804 1805 1806;   The task is to create another parameter called new2 that get value:  1801,1802,1803,1804,1805,1806   (As you can see instead of space there should be a comma)     ... View more

Hello I want to use proc report to display data.(No need to calculate because input data is ready to display). I use proc report in order to merge data that repeat in columns:score  Model .(Merging cells) For this task I use 'group' in define statement. I see that it is not working well because only in 'score' column it is working  but in 'Model' column it is not working   Data tbl; input Score Model $ Customers Obligation; cards; 0 A 5269 700 0 B 563 2000 2 A 22712 7000 3 A 21412 4000 4 A 16766 3000 5 A 5634 1500 6 A 3169 800 7 A 2964 900 8 A 3033 800 9 A 1026 200 10 A 635 150 11 A 4522 650 11 B 3 20 12 A 11198 4000 12 B 53 30 ; Run; proc report data=tbl nowd headskip ; column Score Model Customers Obligation ; define Score / group ; define Model / group ; run ; ... View more