topic Help on proc report in SAS Procedures

Help on proc report

yash82 — Mon, 28 Nov 2011 19:41:19 GMT

Hi Guys, I am stuck in preparing proc tabulate output as I am kind of newbie on this. I am providing my input data and template here. Please share your views

Input

Period group Class code year Number Gross at start Gross between Gross at end

201112 Medical Opened at start - open 2010 100 100.00 100.00 100.00

201112 Medical Open at start - closed with payment 2009 122 133.00 144.00 155.00

201112 Medical Open at start - closed without payment 2010 140 160.00 180.00 200.00

201112 Medical Incurred during the year - open 2011 160 190.00 220.00 250.00

201112 Medical Incurred during the year - closed with payment 2011 182 223.00 264.00 305.00

201112 Medical Incurred during the year - closed without payment 2011 204 256.00 308.00 360.00

201112 Medical Reopened during the year - open 2010 226 289.00 352.00 415.00

201112 Medical Reopened during the year - closed with payment 2010 246 319.00 392.00 465.00

201112 Medical Reopened during the year - closed without payment 2010 266 349.00 432.00 515.00

Template is attached

A1-A10 is Values of Gross at start where code=Opened at start - open

B1-B10 is Values of Gross between where code=Opened at start - open

C1-B10 is Values of Gross at end where code=Opened at start - open

D1-D10 is Values of Gross at start where code=Open at start - closed with payment

E1-E10 is Values of Gross between where code=Open at start - closed with payment

F1-F10 is Values of Gross at end where code=Open at start - closed with payment

G1-G10 is Values of Gross at start where code=Open at start - closed without payment

H1-H10 is Values of Gross between where code=Open at start - closed without payment

I1-I10 is Values of Gross at end where code=Open at start - closed without payment

I have managed to produce the output but its not producing correctly as desired. I think I am making mistakes somewhere in the class and Var. Any help would be really appreciable

Help on proc report

GreggB — Mon, 28 Nov 2011 20:23:41 GMT

it may help if you paste your code in so we can look at what you have.

Help on proc report

Ksharp — Tue, 29 Nov 2011 03:14:24 GMT

Not understand what you mean totally.

data temp;
input Period   group $  Class_code & $40. year  Number  Gross_at_start  Gross_between  Gross_at_end; 
datalines;
201112  Medical   Opened at start - open   2010  100  100.00  100.00  100.00
201112  Medical   Open at start - closed with payment   2009  122  133.00  144.00  155.00
201112  Medical   Open at start - closed without payment   2010  140  160.00  180.00  200.00
;
run; 
proc report data=temp nowd;
column Period  Class_code,(Gross_at_start  Gross_between  Gross_at_end );
define period/group;
define class_code/across;
rbreak after/summarize dol;
run;

Ksharp

Help on proc report

yash82 — Tue, 29 Nov 2011 04:52:08 GMT

Hi Ksharp,

Is it possible to produce the desired output using Proc Tabulate ???

proc tabulate data=temp nowd;

var Period Class_code,(Gross_at_start Gross_between Gross_at_end );

tables

period,( Class_code *Gross_at_start * Gross_between * Gross_at_end)

run;

I did this but its not producing what we require. Can you help me ??

Help on proc report

Ksharp — Tue, 29 Nov 2011 06:11:17 GMT

Sure. Of course.

data temp;
input Period   group $  Class_code & $40. year  Number  Gross_at_start  Gross_between  Gross_at_end; 
datalines;
201112  Medical   Opened at start - open   2010  100  100.00  100.00  100.00
201112  Medical   Open at start - closed with payment   2009  122  133.00  144.00  155.00
201112  Medical   Open at start - closed without payment   2010  140  160.00  180.00  200.00
;
run; 
proc tabulate data=temp ;
class  Period  Class_code;
var  Gross_at_start  Gross_between  Gross_at_end ;
table Period ,Class_code*(Gross_at_start  Gross_between  Gross_at_end );
run;

Ksharp

Help on proc report

yash82 — Tue, 29 Nov 2011 18:48:34 GMT

Hi Ksharp,

I applied your logicc but somehow my variable name is getting displayed in output... like instead of class code , I want open and closed .. and also my title1 is not displayed...

