Based on your posting, here are some suggested SAS resources (SAS Data step functions, PROCs and
general data manipulation techniques) to consider:
1) INTNX function in a DATA step can assign a QUARTER date variable using the DATEPART [function]
2) A DATA step can be used to determine the "where PER is >= 105" condition.
3) PROC FREQ with a "BY QUARTER..." can compute your PERCENT and SUM statistics for your quarterly
4) And, using SAS ODS HTML and PROC PRINT (or PROC REPORT with some more advanced derivation
capabilities possibly alleviating the PROC FREQ requirement) can be used to generate your quarterly
summary with yearly total.
From: gsc...@hotmail.com - view profile
Date: Tues, Jun 20 2006 11:27 am
I am not very good at html and using different functions of SAS
I need to produce a calendar year quarterly report for data for the
last 5 years and produce
the report in HTML.
I am needing the percent of obs where PER is >= 105 for each calendar
quarter then a cumulative for each quarter within the year and then a
total for each year for the last five years
worth of data, I am showing a sample dataset below. Can someone help
Obs CNDTFPAY PER
2138 24JAN2000:00:00:00 103.160
2139 25JAN2000:00:00:00 101.972
2140 25JAN2000:00:00:00 119.967