Hi ,    I am trying to display the COL1 "Subject ID" Groupe variable value  in next page  starting to identify the rows related to Subject My current code is : options orientation=landscape nodate nonumber center nobyline ; ods rtf file = "&apath\table 02.rtf" startpage-yes style=styles.outrtf device-sasemf; proc report data= prodout.table headline headskip missing center split='|' nowd style (report) - (cellpadding=0.5pt cellspacing=1pt just=c FRAME-ABOVE ASIS=ON RULES-GROUPS) style (header) = (font=("courier new", 9pt, bold) vjust-middle asis=on just=1} style (column) - (font-("Courier New", 9pt, normal) asis=on /just=1/} style (lines) = (font=("courier new", 9pt, normal) asis=on): column coll pageord ord0 col2 col3 col col5; define pageord /order = internal order noprint; define ord0 /order = internal order noprint; define coll / 'Subject ID' group width=15 flow style (header) - [just-left] style (column) - [cellwidth =15% asis=on] left id; define COL2 / flow 'Reported Term/System| Organ Class/Preferred Term' width=39 flow style (header) = [just-style (column) - [cellwidth =39% asis-on]: define col3 / flow 'Start date' width=15 flow style (header) = [just=left] style (column) - [cellwidth -15% asis=on]; define col4 / flow 'Ongoing/End date' width=15 flow style (header) = [just=left] style (column) = [cellwidth -15% asis=on]; define col5 / flow 'Intensity' width=15 flow style (header) - [just=left] style (column) = [cellwidth -15% asis=on]; compute after ord0; line ' '; endcomp; run; ods rtf close; ods listing;   I want to repeat the Subject ID on page 2 for first row . Below is the output  Page 1 Page 2     Thank you, Rajasekhar. ... View more

Hi , I am converting the character date to numeric, but only year and month values are not populating , i am using below code but getting error as "yymmd.) format not find.       Can any one suggest how to populate only year and month values.   Thank you, Raja.   ... View more

Hi,   I have two dataset and need to be assign value based on date ranges .   subject Siteid Test date 1001 201 LDH 12-Aug-24 1001 201 LDH 22-Aug-24 1001 201 LDH 31-Sep-24 1001 201 ALT 12-Aug-24 1001 201 ALT 12-Aug-24 1002 202 LDH 18-Mar-24 1002 202 LDH 18-Mar-24 1002 202 ALT 18-Mar-24 1002 202 ALT 18-Mar-24 1002 202 ALT 25-Jun-24        Below Value need to add above dataset where same siteid and test and the date value between stdt and endt. if endt is missing then use only date and stdt    for example subject 1001 and siteid = 201 ,test = LDH , date = 31Sep24 , value need be assign 27 and rest of two records will get value 24 .   siteid test stdt endt value 201 LDH 10-Aug-24 15-Aug-24 24 201 LDH 30-Sep-24   27 201 ALT 10-Aug-24 15-Aug-24 1002 202 LDH 15-Mar-24 28-Mar-24 35 202 ALT 15-Mar-24 28-Mar-24 1021 202 ALT 20-Jun-24   1031 ... View more

Hi Team,   I am working to assign flag values for below data ,as below are rules   >  if three row values for same date , same visit and two  values 'Normal'  and one values 'Abnormal' then latest record will flag as 'Y' >  in three row records all are same then latest/last record will flag as 'Y' > in three results first one is normal and second one is abnormal and third one is Normal then , third normal values will flag 'Y' > if first two values are abnormal and last values is normal then second value abnormal will flag 'Y'   Current data : Subjid Visit Date id Result 101 Visit1 10-Sep-24 1 Normal 101 Visit1 10-Sep-24 2 Normal 101 Visit1 10-Sep-24 3 Abnormal           102 Visiti2 13-Jun-24 1 Normal 102 Visiti2 13-Jun-24 2 Abnormal 102 Visiti2 13-Jun-24 3 Normal           103 Visit1 02-Mar-24 1 Abnormal 103 Visit1 02-Mar-24 2 Normal 103 Visit1 02-Mar-24 3 Abnormal           104 Visit1 23-Feb-24 1 Abnormal 104 Visit1 23-Feb-24 2 Abnormal 104 Visit1 23-Feb-24 3 Normal           105 Visit1 18-Jan-24 1 Normal 105 Visit1 18-Jan-24 2 Normal 105 Visit1 18-Jan-24 3 Normal           105 Visit2 25-Jan-24 1 Abnormal 105 Visit2 25-Jan-24 2 Abnormal 105 Visit2 25-Jan-24 3 Abnormal   want assign flag values as below    Subjid Visit Date id Result Flag 101 Visit1 10-Sep-24 1 Normal   101 Visit1 10-Sep-24 2 Normal Y 101 Visit1 10-Sep-24 3 Abnormal               102 Visiti2 13-Jun-24 1 Normal   102 Visiti2 13-Jun-24 2 Abnormal   102 Visiti2 13-Jun-24 3 Normal Y             103 Visit1 02-Mar-24 1 Abnormal   103 Visit1 02-Mar-24 2 Normal   103 Visit1 02-Mar-24 3 Abnormal Y             104 Visit1 23-Feb-24 1 Abnormal   104 Visit1 23-Feb-24 2 Abnormal Y 104 Visit1 23-Feb-24 3 Normal               105 Visit1 18-Jan-24 1 Normal   105 Visit1 18-Jan-24 2 Normal   105 Visit1 18-Jan-24 3 Normal Y             105 Visit2 25-Jan-24 1 Abnormal   105 Visit2 25-Jan-24 2 Abnormal   105 Visit2 25-Jan-24 3 Abnormal Y   Thank you, Raja. ... View more