Hello,   With SQL : proc sql; CREATE TABLE want AS SELECT country, region, CASE WHEN age NOT IS MISSING THEN age ELSE round(mean(age)) END AS age FROM HAVE GROUP BY region; quit; ... View more

I have edited my solution. It seems to give the wanted result. ... View more

Hello,   GROUP BY only indicates which observations are taken into account when calculating the max but you still keep all observations. You have to add a where close on the condition valueX=max(valueX) ... View more

Hello,   You can use a regex to add commas in your file each time a digit is followed by a non-digit  Edit : and vice-versa   Example with sed : > cat > test << EOF > 012321akjghjkghj8576543jhgjhgjhg657654654kugjyfj > 354354354jytjhfhgxchs9687657654jhgjhgjhgj65746576354yrzgredh > EOF   > sed "s/\([0-9]\)\([^0-9]\)/$1,$2/g; s/\([^0-9]\)\([0-9]\)/$1,$2/g" test 01232,kjghjkgh,57654,hgjhgjh,5765465,ugjyfj 35435435,ytjhfhgxch,68765765,hgjhgjhg,574657635,rzgredh ... View more

1/ Sort by Salary (with a SELECT ... ORDER BY if you have to use SQL only) 2/ Use the monotonic function to get the fifth record. ... View more

Hello,   I agree with @Patrick that your query does not seem syntactically correct. Didn't you mean something as   mytable.date as new_date format=datetime.   ... View more

Hello,   proc sort data=Lab; by ID; run; data want; set Lab; by ID; retain chk; format Toxicity $4.; keep ID Toxicity; if first.ID then chk=0; if (Event="HGB" and result>8) or (Event="Retic" and result>0.08) then chk=chk+1; if last.ID then do; if chk=2 then Toxicity="None"; else Toxicity="Yes"; output; end; run; ... View more

@Davanden, here is how i understand it :   do until (last.group);    set have;    by group;    maxval = max(maxval, of value1-value4); end;   The interest of this loop is to treat an entire group for each iteration of the datastep. By putting the set ... by instructions inside the loop, you can read each record of the group without outputting or reinitializing the PDV so that the value of MAXVAL for the group is kept between records..   It is only at the run instruction that the result is output and the PDV is reset before handling the next group.   You end up with a shorter program than if you explicitely reset Maxval on first.group and output on last.group. Clever indeed.   ... View more