Desktop productivity for business analysts and programmers

Cleaning data

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 12
Accepted Solution

Cleaning data

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


Accepted Solutions
Solution
‎02-13-2013 01:27 PM
Super User
Posts: 19,098

Re: Cleaning data

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

View solution in original post


All Replies
Solution
‎02-13-2013 01:27 PM
Super User
Posts: 19,098

Re: Cleaning data

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

Super Contributor
Posts: 578

Re: Cleaning data

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 217 views
  • 3 likes
  • 3 in conversation