also how can I further break my class into settled and settled without payment... Let me put another set of sample data...

data temp;

input Period group $ Class_code & $40. year Number Gross_at_start Gross_between Gross_at_end;

datalines;

201112 Medical Opened at start - open 2010 100 100.00 100.00 100.00

201112 Medical Open at start - closed with payment 2009 122 133.00 144.00 155.00

201112 Medical Open at start - closed without payment 2010 140 160.00 180.00 200.00

201111 Medical Settled with payment no pending 2004 130 200 500 800

201012 Medical Settled without payment 2008 100 100 100 500

;

run;

Hope I am making sense and thanks a lot for helping me out... Really appreciated...

Help on proc report

Ksharp — Wed, 30 Nov 2011 03:57:26 GMT

I think your post is very obscure. Where are OPEN CLOSE come from?

Where are settled and settled without payment. come from?

I think you need use the data you posted to instead of A1 B1...

That will be more clear your problem.

Ksharp

Help on proc report

yash82 — Wed, 30 Nov 2011 13:29:25 GMT

Hi Ksharp, Look at this sample data

Year	claimtype	begin amount	middle amount	end amount	claim no	claim subtype	break1	break2	break3	break4
2005	Incurred during the year - closed with payment	182	318	428	537	Claims incurred during the year	Closed Claims at the end of the period:	settled
2006	Incurred during the year - closed with payment	212	331	441	550	Claims incurred during the year	Closed Claims at the end of the period:	settled
2006	Incurred during the year - closed without payment	184	319	429	538	Claims incurred during the year	Closed Claims at the end of the period:	settled without payment
2007	Incurred during the year - closed without payment	213	332	442	551	Claims incurred during the year	Closed Claims at the end of the period:	settled without payment
2007	Incurred during the year - open	177	320	430	539	RBNS claims. Open Claims at the beginning of the year	Open Claims at the end of the period	settled
2008	Incurred during the year - open	214	333	443	552	RBNS claims. Open Claims at the beginning of the year	Open Claims at the end of the period	settled
2008	Open at the beginning of the year - closed with payment	192	321	431	540	RBNS claims. Open Claims at the beginning of the year	Closed Claims at the end of the period:	settled
2009	Open at the beginning of the year - closed with payment	215	334	444	553	RBNS claims. Open Claims at the beginning of the year	Closed Claims at the end of the period:	settled
2009	Open at the beginning of the year - closed without payment	267	322	432	541	RBNS claims. Open Claims at the beginning of the year	Closed Claims at the end of the period:	settled without payment
2010	Open at the beginning of the year - closed without payment	216	335	445	554	RBNS claims. Open Claims at the beginning of the year	Closed Claims at the end of the period:	settled without payment
2010	Open at the beginning of the year - open	266	323	433	542	RBNS claims. Open Claims at the beginning of the year	Open Claims at the end of the period	settled
2011	Open at the beginning of the year - open	217	336	446	555	RBNS claims. Open Claims at the beginning of the year	Open Claims at the end of the period	settled
2008	Reopened during the year - closed with payment	218	337	447	556	Reopen Claims during the year	Closed Claims at the end of the period:	settled without payment
2011	Reopened during the year - closed with payment	260	324	434	543	Reopen Claims during the year	Closed Claims at the end of the period:	settled without payment
2009	Reopened during the year - open	262	326	436	545	Claims incurred during the year	Open Claims at the end of the period	settled
2010	Reopened during the year - open	220	339	449	558	Claims incurred during the year	Open Claims at the end of the period	settled

Here, I have need to break the data based on condition of tt1 i.e. if tt1 is 'RBNS claims. Open Claims at the beginning of the year' then I should print only three columns and for remaining conditions I should print all 4 columns . Also in case of closed claims I must sub categorize it into settled with payment and settled without payment. Something like this

Gross

RBNS claims. Open Claims at the beginning of the year

Claims incurred during the year

Reopen Claims during the year

Open Claims at the end of the period

Closed Claims at the end of the period:

Open Claims at the end of the period

Closed Claims at the end of the period:

Open Claims at the end of the period

Closed Claims at the end of the period:

settled

settled without any payment

settled

settled without any payment

Year
(AY or UWY)

Number of claims

Gross RBNS at the beginning of the year