Merging datasets with different variable names.

[Adi27]

Is it possible to merge 2 data sets with different variable names for the same thing?

For example, my product sheet has a column product_id which is same as column product in reviews but im unable to join them due to different names. Is it possible to join the two tables.

/* Merge LowRatedProducts with Products to access prices */
data LowRatedProductsWithPrices;
merge LowRatedProducts (in=a) Qed.Products (in=b);
by product_id; 
if a and b;
run;

/* Print the low-rated products along with their prices */
PROC PRINT DATA=LowRatedProductsWithPrices;
title "Low-Rated Products and Their Prices";
RUN;

This shows an error because review doesn't have products_id but product.

[PaigeMiller · Accepted solution]

merge LowRatedProducts (in=a rename=(product=product_id)) Qed.Products (in=b);
by product_id;