BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
MerAgSo
Calcite | Level 5

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. 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

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

1 REPLY 1
Reeza
Super User

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; 

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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