Hello, I would ask for your help on the below.   I want to find the sum of a values for X consecutive days by ID.   Consecutive days means days that happen one after the other without breaks. The program should be able to do so for different X consecutive days.   For instance, see the data below: data have; input ID $ DT:date9. Amount Consecutive_Amount; format DT date9.; datalines; A 09JUL2021 3600 3600 A 03AUG2021 456 489 A 04AUG2021 33 33 A 06AUG2021 235 335 A 07AUG2021 100 100 A 09AUG2021 86 86 A 12AUG2021 456 456 A 24AUG2021 22 1925 A 25AUG2021 987 1984 A 26AUG2021 916 997 A 27AUG2021 81 81 B 07AUG2021 554 992 B 08AUG2021 193 438 B 09AUG2021 245 245 ; run;   Assume that we want to sum the amount for next 3 consecutive days. On 24/08/2021 the amount for the next 3 consecutive days is 1925. On 07/08/2021, we cannot calculate the amount for the next 3 consecutive days because there is a gap between 07/08/2021 and 09/08/2021.   Any assistance would be much appreciated.       ... View more

Hello,   I would ask for your assistance on the following.   I have data in the following format:     data have; input ID DT :ddmmyy10. PRODUCT$ AMOUNT; format DT ddmmyy10.; datalines; 1 04/02/2023 A 100 1 15/02/2023 B 55 1 01/03/2023 B 65 1 07/03/2023 A 89 1 10/03/2023 B 75 1 24/03/2023 A 300 2 15/02/2023 C 400 2 25/02/2023 D 56 ; run;     I would like to be able to know for each ID how many unique products within a consecutive 10 days period.   The output should be like the below:     data want; input ID DT :ddmmyy10. PRODUCT$ AMOUNT uniq_products; format DT ddmmyy10.; datalines; 1 05/02/2023 A 100 2 1 15/02/2023 B 55 1 1 01/03/2023 B 65 2 1 07/03/2023 A 89 2 1 10/03/2023 B 75 1 1 24/03/2023 A 300 1 2 15/02/2023 C 400 2 2 25/02/2023 D 56 1 ; run;   ID DT PRODUCT AMOUNT uniq_products 1 05/02/2023 A 100 2 1 15/02/2023 B 55 1 1 01/03/2023 B 65 2 1 07/03/2023 A 89 2 1 10/03/2023 B 75 1 1 24/03/2023 A 300 1 2 15/02/2023 C 400 2 2 25/02/2023 D 56 1     Any help please?   Thanks in advance.     ... View more

Hello,   The below conditional logic fails and cannot figure out the reason:   %let _N_ = 6.3; %macro test(); %if &_N_ < 100 %then %do; %put &_N_ is less than 100; %end; %else %do; %put &_N_ is greater than 100; %end; %mend; %test();   Please see the logs:   28 %let _N_ = 6.3; 29 30 %macro test(); 31 %if &_N_ < 100 %then 32 %do; 33 %put &_N_ is less than 100; 34 %end; 35 %else 36 %do; 37 %put &_N_ is greater than 100; 38 %end; 39 %mend; 40 41 %test(); 6.3 is greater than 100   I have a workaround:   %let _N_ = 6.3; %macro test2(); %if %sysevalf(&_N_,integer) < 100 %then %do; %put &_N_ is less than 100; %end; %else %do; %put &_N_ is greater than 100; %end; %mend; %test2(); The logs:   28 %let _N_ = 6.3; 29 30 %macro test2(); 31 %if %sysevalf(&_N_,integer) < 100 %then 32 %do; 33 %put &_N_ is less than 100; 34 %end; 35 %else 36 %do; 37 %put &_N_ is greater than 100; 38 %end; 39 %mend; 40 41 %test2(); 6.3 is less than 100 But still I would like to understand the reason..   Thanks.   ... View more

Hello,   I am wondering if you could help me please.   I want to store a short text into a variable in different lines.   Please see below:   data want; text_in_many_lines = "Hello, This is a text in many lines. Thanks."; run; If I do so, I am able to store it but not in many lines as shown above.   Is there any way to do it?   Thanks ... View more