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

I have one SAS data set MM and want to create three SAS data set, A , B , C ,respectively.

There are six variables in SAS data set MM—— score1 , score2 , score3 , score4 , score5 ,score6 ;

if I want to set up one new variable, average = mean(of score1-score6), and put it into data set B  , how should I do ?

 

data A B C;

set MM;

 

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisNZ
Tourmaline | Level 20

The description of your needs is tenuous. This sticks to your script:

data A B(keep=average) C;
  set MM;
  average = mean(of score1-score6), 

 

View solution in original post

2 REPLIES 2
ChrisNZ
Tourmaline | Level 20

The description of your needs is tenuous. This sticks to your script:

data A B(keep=average) C;
  set MM;
  average = mean(of score1-score6), 

 

tianerhu
Pyrite | Level 9

Thank you for you advise and help. Your code is just what I need.

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

Explore Now →
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
  • 2 replies
  • 1489 views
  • 0 likes
  • 2 in conversation