BookmarkSubscribeRSS Feed
R_Win
Calcite | Level 5
I HAVE TWO DATA SETS I WNAT TO MULTIPLY ONE VARIABLE WITH ANOHTER DATASET VARIABLES HERE ARE THE TABLES

data x;
input id sal;
cards;
1 2
3 4
run;



data b;
input id sal;
cards;
6 8
9 9
run;


nOW I WANT A ANEW DATASET I WANT a.id*b.id and a.sal*b.sal i want those two variables and the output should be also the same names.
2 REPLIES 2
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
You have not indicated how you want the table rows to be combined? Best recommendation is to provide a sample of data as you would expect, with the combining and calculations, as explained in your post.

Scott Barry
SBBWorks, Inc.
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Please do not post the same question in multiple forums.

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

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
  • 1702 views
  • 0 likes
  • 2 in conversation