Hi sasusers, i need to merge the 2 datasets as some columns not included in the dataset. Therefore, is it possible if i use proc univariate and then merge together? And i tried using sql but do not get the result. Just an example of the dataset: Spending data set, there are spendingid, customerid, totalprice and numunits Spending_id Customer_id totalprice numunits 1212112 100000 19 2 989898 112121 298 10 3i31030 20000 2 22 Customer dataset, there are customerid and firstname Customer_id firstname 12311111 Ellen 9908009 JOhn 3376247 Jay Question: Show all the customers in the 3rd quartile of their spending. Display their name, total spent and their customer id Thanks in advance.:)
... View more