Hello, I am fairly new to SAS. I was working with the cars dataset from sashelp library. I want to create 38 datasets of all the "make" with a column of total sales which basically is the sum of 'invoice'. How do I write a macro for this? Below is the code I have written to create the dataset for the 'make' Acura : Thanks in advance! data cars; set sashelp.cars; run; proc sort data=cars; by make; run; data cars2; set cars; by make; if first.make then TotalInvoice = 0; Sales + Invoice; if last.make; drop totalinvoice; run; data cars3 ; set cars; where make="Acura"; run; proc sql; create table Acura as select make,invoice,sum(cars3.invoice) as Sales from cars3; quit;
... View more