OMS Command with Custom Tables (Multiple Layers)

[Manoj Arora (DEL/Abacus Analytics)]

Hi All,

 

Please find attached the syntax used for exporting output generated through OMS command. My output contains lots of layers. I am also attaching output which is exported with OMS command (ctables.xls) and with normal export (ctables_1.xls). Please let me know how can I get (ctables_1.xls) using OMS Command. If I do not use any layer it is working fine.

 

 

OMS

   /SELECT TABLES

   /IF COMMANDS=["CTables"]

        subtypes=["Custom Table"]

  /DESTINATION FORMAT=XLS  OUTFILE ="C:\manoj~fdrive\try\OMS Command\ctables.xls" tables=PIVOTABLE

/columns sequence=[LALL].

 

 

TEMPORARY.

CTABLES

  /VLABELS VARIABLES=rt R_Q4 ct DISPLAY=LABEL

  /TABLE rt [COUNT F40.0, COLPCT.COUNT PCT40.1] + R_Q4  [COUNT F40.0, COLPCT.COUNT PCT40.1, TOTALS[COUNT F40.0]]

By ct + GRIDA + GRIDB  + GRIDC  + GRIDD +  R_Q5  + town_class  + zone  + n_sec + CENTRE  By (rt1 + Brand + n_brand + brnd_gra + brnd_gra1)

  /SLABELS POSITION=ROW

  /CATEGORIES VARIABLES=rt ct ORDER=A KEY=VALUE EMPTY=INCLUDE

  /CATEGORIES VARIABLES=R_Q4             ORDER=A KEY=VALUE EMPTY=INCLUDE TOTAL=YES LABEL='Answering Base' POSITION=BEFORE

  /TITLES

    TITLE="R_Q4-How involved are you with various aspects of the life insurance policy/policies that you have."

    CORNER='Base : All Total'

    CAPTION="Job Number :                Project -            Segment -   1            )DATE".

 

OMSEND.

 

 

CTABLES.XLS

 

Custom Tables
R_Q4-How involved are you with various aspects of the life insurance policy/policies that you have.
Base : All Total					Market	BRAND-BRAND FOR WHICH RECRUITED					n_brand. Brand	brnd_gra										brnd_gra1
					Total	HDFC Life  / HDFC Standard Life	ICICI Prudential Life Insurance	LIC of India	Max New York Life	SBI Life	Consolidated  competition	HDFC_Agent	HDFC_Banca	ICICI_Agent	ICICI_Banca	LIC_Agent	LIC_Banca	MAX_Agent	MAX_Banca	SBI_Agent	SBI_Banca	CC_Agent	CC_Banca
	Total	Count		Total	1538	156	152	153	150	927	611	79	69	95	47	152	0	88	47	495	372	414	163
			GRIDA-Channel of Purchase	Agent	909	79	95	152	88	495	414	79	0	95	0	152	0	88	0	495	0	414	0
				Bank	535	69	47	0	47	372	163	0	69	0	47	0	0	0	47	0	372	0	163
				CS / CA	36	3	4	0	7	22	14	0	0	0	0	0	0	0	0	0	0	0	0
				Broker	58	5	6	1	8	38	20	0	0	0	0	0	0	0	0	0	0	0	0
			GRIDB-Policy Type	ULIP	703	76	89	4	30	504	199	35	35	62	22	4	0	17	9	254	219	118	66
				Traditional	835	80	63	149	120	423	412	44	34	33	25	148	0	71	38	241	153	296	97
			GRIDC-Type of customer	New customer	315	12	8	9	14	272	43	8	4	6	2	9	0	5	7	149	112	28	13
				Old customer	1223	144	144	144	136	655	568	71	65	89	45	143	0	83	40	346	260	386	150
			GRIDD-Amount of Premium	Up to Rs. 25,000	825	122	107	131	114	351	474	59	57	66	33	130	0	66	37	192	139	321	127
				Rs. 25,000 to Rs. 50.000	392	23	34	18	31	286	106	13	9	23	9	18	0	20	8	158	100	74	26
				More than Rs. 50,000	321	11	11	4	5	290	31	7	3	6	5	4	0	2	2	145	133	19	10
			R_Q5-Could you please tell me your age?	25-30 years	315	65	47	57	53	93	222	36	26	29	15	57	0	31	17	61	32	153	58
				31-35 years	329	34	38	33	33	191	138	16	15	25	11	33	0	15	12	101	73	89	38
				36-40 years	317	27	34	19	24	213	104	13	13	22	8	18	0	17	6	124	71	70	27
				41-45 years	282	19	15	21	21	206	76	8	10	6	8	21	0	13	6	102	93	48	24
				45-50 years	295	11	18	23	19	224	71	6	5	13	5	23	0	12	6	107	103	54	16
			Town class	Metro	516	63	63	43	59	288	228	33	27	45	15	42	0	38	12	167	99	158	54
				Tier1	467	53	44	50	50	270	197	30	20	24	16	50	0	30	17	153	98	134	53
				Tier2	555	40	45	60	41	369	186	16	22	26	16	60	0	20	18	175	175	122	56
			zone	North	296	29	29	26	29	183	113	11	15	15	11	25	0	14	9	84	78	65	35
				West	542	62	54	53	53	320	222	32	27	35	16	53	0	37	13	166	129	157	56
				East	288	25	26	31	26	180	108	13	12	20	6	31	0	15	9	105	72	79	27
				South	412	40	43	43	42	244	168	23	15	25	14	43	0	22	16	140	93	113	45
			SEC	A	1027	103	98	77	93	656	371	54	42	60	31	77	0	51	31	343	266	242	104
				B	424	47	52	54	51	220	204	21	25	33	16	53	0	34	13	121	87	141	54
				C	75	5	2	17	6	45	30	3	2	2	0	17	0	3	3	29	15	25	5
				D	12	1	0	5	0	6	6	1	0	0	0	5	0	0	0	2	4	6	0
			CENTRE-FIELDWORK CENTRES	Ahmedabad	79	8	8	9	9	45	34	3	4	4	3	9	0	5	3	20	20	21	10
				Surat	84	10	7	8	6	53	31	4	5	4	3	8	0	4	2	25	25	20	10
				Vadodara	55	5	6	5	5	34	21	2	3	5	1	5	0	3	2	17	16	15	6
				Bhubaneshwar	66	8	6	5	7	40	26	3	5	4	2	5	0	3	3	20	19	15	10
				Bangalore	82	10	9	9	11	43	39	8	2	5	3	9	0	6	5	31	12	28	10
				Chennai	118	15	15	10	15	63	55	6	8	8	5	10	0	8	5	30	30	32	18
				Coimbatore	46	2	4	5	4	31	15	2	0	2	2	5	0	2	2	15	15	11	4
				Delhi	147	17	16	11	17	86	61	6	9	11	4	10	0	9	3	38	34	36	16
				Jodhpur	39	3	3	5	3	25	14	1	2	1	2	5	0	1	2	13	10	8	6
				Guwahati	60	3	3	5	4	45	15	1	2	2	1	5	0	2	2	18	26	10	5
				Hyderabad	74	8	8	9	7	42	32	5	2	5	2	9	0	3	2	33	7	22	6
				Vijayawada	28	0	3	5	0	20	8	0	0	3	0	5	0	0	0	11	8	8	0
				Indore	51	5	4	5	4	33	18	1	3	2	1	5	0	2	1	16	14	10	5
				Cochin	64	5	4	5	5	45	19	2	3	2	2	5	0	3	2	20	21	12	7
				Kolkata	126	14	15	11	15	71	55	9	5	12	3	11	0	10	4	55	15	42	12
				Chandigarh	55	5	5	5	4	36	19	2	2	2	2	5	0	2	2	16	18	11	6
				Ludhiana	55	4	5	5	5	36	19	2	2	1	3	5	0	2	2	17	16	10	7
				Mumbai	125	17	17	11	12	68	57	12	5	14	3	11	0	11	0	44	20	48	8
				Patna	23	0	2	5	0	16	7	0	0	2	0	5	0	0	0	9	7	7	0
				Ranchi	13	0	0	5	0	8	5	0	0	0	0	5	0	0	0	3	5	5	0
				Pune	78	10	6	9	11	42	36	7	3	2	3	9	0	9	2	19	18	27	8
				Nagpur	70	7	6	6	6	45	25	3	4	4	2	6	0	3	3	25	16	16	9
		Column N %		Total	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
			GRIDA-Channel of Purchase	Agent	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	.0%	100.0%	.0%	100.0%	.0%	100.0%	.0%	100.0%	.0%
				Bank	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	.0%	100.0%	.0%	100.0%	.0%	.0%	.0%	100.0%	.0%	100.0%	.0%	100.0%
				CS / CA	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%
				Broker	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%
			GRIDB-Policy Type	ULIP	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
				Traditional	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
			GRIDC-Type of customer	New customer	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
				Old customer	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
			GRIDD-Amount of Premium	Up to Rs. 25,000	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
				Rs. 25,000 to Rs. 50.000	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
				More than Rs. 50,000	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
			R_Q5-Could you please tell me your age?	25-30 years	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
				31-35 years	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
