Hello I want to ask about do loop.   For example: %do i=1 %to 12;   How can I  run the Do loop from 12 to 1  and not 1 to 12?   thanks Joein     ... View more

Hello In this example the user enter two dates (start and end in format YYMM) . The target is to get all end of quarter months between start and end. for example: start=1612 end=1808 We should get  1612  1703  1706  1709  1712  1803  1806   In the following code the problem is that we get also 1809 (which is bigger than end )   One more problem is that when I run %PUT &&m&n..;  I get  warning  "WARNING: Apparent symbolic reference M not resolved." %let start=1612; /*Must start from end of quarter :Dec March June Sep*/ %let end=1807; %let date_start=%sysfunc(inputn(&start.,yymmn4.)); %let date_end=%sysfunc(inputn(&end.,yymmn4.)); %put &date_start.; %put &date_end.; Data want_month; do j=0 to intck('QUARTER',&date_start.,&date_end.) ; ddate=intnx('QUARTER', &date_start., j, 's'); char_ddate = put(ddate, YYMMn4.); /*Var_Macro_name=compress('m'||put(J,2.));*/ Var_Macro_name='m'||strip(put(J,2.)); call symputx('m'||strip(put(J,2.)), char_ddate); output; end; Run; PROC SQL Noprint; select count(*) INTO:n from want_month ; QUIT; %put &n.; %put &m0; %put &m1; %PUT &&m&n..; ... View more

Hello I have a row data of loans taken by customers. I need to calculate for each score (category variable)the following 5 measurements: 1-weighted average of interest  (weight by sum of loan) 2-sum of loan 3-number of loans 4-percent from total of sum of loans 5-percent from total of number of loans I want to use proc tabulate because in proc means we cannot calculate percent from total in one step   I would like to see please proc tabulate code that calculate all 5 measurements     thanks Jowl data Loans_tbl1806; input customer score $ sum_loan interest; cards; 1 a 100 5 2 a 200 4 3 a 300 4 4 b 400 3.5 5 b 500 2.8 6 c 100 5 7 c 200 4 8 c 300 4 9 c 400 3.5 10 c 1500 2.8 ; run;       ... View more

Hello I have the following challenge. Let's say that there is an input data set . I want to check which numbers in last column are new in comparison to previous column(one column before last column). I want to check which numbers in one column before last column are not existing in last column.   I think that in the program we need to check how many columns are in in input data set and then we can compare last column with one column before last. For example: In the following example if we compare last column with one column before last: 9,10,11  are new members 8,9 left   I want to create a new outcome data set  with two columns: new and left   data tbl; input x1801 x1802 x1803 x1804 x1805 x1806; cards; 1 1 6 1 1 2 2 2 1 2 2 3 3 3 2 3 3 4 4 4 3 4 5 5 5 5 4 8 8 8 5 9 9 10 ; run;         ... View more

Hello Is it possible to  calculate percent from total in proc means >?       ... View more