https://communities.sas.com/t5/New-SAS-User/Merging-datasets-with-different-variable-names/m-p/901075#M40163 <PRE><CODE class=" language-sas">merge LowRatedProducts (in=a rename=(product=product_id)) Qed.Products (in=b); by product_id;</CODE></PRE> Wed, 01 Nov 2023 14:26:52 GMT PaigeMiller 2023-11-01T14:26:52Z https://communities.sas.com/t5/New-SAS-User/Merging-datasets-with-different-variable-names/m-p/901074#M40162 <P>Is it possible to merge 2 data sets with different variable names for the same thing?</P><P>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.</P><P>&nbsp;</P><P>/* Merge LowRatedProducts with Products to access prices */<BR />data LowRatedProductsWithPrices;<BR />merge LowRatedProducts (in=a) Qed.Products (in=b);<BR />by product_id;&nbsp;<BR />if a and b;<BR />run;</P><P>/* Print the low-rated products along with their prices */<BR />PROC PRINT DATA=LowRatedProductsWithPrices;<BR />title "Low-Rated Products and Their Prices";<BR />RUN;</P><P>&nbsp;</P><P>This shows an error because review doesn't have products_id but product.</P> Wed, 01 Nov 2023 14:19:07 GMT https://communities.sas.com/t5/New-SAS-User/Merging-datasets-with-different-variable-names/m-p/901074#M40162 Adi27 2023-11-01T14:19:07Z https://communities.sas.com/t5/New-SAS-User/Merging-datasets-with-different-variable-names/m-p/901075#M40163 <PRE><CODE class=" language-sas">merge LowRatedProducts (in=a rename=(product=product_id)) Qed.Products (in=b); by product_id;</CODE></PRE> Wed, 01 Nov 2023 14:26:52 GMT https://communities.sas.com/t5/New-SAS-User/Merging-datasets-with-different-variable-names/m-p/901075#M40163 PaigeMiller 2023-11-01T14:26:52Z