36-40 years	100.0%			100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
41-45 years	100.0%			100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
45-50 years	100.0%			100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
Town class	Metro		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	Tier1		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	Tier2		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
zone	North		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	West		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	East		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	South		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
SEC	A		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	B		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	C		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	D		100.0%	100.0%	.0%	100.0%	.0%	100.0%	100.0%	100.0%	.0%	.0%	.0%	100.0%	.0%	.0%	.0%	100.0%	100.0%	100.0%	.0%
CENTRE-FIELDWORK CENTRES	Ahmedabad		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	Surat		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	Vadodara		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	Bhubaneshwar		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	Bangalore		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	Chennai		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	Coimbatore		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	Delhi		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	Jodhpur		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	Guwahati		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	Hyderabad		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	Vijayawada		100.0%	.0%	100.0%	100.0%	.0%	100.0%	100.0%	.0%	.0%	100.0%	.0%	100.0%	.0%	.0%	.0%	100.0%	100.0%	100.0%	.0%
	Indore		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	Cochin		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	Kolkata		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	Chandigarh		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	Ludhiana		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	Mumbai		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%
	Patna		100.0%	.0%	100.0%	100.0%	.0%	100.0%	100.0%	.0%	.0%	100.0%	.0%	100.0%	.0%	.0%	.0%	100.0%	100.0%	100.0%	.0%
	Ranchi		100.0%	.0%	.0%	100.0%	.0%	100.0%	100.0%	.0%	.0%	.0%	.0%	100.0%	.0%	.0%	.0%	100.0%	100.0%	100.0%	.0%
	Pune		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
	Nagpur		100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
R_Q4-How involved are you with various aspects of the life insurance policy/policies that you have, in terms of the purchase process, managing the regular transactions with the insurance company, etc. ?	Answering Base	Count		Total	1538	156	152	153	150	927	611	79	69	95	47	152	0	88	47	495	372	414	163
			GRIDA-Channel of Purchase	Agent	909	79	95	152	88	495	414	79	0	95	0	152	0	88	0	495	0	414	0
				Bank	535	69	47	0	47	372	163	0	69	0	47	0	0	0	47	0	372	0	163
				CS / CA	36	3	4	0	7	22	14	0	0	0	0	0	0	0	0	0	0	0	0
				Broker	58	5	6	1	8	38	20	0	0	0	0	0	0	0	0	0	0	0	0
			GRIDB-Policy Type	ULIP	703	76	89	4	30	504	199	35	35	62	22	4	0	17	9	254	219	118	66
				Traditional	835	80	63	149	120	423	412	44	34	33	25	148	0	71	38	241	153	296	97
			GRIDC-Type of customer	New customer	315	12	8	9	14	272	43	8	4	6	2	9	0	5	7	149	112	28	13
				Old customer	1223	144	144	144	136	655	568	71	65	89	45	143	0	83	40	346	260	386	150
			GRIDD-Amount of Premium	Up to Rs. 25,000	825	122	107	131	114	351	474	59	57	66	33	130	0	66	37	192	139	321	127
				Rs. 25,000 to Rs. 50.000	392	23	34	18	31	286	106	13	9	23	9	18	0	20	8	158	100	74	26
				More than Rs. 50,000	321	11	11	4	5	290	31	7	3	6	5	4	0	2	2	145	133	19	10
			R_Q5-Could you please tell me your age?	25-30 years	315	65	47	57	53	93	222	36	26	29	15	57	0	31	17	61	32	153	58
				31-35 years	329	34	38	33	33	191	138	16	15	25	11	33	0	15	12	101	73	89	38
				36-40 years	317	27	34	19	24	213	104	13	13	22	8	18	0	17	6	124	71	70	27
				41-45 years	282	19	15	21	21	206	76	8	10	6	8	21	0	13	6	102	93	48	24
				45-50 years	295	11	18	23	19	224	71	6	5	13	5	23	0	12	6	107	103	54	16
			Town class	Metro	516	63	63	43	59	288	228	33	27	45	15	42	0	38	12	167	99	158	54
				Tier1	467	53	44	50	50	270	197	30	20	24	16	50	0	30	17	153	98	134	53
				Tier2	555	40	45	60	41	369	186	16	22	26	16	60	0	20	18	175	175	122	56
			zone	North	296	29	29	26	29	183	113	11	15	15	11	25	0	14	9	84	78	65	35
				West	542	62	54	53	53	320	222	32	27	35	16	53	0	37	13	166	129	157	56
				East	288	25	26	31	26	180	108	13	12	20	6	31	0	15	9	105	72	79	27
				South	412	40	43	43	42	244	168	23	15	25	14	43	0	22	16	140	93	113	45
			SEC	A	1027	103	98	77	93	656	371	54	42	60	31	77	0	51	31	343	266	242	104
				B	424	47	52	54	51	220	204	21	25	33	16	53	0	34	13	121	87	141	54
				C	75	5	2	17	6	45	30	3	2	2	0	17	0	3	3	29	15	25	5
				D	12	1	0	5	0	6	6	1	0	0	0	5	0	0	0	2	4	6	0
			CENTRE-FIELDWORK CENTRES	Ahmedabad	79	8	8	9	9	45	34	3	4	4	3	9	0	5	3	20	20	21	10
				Surat	84	10	7	8	6	53	31	4	5	4	3	8	0	4	2	25	25	20	10
				Vadodara	55	5	6	5	5	34	21	2	3	5	1	5	0	3	2	17	16	15	6
				Bhubaneshwar	66	8	6	5	7	40	26	3	5	4	2	5	0	3	3	20	19	15	10
				Bangalore	82	10	9	9	11	43	39	8	2	5	3	9	0	6	5	31	12	28	10
				Chennai	118	15	15	10	15	63	55	6	8	8	5	10	0	8	5	30	30	32	18
				Coimbatore	46	2	4	5	4	31	15	2	0	2	2	5	0	2	2	15	15	11	4
				Delhi	147	17	16	11	17	86	61	6	9	11	4	10	0	9	3	38	34	36	16
				Jodhpur	39	3	3	5	3	25	14	1	2	1	2	5	0	1	2	13	10	8	6
				Guwahati	60	3	3	5	4	45	15	1	2	2	1	5	0	2	2	18	26	10	5
				Hyderabad	74	8	8	9	7	42	32	5	2	5	2	9	0	3	2	33	7	22	6
				Vijayawada	28	0	3	5	0	20	8	0	0	3	0	5	0	0	0	11	8	8	0
				Indore	51	5	4	5	4	33	18	1	3	2	1	5	0	2	1	16	14	10	5
				Cochin	64	5	4	5	5	45	19	2	3	2	2	5	0	3	2	20	21	12	7
				Kolkata	126	14	15	11	15	71	55	9	5	12	3	11	0	10	4	55	15	42	12
				Chandigarh	55	5	5	5	4	36	19	2	2	2	2	5	0	2	2	16	18	11	6
				Ludhiana	55	4	5	5	5	36	19	2	2	1	3	5	0	2	2	17	16	10	7
				Mumbai	125	17	17	11	12	68	57	12	5	14	3	11	0	11	0	44	20	48	8
				Patna	23	0	2	5	0	16	7	0	0	2	0	5	0	0	0	9	7	7	0
				Ranchi	13	0	0	5	0	8	5	0	0	0	0	5	0	0	0	3	5	5	0
				Pune	78	10	6	9	11	42	36	7	3	2	3	9	0	9	2	19	18	27	8
				Nagpur	70	7	6	6	6	45	25	3	4	4	2	6	0	3	3	25	16	16	9
	You are completely involved with all aspects of the life ins	Count		Total	1263	136	131	132	123	741	522	72	59	83	38	131	0	74	37	389	304	360	134
			GRIDA-Channel of Purchase	Agent	749	72	83	131	74	389	360	72	0	83	0	131	0	74	0	389	0	360	0
				Bank	438	59	38	0	37	304	134	0	59	0	38	0	0	0	37	0	304	0	134
				CS / CA	29	3	4	0	6	16	13	0	0	0	0	0	0	0	0	0	0	0	0
				Broker	47	2	6	1	6	32	15	0	0	0	0	0	0	0	0	0	0	0	0
			GRIDB-Policy Type	ULIP	560	65	79	3	23	390	170	34	28	54	20	3	0	14	7	188	178	105	55
				Traditional	703	71	52	129	100	351	352	38	31	29	18	128	0	60	30	201	126	255	79
			GRIDC-Type of customer	New customer	263	11	7	8	12	225	38	7	4	5	2	8	0	4	6	123	94	24	12
				Old customer	1000	125	124	124	111	516	484	65	55	78	36	123	0	70	31	266	210	336	122
			GRIDD-Amount of Premium	Up to Rs. 25,000	705	108	96	114	96	291	414	55	49	61	27	113	0	55	31	157	121	284	107
				Rs. 25,000 to Rs. 50.000	302	18	24	15	23	222	80	10	7	16	6	15	0	17	5	122	76	58	18
				More than Rs. 50,000	256	10	11	3	4	228	28	7	3	6	5	3	0	2	1	110	107	18	9
			R_Q5-Could you please tell me your age?	25-30 years	255	56	40	43	41	75	180	34	21	26	11	43	0	24	12	46	29	127	44
				31-35 years	258	28	27	29	27	147	111	12	14	18	7	29	0	14	10	77	58	73	31
