Hi,                  I am trying to round multiple variables from below dataset B. Dataset A is my reference dataset with rounding requirements for decimal places. Below in this dummy data I have less number of variables but in real data there are many variables, the following code works as expected for less variables but for lot of variables I am getting the below error: ERROR: The length of the value of the macro variable LGT_MACRO (65540) exceeds the maximum length (65534). The value has been truncated to 65534 characters. Can someone please help me fixing  the above error.   Example  datasets are below /*Dataset A:*/ /*If not an integer then round to number of decimal places from Var1 column*/ data a; informat var1 $50. length $10. var2 $200.; infile datalines delimiter=','; input var1 length var2 ; datalines; NotAvailable,8,Subject NotAvailable,8,Site NotAvailable,$200,Visit integer,8,Age 0.0001,8,Score1 integer,8,Score2 NotAvailable,$200,Date 0.00001,8,Score_3 NotAvailable,$200,I_am_the_longest_variable_Test_3 ; run;   /*dataset B:*/ data b; informat Visit $200. Date $200. I_am_the_longest_variable_Test_3 $200.; infile datalines delimiter=','; input Subject Site Visit Age Score1 Score2 Date Score_3 I_am_the_longest_variable_Test_3 ; datalines; 1234,001,Day1,55,344.70452025162167,4,2023-06-08 15:37,4.5707963267948966,ABCD 2456,002,Day5,45,100.12342025162167,3,2023-06-09 15:37,3.1234907586284892,WXYZ 3456,003,Day1,60,94.38627492995121,2,2023-06-10 15:37,5.7398282916662683,ABCD 7890,001,Day5,52,92.28219778353588,1,2023-06-08 15:37,3.749207747474,WXYZ 1111,002,Day1,70,124.6789456782671,3,2023-06-09 15:37,4.172819191919191,ABCD 1567,003,Day1,59,125.4796290763492,5,2023-06-10 15:37,1.272383939999,WXYZ ; run; data a1; set a; if index(length,'$')>0 or UPCASE(var1)='NOTAVAILABLE' then ; else if UPCASE(var1)='INTEGER' then Rnd_var=0; else If UPCASE(var1)='0.0001' then Rnd_var=0.0001; else If UPCASE(var1)='0.00001' then Rnd_var=0.00001; else If UPCASE(var1)='NOTAVAILABLE' then Rnd_var=.; run;   data sample_formats; set a1; format length_macr0 $100. ; if index(length,'$')> 0 or UPCASE(var1) in ('NOTAVAILABLE') then length_macr0=''; else length_macr0=cat(compress(var2),'=','round(',compress(var2),',',compress(rnd_var),')') ; run; proc sql; select length_macr0 into :lgt_macro separated by ";" from sample_formats where length_macr0 is not missing ; %put length_macr0; data test; set b; &lgt_macro. ; run; ... View more

Hi,           I have attached some example input and output datasets. So here the Start_date for ids's done after the first one must be later than the previous_date. If Start_date for the current record is before or equal to the previous previous_date,  I need to remove the record. Then I need to create a sequence number for each record within ID, where Counter resets for each new ID.  After the first record I need to look to the previous date from second record onwards and create a sequence.    Taking EFG ID as an example : the record with start_date 10DEC2021 wont be an eligible record because the previous_date for previous record is 12dec2021 so the current records start date(10dec2021) is before the previous records previous date thus this record is excluded. And for 13DEC2021 startdate record it will be eligible record whereas 16DEC2021 wont be eligible record as the date of previous eligible record previous_date(16DEC2021) is equal to this current records start_date. I tried using lag and counting the rows but with lag its an lengthy procedure to count all previous rows.   Input dataset: ID      Start_date    Previous_date ABC 03AUG2020 08AUG2020 ABC 11AUG2020 12AUG2020 ABC 03NOV2020 05NOV2020 ABC 09NOV2020 16FEB2021 ABC 20NOV2020 24NOV2020 ABC 07DEC2020 13DEC2020 ABC 17DEC2020 24DEC2020 ABC 25JAN2021 29JAN2021 ABC 24FEB2021 15MAR2021 ABC 18MAR2021 22MAR2021 ABC 12APR2021 15APR2021 ABC 14APR2021 16APR2021 ABC 20APR2021 28APR2021 ABC 19MAY2021 26MAY2021 EFG 08MAR2021 10MAR2021 EFG 08APR2021 15APR2021 EFG 30APR2021 06MAY2021 EFG 18MAY2021 25MAY2021 EFG 20AUG2021 23AUG2021 EFG 08SEP2021 10SEP2021 EFG 06OCT2021 07OCT2021 EFG 22NOV2021 23NOV2021 EFG 07DEC2021 12DEC2021 EFG 10DEC2021 13DEC2021 EFG 13DEC2021 16DEC2021 EFG 16DEC2021 21DEC2021 ;   The output should be  ID     Start_date        Previous_date  Seq ABC 03AUG2020 08AUG2020 1 ABC 11AUG2020 12AUG2020 2 ABC 03NOV2020 05NOV2020 3 ABC 09NOV2020 16FEB2021 4 ABC 24FEB2021 15MAR2021 5 ABC 18MAR2021 22MAR2021 6 ABC 12APR2021 15APR2021 7 ABC 20APR2021 28APR2021 8 ABC 19MAY2021 26MAY2021 9 EFG 08MAR2021 10MAR2021 1 EFG 08APR2021 15APR2021 2 EFG 30APR2021 06MAY2021 3 EFG 18MAY2021 25MAY2021 4 EFG 20AUG2021 23AUG2021 5 EFG 08SEP2021 10SEP2021 6 EFG 06OCT2021 07OCT2021 7 EFG 22NOV2021 23NOV2021 8 EFG 07DEC2021 12DEC2021 9 EFG 13DEC2021 16DEC2021 10 ; Any help is greatly appreciated. Thanks In Advance. ... View more