Hi. Can anyone please help me to figure out how to calculate the number of months between 2 dates for the same id, and given a condition?   For each id I need to find the number of months between date2 where column replay=y and the previous date2 where the column replay=y . I need help to find a way to calculate the column called months, i.e. like this: date1 curr id date2 replay months 01.Jun.17 0 1 23.Nov.16 n . 01.Jun.17 0 1 29.Nov.16 y . 01.Jun.17 1 1 01.Jun.17 y 6 19.Jul.17 0 2 06.Sep.16 y . 19.Jul.17 0 2 23.Sep.16 y 0 19.Jul.17 0 2 19.Jan.17 n . 19.Jul.17 1 2 19.Jul.17 y 9 02.Mar.17 0 3 07.Sep.16 y . 02.Mar.17 0 3 14.Feb.17 n . 02.Mar.17 0 3 02.Mar.17 n . 02.Mar.17 0 3 02.Mar.17 n . 02.Mar.17 1 3 02.Mar.17 y 5   Help is highly appreciated. ... View more

Hi. I have a macro where I want to do 2 things if n>0 (else do nothing). I want to append a data set to an existing table, and I want to call for another macro. I get this error message referring to the call of the macro: "Statement is not valid or it is used out of proper order." Can anyone help me?    %macro x; %if &n.>0 %then %do; proc append base=a data=b;run; call execute("%addInfo"); %end;   %mend; %x; ... View more

Hi. I have a macro variable that is datetime. How can I remove the time stamp from the variable in a new let-statement?   I have this macro: %let date0='22jan2018:0:0:0'dt;   I want to make a new macro like this: %let date1=datepart(&date0.);   I have tried statements like this, but I can't get it to work: %let date1=%sysfunc(datepart(&date0.))   Does anyone know how to convert &date0. into just a date-variable? ... View more

Hi! Can anyone help me with how to add percentage columns in my proc report? I want the sum columns first for my across variable, then followed by percentage columns for my across variable.   This is my code so far and the output it produces: proc report data=sashelp.shoes (where=(region in ('Africa', 'Asia','Canada'))) nowd; column Product Region, sales; define product/group; define region/across; define sales/'sales in USD'; rbreak after/summarize; run;     Region       Africa Asia Canada Product sales in USD sales in USD sales in USD Boot 119835 62708 385613 Men's Casual 562794 11754 441903 Men's Dress 318500 119366 920101 Sandal 190409 8208 14798 Slipper 337076 152032 952751 Sport Shoe 22150 2092 140389 Women's Casual 417516 25837 410807 Women's Dress 374308 78234 989350   2342588 460231 4255712   But I want my report to give me a table like this:   Region     Region       Africa Asia Canada Africa Asia Canada Product sales in USD sales in USD sales in USD pct pct pct Boot 119835 62708 385613 5 % 14 % 9 % Men's Casual 562794 11754 441903 24 % 3 % 10 % Men's Dress 318500 119366 920101 14 % 26 % 22 % Sandal 190409 8208 14798 8 % 2 % 0 % Slipper 337076 152032 952751 14 % 33 % 22 % Sport Shoe 22150 2092 140389 1 % 0 % 3 % Women's Casual 417516 25837 410807 18 % 6 % 10 % Women's Dress 374308 78234 989350 16 % 17 % 23 %   2342588 460231 4255712 100 % 100 % 100 %   How can I do this in proc report? I'm using sas eg 7.13. ... View more