36-40 years				256	24	34	17	17	164	92	12	11	22	8	16	0	12	4	97	52	62	23
41-45 years				241	18	14	21	20	168	73	8	9	6	7	21	0	13	5	78	80	48	21
45-50 years				253	10	16	22	18	187	66	6	4	11	5	22	0	11	6	91	85	50	15
Town class			Metro	457	60	60	40	54	243	214	32	25	43	14	39	0	35	12	146	80	149	51
			Tier1	360	47	35	38	37	203	157	27	18	20	11	38	0	24	11	113	76	109	40
			Tier2	446	29	36	54	32	295	151	13	16	20	13	54	0	15	14	130	148	102	43
zone			North	238	23	26	21	21	147	91	9	12	14	9	20	0	10	7	69	61	53	28
			West	403	51	40	41	44	227	176	28	22	27	10	41	0	33	9	110	98	129	41
			East	257	25	22	29	24	157	100	13	12	17	5	29	0	14	8	91	64	73	25
			South	365	37	43	41	34	210	155	22	13	25	14	41	0	17	13	119	81	105	40
SEC			A	837	91	85	66	78	517	320	51	36	52	26	66	0	45	25	266	214	214	87
			B	349	41	44	46	40	178	171	18	22	29	12	45	0	26	10	95	72	118	44
			C	65	3	2	15	5	40	25	2	1	2	0	15	0	3	2	26	14	22	3
			D	12	1	0	5	0	6	6	1	0	0	0	5	0	0	0	2	4	6	0
CENTRE-FIELDWORK CENTRES			Ahmedabad	61	8	7	7	8	31	30	3	4	4	2	7	0	5	3	12	16	19	9
			Surat	47	5	3	4	2	33	14	2	3	2	1	4	0	2	0	14	16	10	4
			Vadodara	43	3	4	5	5	26	17	1	2	3	1	5	0	3	2	10	15	12	5
			Bhubaneshwar	60	8	4	5	7	36	24	3	5	2	2	5	0	3	3	17	18	13	10
			Bangalore	74	9	9	7	6	43	31	7	2	5	3	7	0	3	3	31	12	22	8
			Chennai	115	15	15	10	15	60	55	6	8	8	5	10	0	8	5	28	29	32	18
			Coimbatore	36	2	4	5	3	22	14	2	0	2	2	5	0	2	1	10	11	11	3
			Delhi	113	16	14	9	13	61	52	6	8	10	3	8	0	7	3	30	21	31	14
			Jodhpur	28	1	2	5	2	18	10	0	1	1	1	5	0	0	2	7	9	6	4
			Guwahati	48	3	2	4	3	36	12	1	2	2	0	4	0	2	1	14	21	9	3
			Hyderabad	70	8	8	9	7	38	32	5	2	5	2	9	0	3	2	30	6	22	6
			Vijayawada	23	0	3	5	0	15	8	0	0	3	0	5	0	0	0	7	7	8	0
			Indore	32	3	1	4	3	21	11	1	2	0	0	4	0	1	1	11	8	6	3
			Cochin	47	3	4	5	3	32	15	2	1	2	2	5	0	1	2	13	16	10	5
			Kolkata	117	14	14	11	14	64	53	9	5	11	3	11	0	9	4	51	13	40	12
			Chandigarh	48	2	5	2	3	36	12	1	1	2	2	2	0	2	1	16	18	7	4
			Ludhiana	49	4	5	5	3	32	17	2	2	1	3	5	0	1	1	16	13	9	6
			Mumbai	112	15	17	10	12	58	54	11	4	14	3	10	0	11	0	37	17	46	7
			Patna	19	0	2	4	0	13	6	0	0	2	0	4	0	0	0	6	7	6	0
			Ranchi	13	0	0	5	0	8	5	0	0	0	0	5	0	0	0	3	5	5	0
			Pune	72	10	6	7	11	38	34	7	3	2	3	7	0	9	2	16	18	25	8
			Nagpur	36	7	2	4	3	20	16	3	4	2	0	4	0	2	1	10	8	11	5
