SPSSX Discussion

Data consolidation

Classic

List

Threaded

2 messages Options

prasad

Data consolidation

I have prescriptions dispensed weekly for each patient ID. How do I consolidate data for the total month based on the variables (generic name) and variable (quantity)? Example for ID1 drug e total quantity supplied for the entire month (04/2011) should appear as druge 14. Please see attached data file.Samplecopy.sav Thanks Prasad

David Marso

Re: Data consolidation

Administrator

See XDATE.MONTH, XDATE.YEAR functions and the AGGREGATE command.

prasad wrote

I have prescriptions dispensed weekly for each patient ID. How do I consolidate data for the total month based on the variables (generic name) and variable (quantity)? Example for ID1 drug e total quantity supplied for the entire month (04/2011) should appear as druge 14. Please see attached data file.Samplecopy.sav

Thanks Prasad

Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"