Hi
So i have data for sales for two years for different companies:
Company_code Sales Year
1 5 01
1 25 05
2 150 01
2 75 05
4 1 01
4 9 05
etc.
I now would like to create a dataset with the change in sales from year, such as:
Company_code DiffSales
1 20
2 -75
4 8
Is it possible to do this with proc sql? I am new to SAS, so help is much appreciated.
Thanks
assuming you only have two years of data and each company has two years;;;
proc sql;
create table want as
select
t1.company_code,
t2.sales - t1.sales as diffSales
from
have t1
inner join have t2
on t1.company = t2.company
and t1.year <> t2.year
where
t1.year='01';
quit;
assuming you only have two years of data and each company has two years;;;
proc sql;
create table want as
select
t1.company_code,
t2.sales - t1.sales as diffSales
from
have t1
inner join have t2
on t1.company = t2.company
and t1.year <> t2.year
where
t1.year='01';
quit;
Thanks!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.