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.
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
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
Thanks! I could get the long data set code to work. I really appreciate it...
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.