Column N %			Total	82.1%	87.2%	86.2%	86.3%	82.0%	79.9%	85.4%	91.1%	85.5%	87.4%	80.9%	86.2%	.0%	84.1%	78.7%	78.6%	81.7%	87.0%	82.2%
		GRIDA-Channel of Purchase	Agent	82.4%	91.1%	87.4%	86.2%	84.1%	78.6%	87.0%	91.1%	.0%	87.4%	.0%	86.2%	.0%	84.1%	.0%	78.6%	.0%	87.0%	.0%
			Bank	81.9%	85.5%	80.9%	.0%	78.7%	81.7%	82.2%	.0%	85.5%	.0%	80.9%	.0%	.0%	.0%	78.7%	.0%	81.7%	.0%	82.2%
			CS / CA	80.6%	100.0%	100.0%	.0%	85.7%	72.7%	92.9%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%
			Broker	81.0%	40.0%	100.0%	100.0%	75.0%	84.2%	75.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%
		GRIDB-Policy Type	ULIP	79.7%	85.5%	88.8%	75.0%	76.7%	77.4%	85.4%	97.1%	80.0%	87.1%	90.9%	75.0%	.0%	82.4%	77.8%	74.0%	81.3%	89.0%	83.3%
			Traditional	84.2%	88.8%	82.5%	86.6%	83.3%	83.0%	85.4%	86.4%	91.2%	87.9%	72.0%	86.5%	.0%	84.5%	78.9%	83.4%	82.4%	86.1%	81.4%
		GRIDC-Type of customer	New customer	83.5%	91.7%	87.5%	88.9%	85.7%	82.7%	88.4%	87.5%	100.0%	83.3%	100.0%	88.9%	.0%	80.0%	85.7%	82.6%	83.9%	85.7%	92.3%
			Old customer	81.8%	86.8%	86.1%	86.1%	81.6%	78.8%	85.2%	91.5%	84.6%	87.6%	80.0%	86.0%	.0%	84.3%	77.5%	76.9%	80.8%	87.0%	81.3%
		GRIDD-Amount of Premium	Up to Rs. 25,000	85.5%	88.5%	89.7%	87.0%	84.2%	82.9%	87.3%	93.2%	86.0%	92.4%	81.8%	86.9%	.0%	83.3%	83.8%	81.8%	87.1%	88.5%	84.3%
			Rs. 25,000 to Rs. 50.000	77.0%	78.3%	70.6%	83.3%	74.2%	77.6%	75.5%	76.9%	77.8%	69.6%	66.7%	83.3%	.0%	85.0%	62.5%	77.2%	76.0%	78.4%	69.2%
			More than Rs. 50,000	79.8%	90.9%	100.0%	75.0%	80.0%	78.6%	90.3%	100.0%	100.0%	100.0%	100.0%	75.0%	.0%	100.0%	50.0%	75.9%	80.5%	94.7%	90.0%
		R_Q5-Could you please tell me your age?	25-30 years	81.0%	86.2%	85.1%	75.4%	77.4%	80.6%	81.1%	94.4%	80.8%	89.7%	73.3%	75.4%	.0%	77.4%	70.6%	75.4%	90.6%	83.0%	75.9%
			31-35 years	78.4%	82.4%	71.1%	87.9%	81.8%	77.0%	80.4%	75.0%	93.3%	72.0%	63.6%	87.9%	.0%	93.3%	83.3%	76.2%	79.5%	82.0%	81.6%
	36-40 years		80.8%	88.9%	100.0%	89.5%	70.8%	77.0%	88.5%	92.3%	84.6%	100.0%	100.0%	88.9%	.0%	70.6%	66.7%	78.2%	73.2%	88.6%	85.2%
	41-45 years		85.5%	94.7%	93.3%	100.0%	95.2%	81.6%	96.1%	100.0%	90.0%	100.0%	87.5%	100.0%	.0%	100.0%	83.3%	76.5%	86.0%	100.0%	87.5%
	45-50 years		85.8%	90.9%	88.9%	95.7%	94.7%	83.5%	93.0%	100.0%	80.0%	84.6%	100.0%	95.7%	.0%	91.7%	100.0%	85.0%	82.5%	92.6%	93.8%
	Town class	Metro	88.6%	95.2%	95.2%	93.0%	91.5%	84.4%	93.9%	97.0%	92.6%	95.6%	93.3%	92.9%	.0%	92.1%	100.0%	87.4%	80.8%	94.3%	94.4%
		Tier1	77.1%	88.7%	79.5%	76.0%	74.0%	75.2%	79.7%	90.0%	90.0%	83.3%	68.8%	76.0%	.0%	80.0%	64.7%	73.9%	77.6%	81.3%	75.5%
		Tier2	80.4%	72.5%	80.0%	90.0%	78.0%	79.9%	81.2%	81.3%	72.7%	76.9%	81.3%	90.0%	.0%	75.0%	77.8%	74.3%	84.6%	83.6%	76.8%
	zone	North	80.4%	79.3%	89.7%	80.8%	72.4%	80.3%	80.5%	81.8%	80.0%	93.3%	81.8%	80.0%	.0%	71.4%	77.8%	82.1%	78.2%	81.5%	80.0%
		West	74.4%	82.3%	74.1%	77.4%	83.0%	70.9%	79.3%	87.5%	81.5%	77.1%	62.5%	77.4%	.0%	89.2%	69.2%	66.3%	76.0%	82.2%	73.2%
		East	89.2%	100.0%	84.6%	93.5%	92.3%	87.2%	92.6%	100.0%	100.0%	85.0%	83.3%	93.5%	.0%	93.3%	88.9%	86.7%	88.9%	92.4%	92.6%
		South	88.6%	92.5%	100.0%	95.3%	81.0%	86.1%	92.3%	95.7%	86.7%	100.0%	100.0%	95.3%	.0%	77.3%	81.3%	85.0%	87.1%	92.9%	88.9%
	SEC	A	81.5%	88.3%	86.7%	85.7%	83.9%	78.8%	86.3%	94.4%	85.7%	86.7%	83.9%	85.7%	.0%	88.2%	80.6%	77.6%	80.5%	88.4%	83.7%
		B	82.3%	87.2%	84.6%	85.2%	78.4%	80.9%	83.8%	85.7%	88.0%	87.9%	75.0%	84.9%	.0%	76.5%	76.9%	78.5%	82.8%	83.7%	81.5%
		C	86.7%	60.0%	100.0%	88.2%	83.3%	88.9%	83.3%	66.7%	50.0%	100.0%	.0%	88.2%	.0%	100.0%	66.7%	89.7%	93.3%	88.0%	60.0%
		D	100.0%	100.0%	.0%	100.0%	.0%	100.0%	100.0%	100.0%	.0%	.0%	.0%	100.0%	.0%	.0%	.0%	100.0%	100.0%	100.0%	.0%
	CENTRE-FIELDWORK CENTRES	Ahmedabad	77.2%	100.0%	87.5%	77.8%	88.9%	68.9%	88.2%	100.0%	100.0%	100.0%	66.7%	77.8%	.0%	100.0%	100.0%	60.0%	80.0%	90.5%	90.0%
		Surat	56.0%	50.0%	42.9%	50.0%	33.3%	62.3%	45.2%	50.0%	60.0%	50.0%	33.3%	50.0%	.0%	50.0%	.0%	56.0%	64.0%	50.0%	40.0%
		Vadodara	78.2%	60.0%	66.7%	100.0%	100.0%	76.5%	81.0%	50.0%	66.7%	60.0%	100.0%	100.0%	.0%	100.0%	100.0%	58.8%	93.8%	80.0%	83.3%
		Bhubaneshwar	90.9%	100.0%	66.7%	100.0%	100.0%	90.0%	92.3%	100.0%	100.0%	50.0%	100.0%	100.0%	.0%	100.0%	100.0%	85.0%	94.7%	86.7%	100.0%
		Bangalore	90.2%	90.0%	100.0%	77.8%	54.5%	100.0%	79.5%	87.5%	100.0%	100.0%	100.0%	77.8%	.0%	50.0%	60.0%	100.0%	100.0%	78.6%	80.0%
		Chennai	97.5%	100.0%	100.0%	100.0%	100.0%	95.2%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	93.3%	96.7%	100.0%	100.0%
		Coimbatore	78.3%	100.0%	100.0%	100.0%	75.0%	71.0%	93.3%	100.0%	.0%	100.0%	100.0%	100.0%	.0%	100.0%	50.0%	66.7%	73.3%	100.0%	75.0%
		Delhi	76.9%	94.1%	87.5%	81.8%	76.5%	70.9%	85.2%	100.0%	88.9%	90.9%	75.0%	80.0%	.0%	77.8%	100.0%	78.9%	61.8%	86.1%	87.5%
		Jodhpur	71.8%	33.3%	66.7%	100.0%	66.7%	72.0%	71.4%	.0%	50.0%	100.0%	50.0%	100.0%	.0%	.0%	100.0%	53.8%	90.0%	75.0%	66.7%
		Guwahati	80.0%	100.0%	66.7%	80.0%	75.0%	80.0%	80.0%	100.0%	100.0%	100.0%	.0%	80.0%	.0%	100.0%	50.0%	77.8%	80.8%	90.0%	60.0%
		Hyderabad	94.6%	100.0%	100.0%	100.0%	100.0%	90.5%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	90.9%	85.7%	100.0%	100.0%
		Vijayawada	82.1%	.0%	100.0%	100.0%	.0%	75.0%	100.0%	.0%	.0%	100.0%	.0%	100.0%	.0%	.0%	.0%	63.6%	87.5%	100.0%	.0%
		Indore	62.7%	60.0%	25.0%	80.0%	75.0%	63.6%	61.1%	100.0%	66.7%	.0%	.0%	80.0%	.0%	50.0%	100.0%	68.8%	57.1%	60.0%	60.0%
		Cochin	73.4%	60.0%	100.0%	100.0%	60.0%	71.1%	78.9%	100.0%	33.3%	100.0%	100.0%	100.0%	.0%	33.3%	100.0%	65.0%	76.2%	83.3%	71.4%
		Kolkata	92.9%	100.0%	93.3%	100.0%	93.3%	90.1%	96.4%	100.0%	100.0%	91.7%	100.0%	100.0%	.0%	90.0%	100.0%	92.7%	86.7%	95.2%	100.0%
		Chandigarh	87.3%	40.0%	100.0%	40.0%	75.0%	100.0%	63.2%	50.0%	50.0%	100.0%	100.0%	40.0%	.0%	100.0%	50.0%	100.0%	100.0%	63.6%	66.7%
		Ludhiana	89.1%	100.0%	100.0%	100.0%	60.0%	88.9%	89.5%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	50.0%	50.0%	94.1%	81.3%	90.0%	85.7%
		Mumbai	89.6%	88.2%	100.0%	90.9%	100.0%	85.3%	94.7%	91.7%	80.0%	100.0%	100.0%	90.9%	.0%	100.0%	.0%	84.1%	85.0%	95.8%	87.5%
		Patna	82.6%	.0%	100.0%	80.0%	.0%	81.3%	85.7%	.0%	.0%	100.0%	.0%	80.0%	.0%	.0%	.0%	66.7%	100.0%	85.7%	.0%
		Ranchi	100.0%	.0%	.0%	100.0%	.0%	100.0%	100.0%	.0%	.0%	.0%	.0%	100.0%	.0%	.0%	.0%	100.0%	100.0%	100.0%	.0%
		Pune	92.3%	100.0%	100.0%	77.8%	100.0%	90.5%	94.4%	100.0%	100.0%	100.0%	100.0%	77.8%	.0%	100.0%	100.0%	84.2%	100.0%	92.6%	100.0%
		Nagpur	51.4%	100.0%	33.3%	66.7%	50.0%	44.4%	64.0%	100.0%	100.0%	50.0%	.0%	66.7%	.0%	66.7%	33.3%	40.0%	50.0%	68.8%	55.6%
