topic Re: Building a matrix in SAS Programming

Building a matrix

hwangnyc — Wed, 29 Aug 2018 14:39:28 GMT

Hi everyone,

Here is a sample of my data.

The OBS is a unique individual.

Each column is a state that they have visited. 1=yes, 0=no

I'd like to to figure out the various combinations of states.

For example: OBS 1 and 7 has visited NewYork and Texas so NewYorkTexas would be 2

I'd like to do that for all possible combinations. Any suggestion as to how to begin?

Astounding — Wed, 29 Aug 2018 14:47:13 GMT

An easy way would be to string together all the flags:

all_locations = cat(NewYork, California, Texas, NewJersey, Washington);

You need to preserve this logic, so you know which position represents which state.

Then count:

proc freq data=have;

tables all_locations;

run;

hwangnyc — Wed, 29 Aug 2018 14:59:56 GMT

That was a astounding answer! THANK YOU!

Andygray — Wed, 29 Aug 2018 15:17:45 GMT

Hi @hwangnyc Can you post the output for the sample you provided for the benefit of the wider audience. Thank you!

Reeza — Wed, 29 Aug 2018 15:24:37 GMT