topic Using Compound Conditional Logic to Recode Values in SAS Enterprise Guide

Using Compound Conditional Logic to Recode Values

JDMTX — Thu, 29 Apr 2010 14:31:02 GMT

All -

I have run into a situation where I need to recode a value in a data set using compound logic (if location ne land and water_depth gt 1500) then my recoded value is equal to deep water. The issue that I have is that the Recode Option in the Computer Field Wizard appears to be able to handle conditional logic statements that reference a single variable. Does anyone have any experience in Enterprise Guide 4.2 recoding values using conditional logic that makes use of multiple conditions that reference multiple variables? Any help would be great appreciated.

jm

Re: Using Compound Conditional Logic to Recode Values

Doc_Duke — Thu, 29 Apr 2010 15:04:03 GMT

just use the advanced expression builder and manually code your CASE clause for PROC SQL. It's a little more tedious than using the recode wizard, but works fine.

Re: Using Compound Conditional Logic to Recode Values

RichardH_sas — Fri, 30 Apr 2010 13:09:39 GMT

Agreed with Doc - write a CASE expressions and build the column as an advanced expression. Documentation on the CASE syntax is here:
http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a002473682.htm

FYI, if you already started the column as a recode, in EG 4.2 there's the ability from the computed column window to switch the column over to an advanced expression (a recode is just a CASE expression with a point-and-click front end).