You and another member of the family are jointly involved in	Count		Total	275	20	21	21	27	186	89	7	10	12	9	21	0	14	10	106	68	54	29
		GRIDA-Channel of Purchase	Agent	160	7	12	21	14	106	54	7	0	12	0	21	0	14	0	106	0	54	0
			Bank	97	10	9	0	10	68	29	0	10	0	9	0	0	0	10	0	68	0	29
			CS / CA	7	0	0	0	1	6	1	0	0	0	0	0	0	0	0	0	0	0	0
			Broker	11	3	0	0	2	6	5	0	0	0	0	0	0	0	0	0	0	0	0
		GRIDB-Policy Type	ULIP	143	11	10	1	7	114	29	1	7	8	2	1	0	3	2	66	41	13	11
			Traditional	132	9	11	20	20	72	60	6	3	4	7	20	0	11	8	40	27	41	18
		GRIDC-Type of customer	New customer	52	1	1	1	2	47	5	1	0	1	0	1	0	1	1	26	18	4	1
			Old customer	223	19	20	20	25	139	84	6	10	11	9	20	0	13	9	80	50	50	28
		GRIDD-Amount of Premium	Up to Rs. 25,000	120	14	11	17	18	60	60	4	8	5	6	17	0	11	6	35	18	37	20
			Rs. 25,000 to Rs. 50.000	90	5	10	3	8	64	26	3	2	7	3	3	0	3	3	36	24	16	8
			More than Rs. 50,000	65	1	0	1	1	62	3	0	0	0	0	1	0	0	1	35	26	1	1
		R_Q5-Could you please tell me your age?	25-30 years	60	9	7	14	12	18	42	2	5	3	4	14	0	7	5	15	3	26	14
			31-35 years	71	6	11	4	6	44	27	4	1	7	4	4	0	1	2	24	15	16	7
			36-40 years	61	3	0	2	7	49	12	1	2	0	0	2	0	5	2	27	19	8	4
			41-45 years	41	1	1	0	1	38	3	0	1	0	1	0	0	0	1	24	13	0	3
			45-50 years	42	1	2	1	1	37	5	0	1	2	0	1	0	1	0	16	18	4	1
		Town class	Metro	59	3	3	3	5	45	14	1	2	2	1	3	0	3	0	21	19	9	3
			Tier1	107	6	9	12	13	67	40	3	2	4	5	12	0	6	6	40	22	25	13
			Tier2	109	11	9	6	9	74	35	3	6	6	3	6	0	5	4	45	27	20	13
		zone	North	58	6	3	5	8	36	22	2	3	1	2	5	0	4	2	15	17	12	7
			West	139	11	14	12	9	93	46	4	5	8	6	12	0	4	4	56	31	28	15
			East	31	0	4	2	2	23	8	0	0	3	1	2	0	1	1	14	8	6	2
			South	47	3	0	2	8	34	13	1	2	0	0	2	0	5	3	21	12	8	5
		SEC	A	190	12	13	11	15	139	51	3	6	8	5	11	0	6	6	77	52	28	17
			B	75	6	8	8	11	42	33	3	3	4	4	8	0	8	3	26	15	23	10
			C	10	2	0	2	1	5	5	1	1	0	0	2	0	0	1	3	1	3	2
			D	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
		CENTRE-FIELDWORK CENTRES	Ahmedabad	18	0	1	2	1	14	4	0	0	0	1	2	0	0	0	8	4	2	1
			Surat	37	5	4	4	4	20	17	2	2	2	2	4	0	2	2	11	9	10	6
			Vadodara	12	2	2	0	0	8	4	1	1	2	0	0	0	0	0	7	1	3	1
			Bhubaneshwar	6	0	2	0	0	4	2	0	0	2	0	0	0	0	0	3	1	2	0
			Bangalore	8	1	0	2	5	0	8	1	0	0	0	2	0	3	2	0	0	6	2
			Chennai	3	0	0	0	0	3	0	0	0	0	0	0	0	0	0	2	1	0	0
			Coimbatore	10	0	0	0	1	9	1	0	0	0	0	0	0	0	1	5	4	0	1
			Delhi	34	1	2	2	4	25	9	0	1	1	1	2	0	2	0	8	13	5	2
			Jodhpur	11	2	1	0	1	7	4	1	1	0	1	0	0	1	0	6	1	2	2
			Guwahati	12	0	1	1	1	9	3	0	0	0	1	1	0	0	1	4	5	1	2
			Hyderabad	4	0	0	0	0	4	0	0	0	0	0	0	0	0	0	3	1	0	0
			Vijayawada	5	0	0	0	0	5	0	0	0	0	0	0	0	0	0	4	1	0	0
			Indore	19	2	3	1	1	12	7	0	1	2	1	1	0	1	0	5	6	4	2
			Cochin	17	2	0	0	2	13	4	0	2	0	0	0	0	2	0	7	5	2	2
			Kolkata	9	0	1	0	1	7	2	0	0	1	0	0	0	1	0	4	2	2	0
			Chandigarh	7	3	0	3	1	0	7	1	1	0	0	3	0	0	1	0	0	4	2
			Ludhiana	6	0	0	0	2	4	2	0	0	0	0	0	0	1	1	1	3	1	1
			Mumbai	13	2	0	1	0	10	3	1	1	0	0	1	0	0	0	7	3	2	1
			Patna	4	0	0	1	0	3	1	0	0	0	0	1	0	0	0	3	0	1	0
			Ranchi	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
			Pune	6	0	0	2	0	4	2	0	0	0	0	2	0	0	0	3	0	2	0
			Nagpur	34	0	4	2	3	25	9	0	0	2	2	2	0	1	2	15	8	5	4
	Column N %		Total	17.9%	12.8%	13.8%	13.7%	18.0%	20.1%	14.6%	8.9%	14.5%	12.6%	19.1%	13.8%	.0%	15.9%	21.3%	21.4%	18.3%	13.0%	17.8%
		GRIDA-Channel of Purchase	Agent	17.6%	8.9%	12.6%	13.8%	15.9%	21.4%	13.0%	8.9%	.0%	12.6%	.0%	13.8%	.0%	15.9%	.0%	21.4%	.0%	13.0%	.0%
			Bank	18.1%	14.5%	19.1%	.0%	21.3%	18.3%	17.8%	.0%	14.5%	.0%	19.1%	.0%	.0%	.0%	21.3%	.0%	18.3%	.0%	17.8%
			CS / CA	19.4%	.0%	.0%	.0%	14.3%	27.3%	7.1%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%
			Broker	19.0%	60.0%	.0%	.0%	25.0%	15.8%	25.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%
		GRIDB-Policy Type	ULIP	20.3%	14.5%	11.2%	25.0%	23.3%	22.6%	14.6%	2.9%	20.0%	12.9%	9.1%	25.0%	.0%	17.6%	22.2%	26.0%	18.7%	11.0%	16.7%
			Traditional	15.8%	11.3%	17.5%	13.4%	16.7%	17.0%	14.6%	13.6%	8.8%	12.1%	28.0%	13.5%	.0%	15.5%	21.1%	16.6%	17.6%	13.9%	18.6%
		GRIDC-Type of customer	New customer	16.5%	8.3%	12.5%	11.1%	14.3%	17.3%	11.6%	12.5%	.0%	16.7%	.0%	11.1%	.0%	20.0%	14.3%	17.4%	16.1%	14.3%	7.7%
			Old customer	18.2%	13.2%	13.9%	13.9%	18.4%	21.2%	14.8%	8.5%	15.4%	12.4%	20.0%	14.0%	.0%	15.7%	22.5%	23.1%	19.2%	13.0%	18.7%
		GRIDD-Amount of Premium	Up to Rs. 25,000	14.5%	11.5%	10.3%	13.0%	15.8%	17.1%	12.7%	6.8%	14.0%	7.6%	18.2%	13.1%	.0%	16.7%	16.2%	18.2%	12.9%	11.5%	15.7%
			Rs. 25,000 to Rs. 50.000	23.0%	21.7%	29.4%	16.7%	25.8%	22.4%	24.5%	23.1%	22.2%	30.4%	33.3%	16.7%	.0%	15.0%	37.5%	22.8%	24.0%	21.6%	30.8%
			More than Rs. 50,000	20.2%	9.1%	.0%	25.0%	20.0%	21.4%	9.7%	.0%	.0%	.0%	.0%	25.0%	.0%	.0%	50.0%	24.1%	19.5%	5.3%	10.0%
		R_Q5-Could you please tell me your age?	25-30 years	19.0%	13.8%	14.9%	24.6%	22.6%	19.4%	18.9%	5.6%	19.2%	10.3%	26.7%	24.6%	.0%	22.6%	29.4%	24.6%	9.4%	17.0%	24.1%
			31-35 years	21.6%	17.6%	28.9%	12.1%	18.2%	23.0%	19.6%	25.0%	6.7%	28.0%	36.4%	12.1%	.0%	6.7%	16.7%	23.8%	20.5%	18.0%	18.4%
