topic Re: Cleaning data in SAS Enterprise Guide

Cleaning data

DavidDemeyer — Wed, 13 Feb 2013 16:45:42 GMT

Hi everyone,

I'm quite new to SAS Enterprise Guide and I would like to clean up my data before analysis.

I have a variable OnlineCustomer that uses 3 possible ways to be TRUE and 2 ways to be FALSE.

null, -1 and 0 should be FALSE

1 or [the customerID] should be TRUE

How can I convert al the values to the correct TRUE/FALSE-value so I can easily work with expressions?

Thanks,

David

Re: Cleaning data

Reeza — Wed, 13 Feb 2013 18:27:24 GMT

In SAS you can recode the variables in a task I believe OR you could create a custom format and then use the data as is, if you needed it further.

EDIT:

To recode:

Use query builder>Computed Column> check the RECODE radio button

For Format, it is under Tasks>Data>Create Format

Re: Cleaning data

DBailey — Wed, 13 Feb 2013 18:53:46 GMT

If you're using the query wizard, you can add a computed column either via the recode as described or if you're feeling adventurous create one using the advanced option and name it bolOnlineCustomer. The formula would be something like:

Onlinecustomer=1 or OnlineCustomer=[the customerid].

If either of those are true, the formula returns a true. I'm presuming that your customerid's are all numeric