how can I get these on the same row to look like this
Region Vehicle year1 color1 year2 color 2
South impala 2014 blue 2015 black
Region Vehicle year1 color1 year2 color 2
South impala 2014 blue
South impala 2015 black
Here's an approach that doesn't require you to spell out all the variables you need to work with:
proc sort data=have;
by region vehicle;
run;
data want;
update have (obs=0) have;
by region vehicle;
run;
Good luck.
SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team.
Interested in speaking? Content from our attendees is one of the reasons that makes SAS Innovate such a special event!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.