|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>|
|Subject: ||Re: mulltiple observations to one line of data|
|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
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.