topic combine rows where one row has null value in SAS Procedures

combine rows where one row has null value

Mattress58 — Wed, 10 Feb 2016 20:39:15 GMT

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

Re: combine rows where one row has null value

LinusH — Wed, 10 Feb 2016 21:01:30 GMT

Depends on how the rest of your data set look like.
How did you get this layout? It looks like a transpose that went wrong.
I would prefer a normalized table design, which is more flexible to most reporting requirements. That would mean to transpose columns to rows, having one year, and one colour column. For your particular example it would be a quite simple use of the coalesce () function.

Re: combine rows where one row has null value

Astounding — Wed, 10 Feb 2016 21:05:11 GMT

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.