@susantrueman,    Thank you very much for your help with this. It is truly appreciated. ... View more

@Patrick, Agreed. I am also not entirely sure I understand the requirement/purpose here. My thinking was to have several self joins and finally transpose the columns to have them as required. ... View more

@Patrick , I was thinking the same. A hashobject would be easier in my opinion. Otherwise with SQL I am thinking of joining the table with itself ... View more

data class; set sashelp.class; length agegr1 $7; if age<13 then agegr1 = '<13'; else if age < 15 then agegr1 = '13-<15'; else agegr1='>=15'; run; proc sort data=class; by agegr1; run; data final; set class; by agegr1; if first.agegr1 then page+1; run; ods rtf file="./temp.rtf" style=RTFStyle; PROC REPORT data=final headline headskip nowd split="~" spacing=0 missing style(header) = {vjust = middle font_size = 8pt font_face="Courier New"} style(column) = {just=l vjust = middle font_size = 8pt font_face="Courier New"} style(report) = {rules = groups frame = void cellpadding = 1 font_face="Courier New"} style(lines) = {font_size = 8pt} ; column page name sex ("^S={borderbottomcolor=black borderbottomwidth=1} Baseline Characteristics" age height weight) agegr1; define name / order order = internal style(header)=[just=l] style(column)=[just=l cellwidth=20%]; define page / order order = internal noprint; define agegr1 / noprint; define sex / style(header)=[just=l] style(column)=[just = l cellwidth=19%]; define age /style(column) = {just=c cellwidth = 20%}; define height / style(column) = {just=c cellwidth = 20%}; define weight / style(column) = {just=c cellwidth = 20%}; compute before _page_ /style=[borderbottomcolor=black borderbottomwidth=1]; len=length(agegr1); line @1 "Age Group: " agegr1 $varying.len; endcomp; break after page / page; run; ods rtf close; Can you try adding a style to the compute before _page_ block?    ... View more

Apologies, I got those mixed up. ... View more

When executing in CAS data belonging to the same by group are automatically sent to the same node, therefore sorting is not required. If you have more nested levels, that is sorted within that node.   ... View more

DM.RFPENDTC is typically directly available in the CRF from the Subject Termination form. Are you sure this date is not captured already? Usually the Question would be “Did subject complete the study” If N a reason has to be selected, such as AE, Pregnancy during the study, protocol violation and so on. If this information is not available, you’ll have to create a temporary variable storing numeric dates representing the date of last contact. For example if a date is “2024-03” you’d have to create a temporary numeric date such that it would represent “2023-03-01” then use this temporary date to do your calculations. You can still use the partial date to populate RFPENDTC. ... View more

Does your data not have any other columns such as an ID ? With only two records it’s difficult to say which approach would work best for your data. For instance, are there always two rows? 1 for the name and another for last name? ... View more

Do you need all 100K+ rows? Though this doesn’t seem much IMHO. You might want to look at PROC CAS Table.loadTable action as you can add a where clause to this and other parameters that are not available to PROC CASUTIL. ... View more

data dummy; input id$ 1-3 FormA FormB FormC ; infile datalines ; datalines; 101 1 0 . 101 . 0 . 102 1 0 . 102 . 1 . 103 . . 0 103 . . 1 104 1 0 . 104 . . 1 105 . 1 . ; ; run; data want; do until(last.id); set dummy; by id; if formA then _forma=1; if formB then _formb=1; if formC then _formc=1; end; if sum(of _form:)>1 then multiForm=1; else multiForm=0; if multiForm=0 then do; if _forma then formAOnly=1; else if _formB then formBOnly=1; else if _formC then formCOnly=1; end; output; drop _:; run; Can you try this? ... View more

For ID 999 why are April and May 0? I’m thinking of using an array with 12 columns, then extracting the month with the month function and assigning 1 to that index in the array. Finally, output the last row for each ID. I’m not sure if you’re doing this by just the ID or ID and year? Mazi ... View more