You shouldn't mix display layout with data structure. Proc Report would also allow to add such empty lines at the beginning or the end of a group. But o.k., here you go: data want; set dummy; output; if col1 =: 'PLACEBO-CONTROLLED' then do; call missing(col1); col0='week 2'; output; end; run;   ... View more

Seems trivial to me. data have; length col1-col5 $20; input col1-col5; datalines; 5(25.8) 2(6.25) 8(25.0) 10(14.4) 9(25.8) 56(12.3) 1(3.13) 19(14.4) 56(12.3) 0 87(6.0) 1(3.13) 11(34.4) 1(3.13) 0 90(87.0) 2(6.25) 1(3.13) 1(3.13) 0 ; data want; set have; array col[5]; array ncol[5]; do index=1 to dim(col); ncol[index]=input(scan(col[index],1,'('),32.); end; drop index; run; Result Obs col1 col2 col3 col4 col5 ncol1 ncol2 ncol3 ncol4 ncol5 1 5(25.8) 2(6.25) 8(25.0) 10(14.4) 9(25.8) 5 2 8 10 9 2 56(12.3) 1(3.13) 19(14.4) 56(12.3) 0 56 1 19 56 0 3 87(6.0) 1(3.13) 11(34.4) 1(3.13) 0 87 1 11 1 0 4 90(87.0) 2(6.25) 1(3.13) 1(3.13) 0 90 2 1 1 0 ... View more

  Here's another slightly simpler approach.  It uses the "point=" option of the SET statement.  The code maintains a counter _N_Y, tracking the number of 'Y' values queued up for output.  With each observation, it is decremented by 1.  _N_Y never exceeds 2, and takes that value only under the conditions specified  by @sahoositaram555        data want (drop=_:); set have; by col1 col2 notsorted; length col3 $1; if first.col1=1 and last.col2=0 then do; /** At least one repeat **/ _ptr=_n_+2; set have (keep=col1 col2 rename=(col2=_col2 col1=_col1)) point=_ptr; if col1^=_col1 or col2^=_col2 then _n_y=2; /** But not two repeats **/ end; col3=ifc(_n_y>0,'Y',' '); _n_y + (-1); run;       ... View more

Looks like you want to flag the FIRST that is not also the LAST. data want; set have ; by col1 col2 notsorted; flag = first.col2 and not last.col2; run; Obs col1 col2 flag 1 1001 1.50 0 2 1001 1.00 0 3 1001 1.50 1 4 1001 1.50 0 5 1001 1.50 0 6 1001 5.00 1 7 1001 5.00 0 8 1002 1.50 0 9 1002 4.25 0 10 1002 2.50 1 11 1002 2.50 0 12 1002 2.50 0 13 1002 1.50 1 14 1002 1.50 0 15 1003 6.50 0 16 1003 1003.00 0 17 1003 1.50 0 18 1003 5.00 0 19 1003 7.00 0 20 1003 2.10 0 21 1003 2.50 1 22 1003 2.50 0 ... View more

perhaps TAG = ^^mod( col2, 1 ) ; where TAG should be 1 when there are decimals, and 0 when col2 is integer or missing ... View more

SAS Proc Import brings in data values, not text color, font, font size, or font attributes like bold or strike through.   If there is a rule that you know as to why those values have been stricken then it may be possible to code something to remove the values.You would need to tell us rules based on values in the data other than the "stricken through" condition. If not, make a copy of the file, delete the offending values and import from the file with deleted values. ... View more

I think this is very clear:   WARNING: Apparent symbolic reference I not resolved. You can't use a macro variable &i because you haven't given it a value.   In the future, please do this:   Make this the first line of your program, run it again,   options mprint; and then show us the ENTIRE log for this segment of code, with nothing chopped out, exactly as you see it. Copy the log as text and paste it into the window that appears when you click on the </> icon here. DO NOT SKIP THIS STEP. ... View more

data want; set have; array infection{*} klebsiella pneumonia acetobacter choristidium_diff acetobactor; if ' ' in infection then inf=0; else inf=1; run; ... View more