Please can someone help to provide some code that would enable me to create a new dataset, 'Test_3', which combines all of the values from my 'Test_1' datatset and my 'Test_2' dataset? The 'Test_1' and 'Test_2' datasets both only have one variable, 'Colour', so it is not possible to merge on something like account ID.
This is not a MERGE but a SET
data want;
set test_1 test_2;
run;
proc sort data=want;
by colour;
run;
This is not a MERGE but a SET
data want;
set test_1 test_2;
run;
proc sort data=want;
by colour;
run;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.