I am trying to write the syntax to calculate the median number of visits per facility in a data set where each row/case is one visit. In Stata I would do:
bysort providercode: gen littlen=_n
bysort providercode: gen bign=_N
keep if little==big
centile little, centile (1 50 100)
However I need to write it in SPSS. I have got this far. The variable called 'count' is the equivalent of _n, which counts up by one for each record within each facility:
sort cases by providercode.
compute count = 1.
if providercode = lag(providercode) count = lag(count) + 1.
execute.
Now I need to calculate _N within providercode.
Can anyone help/advise please?
Thanks
Hi Suzanne,
I am not into STATA, so I can just guess what you are looking for, but here is my suggestion (if this is not what you are looking for, please describe the big N in a few more words):
n is the observation number within each facility from 1 to N, so N is the total number of observations within one facility. Is this right?
Then you are looking for the highest value of count and you can get this using the aggregate command.
Try something like this:
AGGREGATE
/OUTFILE=*
/BREAK=providercode
/N=MAX(count).
EXECUTE.
Instead of MAX you can also use LAST, because of your order.
Best,
Brian
- Badges
- Science topic
- Similar topics
- Mathematical Sciences
- Statistics
- Statistical Software
- SPSS