## Finding "consistency" or multiple observations in a dataset...

Solved
Occasional Contributor
Posts: 10

# Finding "consistency" or multiple observations in a dataset...

I have a dataset with multiple observations per person.:

1. For each person in the dataset for more than one year, how many years of the total that we have data for are they showing up?

2. Sort this somehow so I know the people who are showing up most.

Accepted Solutions
Solution
‎02-16-2013 02:40 PM
Posts: 5,526

## Re: Finding "consistency" or multiple observations in a dataset...

Try these :

/* Long shape dataset: person identified by ID, numeric variable : X */
proc sql;
create table want as
select ID, count(X) as n
from myLongData

group by ID
order by desc n;

/* Wide shape dataset: person identified by ID, numeric variables : X2001,...,X2011 */
data want(keep=ID n);
set myWideData;
n = n(of X2001-X2011);
run;
proc sort data=want; by n descending; run;

PG

PG

All Replies
Solution
‎02-16-2013 02:40 PM
Posts: 5,526

## Re: Finding "consistency" or multiple observations in a dataset...

Try these :

/* Long shape dataset: person identified by ID, numeric variable : X */
proc sql;
create table want as
select ID, count(X) as n
from myLongData

group by ID
order by desc n;

/* Wide shape dataset: person identified by ID, numeric variables : X2001,...,X2011 */
data want(keep=ID n);
set myWideData;
n = n(of X2001-X2011);
run;
proc sort data=want; by n descending; run;

PG

PG
Occasional Contributor
Posts: 10

## Re: Finding "consistency" or multiple observations in a dataset...

Thanks! I could get the long data set code to work. I really appreciate it...

🔒 This topic is solved and locked.