36-40 years			19.2%	11.1%	.0%	10.5%	29.2%	23.0%	11.5%	7.7%	15.4%	.0%	.0%	11.1%	.0%	29.4%	33.3%	21.8%	26.8%	11.4%	14.8%
41-45 years			14.5%	5.3%	6.7%	.0%	4.8%	18.4%	3.9%	.0%	10.0%	.0%	12.5%	.0%	.0%	.0%	16.7%	23.5%	14.0%	.0%	12.5%
45-50 years			14.2%	9.1%	11.1%	4.3%	5.3%	16.5%	7.0%	.0%	20.0%	15.4%	.0%	4.3%	.0%	8.3%	.0%	15.0%	17.5%	7.4%	6.3%
Town class		Metro	11.4%	4.8%	4.8%	7.0%	8.5%	15.6%	6.1%	3.0%	7.4%	4.4%	6.7%	7.1%	.0%	7.9%	.0%	12.6%	19.2%	5.7%	5.6%
		Tier1	22.9%	11.3%	20.5%	24.0%	26.0%	24.8%	20.3%	10.0%	10.0%	16.7%	31.3%	24.0%	.0%	20.0%	35.3%	26.1%	22.4%	18.7%	24.5%
		Tier2	19.6%	27.5%	20.0%	10.0%	22.0%	20.1%	18.8%	18.8%	27.3%	23.1%	18.8%	10.0%	.0%	25.0%	22.2%	25.7%	15.4%	16.4%	23.2%
