Solved: if/then statement - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Calcite | Level 5

Calcite | Level 5

if/then statement

Posted 03-27-2012 12:50 PM (1461 views)

Hi,

Sorry if this is a basic question for the forum, but I would appreaciate help.

I used a PROC expand step to create a lag in my data set and the data that was previously 0 is now very small scinetific numbers. Can I add an if/then statement within the PROC expand step that if the vaiable is < 0 that it =0? Or is that a seperate data step?

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions

Onyx | Level 15

Onyx | Level 15

if/then statement

Posted 03-27-2012 12:56 PM (1444 views) | In reply to JLee

I could be blatantly wrong. I think a separated step (data step, sql) would be needed in your case.

Haikuo

View solution in original post

3 REPLIES 3

Onyx | Level 15

Onyx | Level 15

if/then statement

Posted 03-27-2012 12:56 PM (1445 views) | In reply to JLee

I could be blatantly wrong. I think a separated step (data step, sql) would be needed in your case.

Haikuo

Calcite | Level 5

Calcite | Level 5

if/then statement

Posted 03-27-2012 01:24 PM (1276 views) | In reply to Haikuo

Thank you! I did a seperate data step.

Opal | Level 21

Opal | Level 21

if/then statement

Posted 03-27-2012 01:05 PM (1276 views) | In reply to JLee

Consider using the FUZZ function in a separate datastep.

PG

PG