topic Re: Shorten length of variable/count observations per participant in SAS Procedures

Shorten length of variable/count observations per participant

deleted_user — Thu, 22 Apr 2010 01:28:28 GMT

I have three data sets. Each one of them is very lengthy! So I need help in finding shortcuts on how to process the data sets.

1) I noticed that the length of some variables is unreasonably long so how do I shorten the length of those variables? I tried doing this, but it didn't work for me:
DATA A;
LENGTH MTOTAL $ 8;
SET TOT.TOTAL1;
RUN;

2) Each data set have countless participants that made visits. Each participant is supposed to have 32 observations per visit. How do I make sure there are exactly 32 observations per participant at each visit? I did PROC REPORT for each data set and tried counting 32 observations for each participant but that proved to be time consuming. What's the shortcut to do this?

Re: Shorten length of variable/count observations per participant

LinusH — Thu, 22 Apr 2010 07:43:56 GMT

1) What do you mean that this doesn't work? I got a clean $8 char for MTOTAL in the A table.

2) Depends on how you want the output, and what time consuming means.
One way is to use SQL, with COUNT(), GROUP BY and HAVING to filter out visits with less than 32 observations.

/Linus

Re: Shorten length of variable/count observations per participant

deleted_user — Thu, 22 Apr 2010 15:44:13 GMT

I tried proq sql count(). it worked. thanks!!