zone		North	19.6%	20.7%	10.3%	19.2%	27.6%	19.7%	19.5%	18.2%	20.0%	6.7%	18.2%	20.0%	.0%	28.6%	22.2%	17.9%	21.8%	18.5%	20.0%
		West	25.6%	17.7%	25.9%	22.6%	17.0%	29.1%	20.7%	12.5%	18.5%	22.9%	37.5%	22.6%	.0%	10.8%	30.8%	33.7%	24.0%	17.8%	26.8%
		East	10.8%	.0%	15.4%	6.5%	7.7%	12.8%	7.4%	.0%	.0%	15.0%	16.7%	6.5%	.0%	6.7%	11.1%	13.3%	11.1%	7.6%	7.4%
		South	11.4%	7.5%	.0%	4.7%	19.0%	13.9%	7.7%	4.3%	13.3%	.0%	.0%	4.7%	.0%	22.7%	18.8%	15.0%	12.9%	7.1%	11.1%
SEC		A	18.5%	11.7%	13.3%	14.3%	16.1%	21.2%	13.7%	5.6%	14.3%	13.3%	16.1%	14.3%	.0%	11.8%	19.4%	22.4%	19.5%	11.6%	16.3%
		B	17.7%	12.8%	15.4%	14.8%	21.6%	19.1%	16.2%	14.3%	12.0%	12.1%	25.0%	15.1%	.0%	23.5%	23.1%	21.5%	17.2%	16.3%	18.5%
		C	13.3%	40.0%	.0%	11.8%	16.7%	11.1%	16.7%	33.3%	50.0%	.0%	.0%	11.8%	.0%	.0%	33.3%	10.3%	6.7%	12.0%	40.0%
		D	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%
CENTRE-FIELDWORK CENTRES		Ahmedabad	22.8%	.0%	12.5%	22.2%	11.1%	31.1%	11.8%	.0%	.0%	.0%	33.3%	22.2%	.0%	.0%	.0%	40.0%	20.0%	9.5%	10.0%
		Surat	44.0%	50.0%	57.1%	50.0%	66.7%	37.7%	54.8%	50.0%	40.0%	50.0%	66.7%	50.0%	.0%	50.0%	100.0%	44.0%	36.0%	50.0%	60.0%
		Vadodara	21.8%	40.0%	33.3%	.0%	.0%	23.5%	19.0%	50.0%	33.3%	40.0%	.0%	.0%	.0%	.0%	.0%	41.2%	6.3%	20.0%	16.7%
		Bhubaneshwar	9.1%	.0%	33.3%	.0%	.0%	10.0%	7.7%	.0%	.0%	50.0%	.0%	.0%	.0%	.0%	.0%	15.0%	5.3%	13.3%	.0%
		Bangalore	9.8%	10.0%	.0%	22.2%	45.5%	.0%	20.5%	12.5%	.0%	.0%	.0%	22.2%	.0%	50.0%	40.0%	.0%	.0%	21.4%	20.0%
		Chennai	2.5%	.0%	.0%	.0%	.0%	4.8%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	6.7%	3.3%	.0%	.0%
		Coimbatore	21.7%	.0%	.0%	.0%	25.0%	29.0%	6.7%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	50.0%	33.3%	26.7%	.0%	25.0%
		Delhi	23.1%	5.9%	12.5%	18.2%	23.5%	29.1%	14.8%	.0%	11.1%	9.1%	25.0%	20.0%	.0%	22.2%	.0%	21.1%	38.2%	13.9%	12.5%
		Jodhpur	28.2%	66.7%	33.3%	.0%	33.3%	28.0%	28.6%	100.0%	50.0%	.0%	50.0%	.0%	.0%	100.0%	.0%	46.2%	10.0%	25.0%	33.3%
		Guwahati	20.0%	.0%	33.3%	20.0%	25.0%	20.0%	20.0%	.0%	.0%	.0%	100.0%	20.0%	.0%	.0%	50.0%	22.2%	19.2%	10.0%	40.0%
		Hyderabad	5.4%	.0%	.0%	.0%	.0%	9.5%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	9.1%	14.3%	.0%	.0%
		Vijayawada	17.9%	.0%	.0%	.0%	.0%	25.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	36.4%	12.5%	.0%	.0%
		Indore	37.3%	40.0%	75.0%	20.0%	25.0%	36.4%	38.9%	.0%	33.3%	100.0%	100.0%	20.0%	.0%	50.0%	.0%	31.3%	42.9%	40.0%	40.0%
		Cochin	26.6%	40.0%	.0%	.0%	40.0%	28.9%	21.1%	.0%	66.7%	.0%	.0%	.0%	.0%	66.7%	.0%	35.0%	23.8%	16.7%	28.6%
		Kolkata	7.1%	.0%	6.7%	.0%	6.7%	9.9%	3.6%	.0%	.0%	8.3%	.0%	.0%	.0%	10.0%	.0%	7.3%	13.3%	4.8%	.0%
		Chandigarh	12.7%	60.0%	.0%	60.0%	25.0%	.0%	36.8%	50.0%	50.0%	.0%	.0%	60.0%	.0%	.0%	50.0%	.0%	.0%	36.4%	33.3%
		Ludhiana	10.9%	.0%	.0%	.0%	40.0%	11.1%	10.5%	.0%	.0%	.0%	.0%	.0%	.0%	50.0%	50.0%	5.9%	18.8%	10.0%	14.3%
		Mumbai	10.4%	11.8%	.0%	9.1%	.0%	14.7%	5.3%	8.3%	20.0%	.0%	.0%	9.1%	.0%	.0%	.0%	15.9%	15.0%	4.2%	12.5%
		Patna	17.4%	.0%	.0%	20.0%	.0%	18.8%	14.3%	.0%	.0%	.0%	.0%	20.0%	.0%	.0%	.0%	33.3%	.0%	14.3%	.0%
		Ranchi	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%	.0%
		Pune	7.7%	.0%	.0%	22.2%	.0%	9.5%	5.6%	.0%	.0%	.0%	.0%	22.2%	.0%	.0%	.0%	15.8%	.0%	7.4%	.0%
		Nagpur	48.6%	.0%	66.7%	33.3%	50.0%	55.6%	36.0%	.0%	.0%	50.0%	100.0%	33.3%	.0%	33.3%	66.7%	60.0%	50.0%	31.3%	44.4%
Job Number :                Project -            Segment -   1            10/9/2014

 

 

Actual Output

 

