Simple ICC Question

[Moniyka Sachar]

Hi all: I am running an ICC on my dataset of 2 raters and 149 targets, where the 2 raters are rating the netscore of products based on online reviews (using an established training method and algorithm). I have attached my dataset longitudinally arranged, along with the output from Stata when I tried to run the command. I need to switch the raters and targets: Stata is incorrectly interpreting this as 149 raters and 2 targets. I've tried switching the columns and switching the order of the variables in the command. Does anyone have any advice? It seems like a simple problem with a certain answer! Thank you all for your contemplation!

netscore is the rating given by the 2 raters
productnumber is the common identifier for the 149 products
var is whether the netscore was given by rater 1 or rater 2

netscore	productnumber	var
8	1	1
0	2	1
0	3	1
2	4	1
5	5	1
3	6	1
3	7	1
-1	8	1
2	9	1
0	10	1
3	11	1
0	12	1
-6	13	1
7	14	1
10	15	1
1	16	1
4	17	1
2	18	1
-3	19	1
2	20	1
2	21	1
5	22	1
-3	23	1
1	24	1
0	25	1
3	26	1
1	27	1
1	28	1
0	29	1
0	30	1
1	31	1
4	32	1
1	33	1
0	34	1
1	35	1
0	36	1
-2	37	1
5	38	1
0	39	1
0	40	1
5	41	1
0	42	1
0	43	1
-1	44	1
-3	45	1
1	46	1
6	47	1
1	48	1
5	49	1
2	50	1
0	51	1
5	52	1
4	53	1
-1	54	1
0	55	1
-2	56	1
3	57	1
1	58	1
-1	59	1
-3	60	1
8	61	1
5	62	1
1	63	1
2	64	1
2	65	1
-1	66	1
-2	67	1
0	68	1
1	69	1
4	70	1
2	71	1
5	72	1
1	73	1
-2	74	1
3	75	1
0	76	1
1	77	1
-3	78	1
3	79	1
-2	80	1
0	81	1
1	82	1
3	83	1
0	84	1
2	85	1
-1	86	1
0	87	1
1	88	1
-2	89	1
0	90	1
1	91	1
-1	92	1
1	93	1
-2	94	1
0	95	1
1	96	1
3	97	1
-2	98	1
-2	99	1
7	100	1
0	101	1
2	102	1
2	103	1
3	104	1
1	105	1
0	106	1
0	107	1
-1	108	1
0	109	1
-1	110	1
-3	111	1
0	112	1
0	113	1
2	114	1
-1	115	1
0	116	1
-1	117	1
1	118	1
2	119	1
2	120	1
2	121	1
2	122	1
-1	123	1
4	124	1
3	125	1
3	126	1
8	17	1
2	128	1
3	129	1
0	130	1
-2	131	1
-1	132	1
2	133	1
5	134	1
1	135	1
1	136	1
1	137	1
-2	138	1
1	139	1
2	140	1
2	141	1
3	142	1
-1	143	1
0	144	1
-1	145	1
2	146	1
1	147	1
0	148	1
-5	149	1
8	1	2
0	2	2
0	3	2
2	4	2
6	5	2
3	6	2
3	7	2
-1	8	2
0	9	2
0	10	2
3	11	2
0	12	2
-6	13	2
7	14	2
11	15	2
1	16	2
4	17	2
2	18	2
-4	19	2
2	20	2
2	21	2
5	22	2
-3	23	2
1	24	2
0	25	2
3	26	2
1	27	2
1	28	2
0	29	2
0	30	2
1	31	2
4	32	2
1	33	2
0	34	2
1	35	2
0	36	2
-2	37	2
4	38	2
0	39	2
0	40	2
5	41	2
0	42	2
0	43	2
-1	44	2
-3	45	2
2	46	2
6	47	2
1	48	2
5	49	2
2	50	2
0	51	2
5	52	2
4	53	2
-1	54	2
0	55	2
-2	56	2
3	57	2
1	58	2
-1	59	2
-3	60	2
8	61	2
5	62	2
1	63	2
2	64	2
2	65	2
-1	66	2
-2	67	2
0	68	2
1	69	2
4	70	2
2	71	2
5	72	2
1	73	2
-2	74	2
3	75	2
0	76	2
1	77	2
-3	78	2
3	79	2
-2	80	2
0	81	2
1	82	2
3	83	2
-1	84	2
2	85	2
-1	86	2
0	87	2
1	88	2
-2	89	2
0	90	2
1	91	2
-1	92	2
1	93	2
-2	94	2
0	95	2
1	96	2
3	97	2
-2	98	2
-2	99	2
7	100	2
0	101	2
2	102	2
2	103	2
3	104	2
1	105	2
0	106	2
0	107	2
-1	108	2
0	109	2
0	110	2
-3	111	2
0	112	2
0	113	2
2	114	2
-1	115	2
0	116	2
-1	117	2
1	118	2
2	119	2
2	120	2
2	121	2
2	122	2
-1	123	2
4	124	2
3	125	2
3	126	2
8	17	2
2	128	2
3	129	2
0	130	2
-2	131	2
-1	132	2
2	133	2
5	134	2
1	135	2
0	136	2
2	137	2
-2	138	2
1	139	2
2	140	2
2	141	2
2	142	2
-1	143	2
-1	144	2
-1	145	2
2	146	2
1	147	2
0	148	2
-5	149	2

[daniel klein]

You have typos in your dataset. productnumber 17 occurs 4 times; twice it should be 127 ...

Best
Daniel