Hi @yabwon , @ballardw , and @PaigeMiller ; thanks for your help. @yabwon , your syntax was the one that I did use. My code is as follows: data three;
length id $ 6;
length record_id $ 30;
length redcap_event_name $ 30;
set two;
where rt190 > rr100d and rt190 ne . and rr100d ne .;
rtdate=put(rt190, MMDDYY10.);
rrdate=put(rr100d, MMDDYY10.);
number=_n_;
id=put(number, z6.);
event_id=48807;
record_id_complete=2;
if rr100d <> . then do;
form_letter_1="RR";
page="rr_ct_scan_acquisition_form";
end;
if rt190 <> . then do;
form_letter_2="RT";
page="rt_ct_scan_acquisition_form";
end;
qi100a=upcase(redcap_data_access_group);
qi100c="rt_after_rr";
qi100b=cats(qi100c, '_', id);
record_id=qi100b;
qi100d='02APR2024'd;
qi100e="V01";
qi100q="AXA010";
qi100r=1;
qi101=1;
qi101_s1a=pi100b;
qi101_s1b=pi100c;
qi102___a=1;
qi103___b=1;
qi104=cats('Date of scan acquisition on the RT Form (Item 90: ', rtdate, ')', 'is after the date the radiology review is completed on the RR Form (Item d:', rrdate, '). ', 'The date of scan acquisition should be before the date of radiology review. Please review forms for the accuracy of the dates and or return this query with your comments.');
run;
proc print data=three;
var qi104;
run; The relevant log is as follows: WARNING: In a call to the CATS function, the buffer allocated for the result was not long enough to
contain the concatenation of all the arguments. The correct result would contain 317
characters, but the actual result might either be truncated to 200 character(s) or be
completely blank, depending on the calling environment. The following note indicates the
left-most argument that caused truncation.
NOTE: Argument 7 to function CATS('Date of scan'[12 of 50 characters shown],'04/22/2023',')','is
after the'[12 of 75 characters shown],'04/22/1996','). ','The date of '[12 of 170 characters
shown]) at line 2877 column 7 is invalid. Any thoughts?
... View more