| Date: | Fri, 31 Mar 2006 09:57:22 -0800 |
|---|
| Reply-To: | sam <sghate@GMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | sam <sghate@GMAIL.COM> |
|---|
| Organization: | http://groups.google.com |
|---|
| Subject: | Re: mulltiple observations to one line of data |
|---|
|
| In-Reply-To: | <1143823278.875155.143960@i39g2000cwa.googlegroups.com> |
|---|
| Content-Type: | text/plain; charset="iso-8859-1" |
|---|
Thanks for your prompt replies. I appreciate that. One of the reply to
my question was to give details about the ratio that I want to
calculate and would it be possible to calcualte the ratio without
converting multiple lines of data to a single line.
To make it more clear the above database is a prescription claims
database. The variable date denotes the data the prescription was
filled and the variable days is the number of days of supply of the
medication.
The ratio i want to calculate is to find out the compliance of patients
taking the medications.
compliance= days supply of medication /(second fill date (date2) -
first fill date (date1) )
Subjects with a ratio of >= 0.80 would have high compliance.
| 
