DATA Step, Macro, Functions and more

Creating a column with IF procedure

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

Creating a column with IF procedure

Hi, 

I'm new to SAS and I'm not sure what I'm doing wrong with my code. 

I have a big data set and I'm trying to create a new column from existing variables given that ANY of them is 1. 

Here is my code: 

 

data AVG1; 

set WORK.AVG1; 

       IF LPLAQUE=1 OR RPLAQUE=1 OR PLAQUE=1 OR PLAQUE1=1 

       THEN TPLAQUE=1; 

      ELSE IF LPLAQUE=0 OR RPLAQUE=0 OR PLAQUE=0 OR PLAQUE1=0

     THEN TPLAQUE=0; 

RUN; 

 

SAS doesn't come up with an error during the log, but on the output the table has no data. 

 

As I said, I am very new to SAS so I may be missing something very obvious. 

Thanks. 

 

 


Accepted Solutions
Solution
‎03-20-2018 03:01 PM
Super User
Posts: 23,237

Re: Creating a column with IF procedure

Well, you likely destroyed your original data so you'll first need to recreate avg1.

 

After you do that, please run the code (below) and post your log and explain what isn't working.

 

data AVG2; 
set WORK.AVG1; 
       IF LPLAQUE=1 OR RPLAQUE=1 OR PLAQUE=1 OR PLAQUE1=1 
       THEN TPLAQUE=1; 
      ELSE IF LPLAQUE=0 OR RPLAQUE=0 OR PLAQUE=0 OR PLAQUE1=0
     THEN TPLAQUE=0; 
RUN; 

View solution in original post


All Replies
Solution
‎03-20-2018 03:01 PM
Super User
Posts: 23,237

Re: Creating a column with IF procedure

Well, you likely destroyed your original data so you'll first need to recreate avg1.

 

After you do that, please run the code (below) and post your log and explain what isn't working.

 

data AVG2; 
set WORK.AVG1; 
       IF LPLAQUE=1 OR RPLAQUE=1 OR PLAQUE=1 OR PLAQUE1=1 
       THEN TPLAQUE=1; 
      ELSE IF LPLAQUE=0 OR RPLAQUE=0 OR PLAQUE=0 OR PLAQUE1=0
     THEN TPLAQUE=0; 
RUN; 
☑ This topic is solved.

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

Discussion stats
  • 1 reply
  • 103 views
  • 0 likes
  • 2 in conversation