Help using Base SAS procedures

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

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 10
Accepted Solution

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
Respected Advisor
Posts: 4,659

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

View solution in original post


All Replies
Solution
‎02-16-2013 02:40 PM
Respected Advisor
Posts: 4,659

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 146 views
  • 0 likes
  • 2 in conversation