topic Re: Update a field conditioning another field in SAS Enterprise Guide

Update a field conditioning another field

Francisco — Wed, 25 Nov 2015 20:54:05 GMT

Hi. I'm new with SAS and I have a problem with EG 5.1. I need Update a Field, but conditioning another field. For example:

AMOUNT SITUATION

100

200

530

When "AMOUNT" <500 , then UPDATE field "SITUATION" with the char "Menores", and if AMOUNT >=500, then UPDATE with the char "Mayores".

I tried, but I couldn't fix it. Is possible makei without a code? (just using the GUI of EG)

Thanks in advanced.

Re: Update a field conditioning another field

Reeza — Wed, 25 Nov 2015 21:38:30 GMT

You can use Query Builder with a computed column. Use either advanced with a CASE statement or a variable RECODE. If you're going through the point and click the RECODE option may be easier for you.

I don't know think EG supports updates in place, but it looks like a new variable anyways. Otherwise if you really need to only update the table, you may want to write a data step.

data want;
set want;
if amound>500 then situation='Menores';
else if amount>=500 then situation='Mayores';
run;