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.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

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 save with the early bird rate—just $795!

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