Market  Total
Base : All Total				GRIDA-Channel of Purchase				GRIDB-Policy Type		GRIDC-Type of customer		GRIDD-Amount of Premium			R_Q5-Could you please tell me your age?					Town class			zone				SEC				CENTRE-FIELDWORK CENTRES
			Total	Agent	Bank	CS / CA	Broker	ULIP	Traditional	New customer	Old customer	Up to Rs. 25,000	Rs. 25,000 to Rs. 50.000	More than Rs. 50,000	25-30 years	31-35 years	36-40 years	41-45 years	45-50 years	Metro	Tier1	Tier2	North	West	East	South	A	B	C	D	Ahmedabad	Surat	Vadodara	Bhubaneshwar	Bangalore	Chennai	Coimbatore	Delhi	Jodhpur	Guwahati	Hyderabad	Vijayawada	Indore	Cochin	Kolkata	Chandigarh	Ludhiana	Mumbai	Patna	Ranchi	Pune	Nagpur
	Total	Count	1538	909	535	36	58	703	835	315	1223	825	392	321	315	329	317	282	295	516	467	555	296	542	288	412	1027	424	75	12	79	84	55	66	82	118	46	147	39	60	74	28	51	64	126	55	55	125	23	13	78	70
		Column N %	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%
R_Q4-How involved are you with various aspects of the life insurance policy/policies that you have, in terms of the purchase process, managing the regular transactions with the insurance company, etc. ?	Answering Base	Count	1538	909	535	36	58	703	835	315	1223	825	392	321	315	329	317	282	295	516	467	555	296	542	288	412	1027	424	75	12	79	84	55	66	82	118	46	147	39	60	74	28	51	64	126	55	55	125	23	13	78	70
	You are completely involved with all aspects of the life ins	Count	1263	749	438	29	47	560	703	263	1000	705	302	256	255	258	256	241	253	457	360	446	238	403	257	365	837	349	65	12	61	47	43	60	74	115	36	113	28	48	70	23	32	47	117	48	49	112	19	13	72	36
		Column N %	82.1%	82.4%	81.9%	80.6%	81.0%	79.7%	84.2%	83.5%	81.8%	85.5%	77.0%	79.8%	81.0%	78.4%	80.8%	85.5%	85.8%	88.6%	77.1%	80.4%	80.4%	74.4%	89.2%	88.6%	81.5%	82.3%	86.7%	100.0%	77.2%	56.0%	78.2%	90.9%	90.2%	97.5%	78.3%	76.9%	71.8%	80.0%	94.6%	82.1%	62.7%	73.4%	92.9%	87.3%	89.1%	89.6%	82.6%	100.0%	92.3%	51.4%
	You and another member of the family are jointly involved in	Count	275	160	97	7	11	143	132	52	223	120	90	65	60	71	61	41	42	59	107	109	58	139	31	47	190	75	10	0	18	37	12	6	8	3	10	34	11	12	4	5	19	17	9	7	6	13	4	0	6	34
		Column N %	17.9%	17.6%	18.1%	19.4%	19.0%	20.3%	15.8%	16.5%	18.2%	14.5%	23.0%	20.2%	19.0%	21.6%	19.2%	14.5%	14.2%	11.4%	22.9%	19.6%	19.6%	25.6%	10.8%	11.4%	18.5%	17.7%	13.3%	.0%	22.8%	44.0%	21.8%	9.1%	9.8%	2.5%	21.7%	23.1%	28.2%	20.0%	5.4%	17.9%	37.3%	26.6%	7.1%	12.7%	10.9%	10.4%	17.4%	.0%	7.7%	48.6%
Job Number :                Project -            Segment -   1            10/9/2014
R_Q4-How involved are you with various aspects of the life insurance policy/policies that you have.
BRAND-BRAND FOR WHICH RECRUITED HDFC Life  / HDFC Standard Life
Base : All Total				GRIDA-Channel of Purchase				GRIDB-Policy Type		GRIDC-Type of customer		GRIDD-Amount of Premium			R_Q5-Could you please tell me your age?					Town class			zone				SEC				CENTRE-FIELDWORK CENTRES
			Total	Agent	Bank	CS / CA	Broker	ULIP	Traditional	New customer	Old customer	Up to Rs. 25,000	Rs. 25,000 to Rs. 50.000	More than Rs. 50,000	25-30 years	31-35 years	36-40 years	41-45 years	45-50 years	Metro	Tier1	Tier2	North	West	East	South	A	B	C	D	Ahmedabad	Surat	Vadodara	Bhubaneshwar	Bangalore	Chennai	Coimbatore	Delhi	Jodhpur	Guwahati	Hyderabad	Vijayawada	Indore	Cochin	Kolkata	Chandigarh	Ludhiana	Mumbai	Patna	Ranchi	Pune	Nagpur
	Total	Count	156	79	69	3	5	76	80	12	144	122	23	11	65	34	27	19	11	63	53	40	29	62	25	40	103	47	5	1	8	10	5	8	10	15	2	17	3	3	8	0	5	5	14	5	4	17	0	0	10	7
		Column N %	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	.0%	.0%	100.0%	100.0%
R_Q4-How involved are you with various aspects of the life insurance policy/policies that you have, in terms of the purchase process, managing the regular transactions with the insurance company, etc. ?	Answering Base	Count	156	79	69	3	5	76	80	12	144	122	23	11	65	34	27	19	11	63	53	40	29	62	25	40	103	47	5	1	8	10	5	8	10	15	2	17	3	3	8	0	5	5	14	5	4	17	0	0	10	7
	You are completely involved with all aspects of the life ins	Count	136	72	59	3	2	65	71	11	125	108	18	10	56	28	24	18	10	60	47	29	23	51	25	37	91	41	3	1	8	5	3	8	9	15	2	16	1	3	8	0	3	3	14	2	4	15	0	0	10	7
		Column N %	87.2%	91.1%	85.5%	100.0%	40.0%	85.5%	88.8%	91.7%	86.8%	88.5%	78.3%	90.9%	86.2%	82.4%	88.9%	94.7%	90.9%	95.2%	88.7%	72.5%	79.3%	82.3%	100.0%	92.5%	88.3%	87.2%	60.0%	100.0%	100.0%	50.0%	60.0%	100.0%	90.0%	100.0%	100.0%	94.1%	33.3%	100.0%	100.0%	.0%	60.0%	60.0%	100.0%	40.0%	100.0%	88.2%	.0%	.0%	100.0%	100.0%
	You and another member of the family are jointly involved in	Count	20	7	10	0	3	11	9	1	19	14	5	1	9	6	3	1	1	3	6	11	6	11	0	3	12	6	2	0	0	5	2	0	1	0	0	1	2	0	0	0	2	2	0	3	0	2	0	0	0	0
		Column N %	12.8%	8.9%	14.5%	.0%	60.0%	14.5%	11.3%	8.3%	13.2%	11.5%	21.7%	9.1%	13.8%	17.6%	11.1%	5.3%	9.1%	4.8%	11.3%	27.5%	20.7%	17.7%	.0%	7.5%	11.7%	12.8%	40.0%	.0%	.0%	50.0%	40.0%	.0%	10.0%	.0%	.0%	5.9%	66.7%	.0%	.0%	.0%	40.0%	40.0%	.0%	60.0%	.0%	11.8%	.0%	.0%	.0%	.0%
Job Number :                Project -            Segment -   1            10/9/2014

 

 

 

 

Thanks & Regards

Manoj

 

http://www.imrbint.com/disclaimer.html ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD