Hi Al,
Please find the attached file for your required solution.
Regards
Sandeep
On Thu, Jul 15, 2010 at 5:46 AM, Al wrote:
>
> Dear All:
>
>
> This is the sample spread sheet i have.
>
> pat meds stdt spdt
> 111 ABC 1 .
> 111 CDE 130 150
> 111 NNN 132 140
> 111 GHI 160 170
> 111 LMN 165
Hi,
Add week columns adjucent to stdt, spdt eg. week21, week22
use the IF function for each week and return 1 if the dates fall within the
week. (eg. if(stdt <127 and (spdt > 156 or isblank(spdt)) ,1,0)
repeat this for each week.
then use the DATA -> SUBTOTALS COMMAND to get pat wise subtotals or
Dear All:
This is the sample spread sheet i have.
pat meds stdt spdt
111 ABC 1 .
111 CDE 130 150
111 NNN 132 140
111 GHI 160 170
111 LMN 165 .
111 OPQ 168 .
222 ABC 1 .
222 CBM 130 140
222 AAA 135 140
222 KHA 1 .
;
run;
I am trying to count the number of meds at diffe
