Thanks for your help, although I am still unsure how to proceed. Here is the code I have from Query Builder, I need to add another column which is Auto% Change - this needs to be a measure of the change against the previous month for the customer, so should be blank/null for the first month for each customer. I am not sure how to use the DATA STEP. PROC SQL;
CREATE TABLE WORK.QUERY_FOR_ALL_VOL_0000 AS
SELECT t1.CUSTOMER_NUM,
t1.YEAR,
t1.MONTH,
t1.'AUTO%'n
FROM WORK.QUERY_FOR_ALL_VOL t1;
QUIT; Thanks
... View more