BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
oncearunner
Calcite | Level 5

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.

1 ACCEPTED SOLUTION

Accepted Solutions
PGStats
Opal | Level 21

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

2 REPLIES 2
PGStats
Opal | Level 21

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
oncearunner
Calcite | Level 5

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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