By Category

The Analysis Page allows to group results by country and, in addition, by any number of categorical variables from the Variables box. In the results window, each grouping will have a separate header that specifies a unique combination of by-variable values. For example, the header Combination(sector,size)=='Manufacturing*Large' denotes the subset of large manufacturing companies.

Procedure

To group results by country simply check in the Country box. To add another by-variable select a categorical variable in the Variables box and click on the

button. The variable will appear in the By Category box. If you wish to have additional levels of aggregation, select and place in the Variables box other categorical variables from the Variables box.

To use in analysis the records of only one such a subset, select a header of a subset and right-click on your selection. Choose "Copy" from the pop-up menu. Your selection will be copied to the clipboard. Then, right-click in the Select records box and choose "Paste" from the pop-up menu. The selected header will appear in the Select records box and will serve as the logical expression specifying a subset of observations to be used.

Example

If the Country box is checked and you add the variables sector and size in the By Category box your results will be grouped by sector and size within each country, as shown in the sample output below.

Bangladesh2002core

Variable	nObs	Mean	Std Err	Median	nearMin	nearMax	Label
*Combination(sector,size)=='ManufacturingLarge'**
c203b	235	1.2563	9.676	0	0	0	Percentage of firm owned by foreign private sector
*Combination(sector,size)=='ManufacturingMedium'**
c203b	125	0.416	4.651	0	0	0	Percentage of firm owned by foreign private sector
*Combination(sector,size)=='ManufacturingMicro'**
c203b	25	0	0	0	0	0	Percentage of firm owned by foreign private sector
*Combination(sector,size)=='ManufacturingSmall'**
c203b	193	2.2798	14.5411	0	0	0	Percentage of firm owned by foreign private sector
*Combination(sector,size)=='ManufacturingVery large'**
c203b	390	2.9883	14.4653	0	0	70	Percentage of firm owned by foreign private sector

China2002core

Variable	nObs	Mean	Std Err	Median	nearMin	nearMax	Label
*Combination(sector,size)=='ManufacturingLarge'**
c203b	154	27.4351	36.4229	0	0	100	Percentage of firm owned by foreign private sector
*Combination(sector,size)=='ManufacturingMedium'**
c203b	134	25.1493	37.6666	0	0	100	Percentage of firm owned by foreign private sector
*Combination(sector,size)=='ManufacturingMicro'**
c203b	17	42.8824	48.8875	0	0	99	Percentage of firm owned by foreign private sector
*Combination(sector,size)=='ManufacturingSmall'**
c203b	124	21.0403	33.1291	0	0	100	Percentage of firm owned by foreign private sector
*Combination(sector,size)=='ManufacturingVery large'**
c203b	294	34.0442	40.1733	0	0	100	Percentage of firm owned by foreign private sector
*Combination(sector,size)=='ServicesLarge'**
c203b	49	14.7959	30.8356	0	0	50	Percentage of firm owned by foreign private sector
*Combination(sector,size)=='ServicesMedium'**
c203b	77	18.7792	32.3743	0	0	99	Percentage of firm owned by foreign private sector
*Combination(sector,size)=='ServicesMicro'**
c203b	31	14.1935	29.3001	0	0	40	Percentage of firm owned by foreign private sector
*Combination(sector,size)=='ServicesSmall'**
c203b	127	13.811	31.8645	0	0	100	Percentage of firm owned by foreign private sector
*Combination(sector,size)=='ServicesVery large'**
c203b	29	12.3793	25.3862	0	0	28	Percentage of firm owned by foreign private sector

Procedure

Example

Bangladesh2002core

China2002core

Related Topics