Hi All, i have a dataset as below. data dummy; length col1 $200; col1="BASELINE Heart Rate";output; col1='PLACEBO-CONTROLLED Heart Rate';output; col1='WEEK 2 Heart Rate';output; col1='WEEK 4 Heart Rate';output; col1='WEEK 8 Heart Rate';output; col1='WEEK 12 Heart Rate';output; col1='WEEK 18 Heart Rate';output; col1='BASELINE SYSBP';output; col1='PLACEBO-CONTROLLED SYSBP';output; col1='WEEK 2 SYSBP';output; col1='WEEK 4 SYSBP';output; col1='WEEK 8 SYSBP';output; col1='WEEK 12 SYSBP';output; col1='WEEK 18 SYSBP';output; col1='BASELINE DIABP';output; col1='PLACEBO-CONTROLLED DIABP';output; col1='WEEK 2 DIABP';output; col1='WEEK 4 DIABP';output; col1='WEEK 8 DIABP';output; col1='WEEK 12 DIABP';output; col1='WEEK 18 DIABP';output; RUN;   I would like to insert 1 blank row each below the rows PLACEBO-CONTROLLED Heart Rate, PLACEBO-CONTROLLED SYSBP, PLACEBO-CONTROLLED DIABP.  how this can be achieved, please suggest, I heard call missing would work, but unable to do so. ... View more

I have this below dataset  data have; input col1 $1-8 col2 $9-16 col3 $17-25 col4 $26-34 col5 $35-41; 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 ; run;   I would like to take the nuemric part from each of these columns exist, and create nuemric columns for each that contains only the value before bracket starts "(".  eg: for the 1st row there will be 5 numeric columns with value in first column will be 5 and in the last column the value will be 9.   I have written a code to solve this,  data want; set have; array char(*) COL1 COL2 COL3 COL4 COL5; /*columns I have */ array new(*) COL1N COL2N COL3N COL4N COL5N;/*numeric columns to be produced*/ do i=1 to dim(char); if char[i] ~="" then new[i]=scan(char[i],1,'('); end; run;   but I'm getting  ERROR: Array subscript out of range at line 35 column 22.   and for the last column since I have '0', need to add a consition to handle the same.  ... View more

Hi all, I have a dataset as below. data have; input col1 col2; datalines; 1001 1.5 1001 1 1001 1.5 1001 1.5 1001 1.5 1001 5 1001 5 1002 1.5 1002 4.25 1002 2.5 1002 2.5 1002 2.5 1002 1.5 1002 1.5 1003 6.5 1003 1003 1.5 1003 1.5 1003 5 1003 7 1003 2.1 1003 2.5 1003 2.5 ; run; I would like to flag the first record (out of last 2 records by grouping col2 if repetitive). eg: for 1001 even though there are 1.5 is repeated, my focus is on last 2 observations and flag the 6th observation as 6th and 7th record have same value 5. for 1002, flag the 11th observation, as 11th and 12th rec has the value 1.5.    If last 2 observations are repeated, I would like to flag the previous record to the last record by each col1 group.   ... View more

Hi all, I have 2 columns such as below.   col1      col2 xxxxx  0.5 yyyyy   1 zzzz     1 kkkk     1 llllllll      1 xxxxx  1.5 yyyyy   2 zzzz     2 kkkk     2 llllllll      2 ................. similarly i have values up to 60.   My COL2 is numeric, Looking for a procedure to find out to TAG the rows containing decimal values, the order can not be changed? (with out converting the column in to character and then using any function to pick the decmial)  ... View more