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;
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),
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),
Thank you for you advise and help. Your code is just what I need.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.