topic Re: input statement and merging of choice design and collected data(help) in SAS Programming

input statement and merging of choice design and collected data(help)

monishwan — Wed, 05 Dec 2018 08:11:10 GMT

I am facing difficulty in merging my collected data and design that I have generated for which multinomial logit analysis has to be carried out. I want to see how the age gender education level affects their choices. I presented the respondents with 12 choice sets with 3 alternatives each. '1' indicates individual chose 1st alternative, '2' indicates individual chose 2nd alternative and '3' indicates individual chose 3rd alternative. I am using SAS Studio for this purpose. I am completely new to SAS programming. Thank you.

data results;
input subject (r1-r12). Age Gender $ Socialgrp $ Edulvl $;
datalines;					
1	111332311233	26	F	SC	GRADUATION
2	131332323233	22	M	GEN	GRADUATION
3	131332323233	19	M	GEN	GRADUATION
4	313132323232	19	M	SC	GRADUATION
5	313332323232	19	M	SC	GRADUATION
6	331332323232	25	M	SC	HIGHER SECONDARY
7	331332321332	24	M	GEN	GRADUATION
8	311332323232	28	F	SC	GRADUATION
9	331332323233	52	F	SC	PRIMARY
10	331332323233	21	F	GEN	GRADUATION
11	113232311213	24	M	GEN	GRADUATION
12	331332321233	22	M	GEN	GRADUATION
13	331332321233	19	F	SC	HIGHER SECONDARY
14	332332321232	27	M	SC	GRADUATION
15	113232311232	32	M	SC	HIGHER SECONDARY
16	111232321232	19	F	OBC	HIGHER SECONDARY
17	332332321132	37	M	OBC	GRADUATION
18	321332321232	38	M	GEN	GRADUATION
19	113212111213	45	M	OBC	GRADUATION
20	331332321233	38	M	GEN	SECONDARY
21	311332321233	27	F	GEN	HIGHER SECONDARY
22	113332321233	39	F	SC	GRADUATION
23	131332323233	42	F	GEN	GRADUATION
24	113331311232	45	M	OBC	HIGHER SECONDARY
25	113332313233	24	M	OBC	GRADUATION
26	313332321232	47	F	SC	GRADUATION
27	311332321232	47	F	GEN	GRADUATION
28	331322233233	23	F	GEN	PG
29	313332111232	25	F	GEN	GRADUATION
30	313331323232	38	F	SC	GRADUATION
31	313332321233	43	F	GEN	GRADUATION
32	331332321232	32	F	SC	GRADUATION
33	313332321232	48	M	GEN	GRADUATION
34	331332321232	27	M	OBC	PG
35	311332321232	37	M	OBC	GRADUATION
36	113212323232	44	F	ST	SECONDARY
37	113332311232	30	F	SC	GRADUATION
38	311332311323	24	F	GEN	GRADUATION
39	313332313232	45	M	OBC	GRADUATION
40	313332321233	20	F	GEN	GRADUATION
41	311332323232	47	F	GEN	SECONDARY
42	113211321232	40	F	GEN	SECONDARY
43	313332313333	39	M	GEN	HIGHER SECONDARY
44	331322321233	28	F	GEN	GRADUATION
45	113332321232	35	M	GEN	GRADUATION
46	113332311232	32	M	GEN	GRADUATION
47	321332323232	43	F	GEN	HIGHER SECONDARY
48	311332311232	36	F	OBC	HIGHER SECONDARY
49	113332321233	27	F	GEN	GRADUATION
50	113332311233	21	F	GEN	GRADUATION
51	331332321233	28	M	ST	HIGHER SECONDARY
52	331332323233	37	F	GEN	GRADUATION
53	313212213312	32	F	SC	GRADUATION
54	313332321232	39	F	GEN	HIGHER SECONDARY
55	313332323232	59	F	SC	PRIMARY
56	311332321232	27	F	SC	HIGHER SECONDARY
57	311332311322	42	F	GEN	GRADUATION
58	113331311233	48	F	SC	HIGHER SECONDARY
59	332321311232	33	F	GEN	GRADUATION
60	213331311232	28	M	GEN	GRADUATION
61	311332311322	37	M	SC	GRADUATION
62	331332321233	45	F	SC	SECONDARY
63	313332321232	22	F	GEN	GRADUATION
64	113332311232	24	F	ST	GRADUATION
65	331332321233	37	F	OBC	GRADUATION
66	111332321232	44	F	SC	SECONDARY
67	113212311213	35	F	ST	GRADUATION
68	113331311213	53	F	GEN	SECONDARY
69	113332311232	51	F	GEN	PRIMARY
70	311332321232	33	F	GEN	HIGHER SECONDARY
71	113332321232	30	M	GEN	GRADUATION
72	313332323232	42	F	OBC	SECONDARY
73	113332311232	24	F	GEN	HIGHER SECONDARY
74	313332321232	25	F	GEN	HIGHER SECONDARY
75	311332321333	26	M	GEN	GRADUATION
76	123332333232	35	F	OBC	BELOW PRIMARY
77	332323321233	43	F	SC	BELOW PRIMARY
78	122332333233	39	F	SC	BELOW PRIMARY
79	332323321233	56	F	SC	BELOW PRIMARY
80	322322331233	56	F	OBC	BELOW PRIMARY
81	222332333132	27	F	SC	SECONDARY
82	222332333233	50	F	OBC	BELOW PRIMARY
83	332323321233	44	F	SC	BELOW PRIMARY
84	122332333132	19	F	SC	SECONDARY
85	122322331233	63	M	OBC	BELOW PRIMARY
86	132321131213	24	F	SC	HIGHER SECONDARY
87	132221131213	45	F	OBC	BELOW PRIMARY
88	113322311232	45	F	SC	BELOW PRIMARY
89	222332323233	42	F	SC	BELOW PRIMARY
90	332323321233	39	F	SC	BELOW PRIMARY
91	332323321233	60	M	SC	BELOW PRIMARY
92	122332333133	NA	M	SC	BELOW PRIMARY
93	113232311213	43	F	OBC	BELOW PRIMARY
94	133321321233	42	F	SC	BELOW PRIMARY
95	332332333133	41	F	OBC	BELOW PRIMARY
96	312221233212	40	F	SC	BELOW PRIMARY
97	131222333133	40	F	SC	BELOW PRIMARY
98	333332121211	33	F	SC	PRIMARY
99	231322321211	22	M	OBC	HIGHER SECONDARY
100	123232111213	24	F	SC	DIPLOMA
101	332323323233	39	F	OBC	BELOW PRIMARY
102	132322331233	NA	M	SC	BELOW PRIMARY
103	332323231211	34	F	SC	BELOW PRIMARY
104	312321221233	36	F	SC	BELOW PRIMARY
105	122332331233	53	F	SC	BELOW PRIMARY
106	332323321233	39	F	SC	BELOW PRIMARY
107	222332333232	36	F	OBC	BELOW PRIMARY
108	322333333213	45	F	SC	BELOW PRIMARY
109	332323321233	42	F	OBC	BELOW PRIMARY
110	332323321233	47	F	OBC	BELOW PRIMARY
111	231322231213	67	M	SC	BELOW PRIMARY
112	122322331233	23	F	SC	BELOW PRIMARY
113	332323321233	55	F	SC	BELOW PRIMARY
114	312332331213	33	M	SC	DIPLOMA
115	311332231313	NA	M	SC	BELOW PRIMARY
116	311332131212	28	F	SC	SECONDARY
117	332323321233	55	F	SC	BELOW PRIMARY
118	122332331233	32	F	SC	SECONDARY
119	322323321233	30	F	SC	HIGHER SECONDARY
120	311322231213	52	F	OBC	BELOW PRIMARY
121	222331333132	33	F	SC	SECONDARY
122	122332333233	52	F	SC	BELOW PRIMARY
123	331332231312	30	F	SC	SECONDARY
124	332323331233	27	F	SC	DIPLOMA
125	331223321233	32	M	OBC	DIPLOMA
126	313322321233	33	M	OBC	PRIMARY
127	113321321233	29	M	SC	SECONDARY
128	113232121233	25	M	SC	SECONDARY
129	332323321233	21	F	SC	DIPLOMA
130	112232321213	37	M	OBC	DIPLOMA
131	332322321233	26	M	OBC	DIPLOMA
132	331222333231	66	F	OBC	BELOW PRIMARY
133	312332331211	53	M	SC	SECONDARY
134	312332331211	36	F	SC	PRIMARY
135	312332231213	41	F	SC	BELOW PRIMARY
136	133232321212	53	M	OBC	BELOW PRIMARY
137	332323321233	28	F	SC	SECONDARY
138	311332231313	41	F	OBC	PRIMARY
139	333322333233	38	M	SC	DIPLOMA
140	332322321233	25	M	SC	DIPLOMA
141	122323331233	50	F	OBC	BELOW PRIMARY
142	332322321211	26	F	SC	SECONDARY
143	312321131211	24	F	OBC	HIGHER SECONDARY
144	113212311213	40	F	SC	PRIMARY
145	112322321233	34	F	SC	BELOW PRIMARY
146	312331323212	41	F	SC	BELOW PRIMARY
147	332222321233	33	F	SC	SECONDARY
148	131212313332	46	F	SC	BELOW PRIMARY
149	312332321232	47	F	OBC	BELOW PRIMARY
150	112323321233	28	F	SC	HIGHER SECONDARY
151	331222321233	34	F	OBC	PRIMARY
152	312321131211	41	F	SC	BELOW PRIMARY
153	331212332322	34	F	SC	PRIMARY
154	113212111213	42	M	SC	HIGHER SECONDARY
155	332323221213	30	M	OBC	DIPLOMA
156	333233321331	42	F	SC	BELOW PRIMARY
157	132332331233	28	F	OBC	SECONDARY
158	332323321233	49	F	SC	BELOW PRIMARY
159	121213122332	42	F	SC	BELOW PRIMARY
160	132322321233	48	M	SC	BELOW PRIMARY
161	312321131111	23	F	SC	HIGHER SECONDARY
162	131321321223	30	F	SC	SECONDARY
163	332332231213	46	M	OBC	BELOW PRIMARY
164	332332231213	33	F	SC	SECONDARY
165	231213332332	32	F	OBC	SECONDARY
166	222332333233	29	M	OBC	DIPLOMA
167	331332331213	28	F	SC	HIGHER SECONDARY
168	122332331233	44	F	SC	BELOW PRIMARY
169	331332331232	29	F	SC	SECONDARY
170	132323321233	22	M	SC	SECONDARY
171	332321131231	27	M	SC	BELOW PRIMARY
172	132312111213	30	F	SC	SECONDARY
173	333312311212	41	F	SC	BELOW PRIMARY
174	113212111213	29	F	SC	SECONDARY
175	332323321233	22	F	SC	HIGHER SECONDARY
176	313332311222	25	F	GEN	GRADUATE
177	211232113332	29	F	GEN	GRADUATE
178	113332211222	40	F	GEN	GRADUATE
179	113331211222	22	F	GEN	GRADUATE
180	313331211232	57	F	GEN	GRADUATE
181	113331321232	26	M	GEN	GRADUATE
182	113331311222	19	M	GEN	GRADUATE
183	313331211232	26	M	GEN	PG
184	311332321232	32	F	GEN	GRADUATE
185	311332311222	28	F	GEN	PG
186	113332311232	42	F	GEN	GRADUATE
187	213311111213	27	M	GEN	GRADUATE
188	113332311232	31	F	OBC	GRADUATE
189	113232211222	33	F	OBC	GRADUATE
190	313331311222	34	F	GEN	PG
191	113332311222	27	F	OBC	GRADUATE
192	113331211222	25	F	GEN	GRADUATE
193	313331211222	28	F	GEN	PG
194	313331221222	29	M	OBC	PG
195	313331211222	54	M	OBC	PG
196	313331311222	25	F	GEN	GRADUATE
197	113331311222	45	M	GEN	GRADUATE
198	113331321232	32	M	GEN	PG
199	211232113332	40	M	GEN	GRADUATE
200	113332211222	40	F	GEN	HIGHER SECONDARY
;
%mktmerge(design=work.choicexpdes, /* input design */
data=results, /* input data set */
out=res2, /* output data set with design and data */
nsets=12, /* number of choice sets */
nalts=3, /* number of alternatives */
setvars=r1-r12); /* variables with the chosen alt nums */
proc print data=res2(obs=12);
by set subject; id set subject;
run;

Below is the code used for choice set generation.

%mktruns(3 2 2 4 3 3);
%mktex(3 2 2 4 3 3, n=432);
%mkteval(data=randomized)
proc print data=randomized; run;
options validvarname=v7;
proc format;
value Waterquality   1 = 'A' 2 = 'B' 3 = 'C';
value Accessibility  1 = 'Common tap' 2 = 'Taps inside house';
value Connection     1 = 'Metered' 2 = 'Unmeterd'; 
value Price_increase 1 = '0.1 times' 2 = '0.15 times' 3 = '0.2 times' 4 = '0.25 times';
value Frequency      1 = '2 times' 2 = '3 times'  3 = '4times';
value Duration       1 = '1 hour' 2 = '2 hours' 3 = '3 hours';
run;
%mktlab(data=design, vars=Waterqual Accessibility Connection Priceinc Freq Duration, int=f1-f3, out=final,
stmts=format Waterqual Waterquality. Accessibility Accessibility. Connection Connection. Priceinc Price_increase. Freq Frequency. Duration Duration.);
proc print; run;
%choiceff(data=final, bestout=work.choicexpdes,
model=class(Waterqual Accessibility Connection Priceinc Freq Duration / sta),
nsets=12,
seed=145, 
flags=f1-f3, 
options=relative, 
beta=zero);
proc print; by set; id set; run;
%mktdups(generic, /* generic design (no brands) */
data=work.choicexpdes, /* the input design to evaluate */
/* factors in the design */
factors=Waterqual Accessibility Connection Priceinc Freq Duration,
nalts=3); /* number of alternatives */
proc format;
value zer -1e-12 - 1e-12 = ’ 0 ’;
run;
proc print data=bestcov label;
id __label;
label __label = ’00’x;
var WaterqualA -- Duration2_hours;
format _numeric_ zer5.2;
run;

Re: input statement and merging of choice design and collected data(help)

ballardw — Wed, 05 Dec 2018 16:10:31 GMT

First thing is your posted data step doesn't do quite what you think it does.

1    data results;
2    input subject (r1-r12). Age Gender $ Socialgrp $ Edulvl $;
                           -
                           79
                           76
ERROR 79-322: Expecting a (.

ERROR 76-322: Syntax error, statement will be ignored.

So the data step does not run at all.

You apparently have TAB characters in your data lines. So list input fails with the mix of the data for r1-r12 and no tabs vs the other variables.

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

Or if the question is how to write the input statement then please say so. Perhaps

data results;
   informat subject $2. rstr $12. Age best. Gender $1. Socialgrp $5. Edulvl $20.;
   input subject rstr Age Gender  Socialgrp  Edulvl ;
   array r{12};
   do i= 1 to 12;
      r[i]= input(substr(rstr,i,1),best.);
   end;
   drop i rstr;
datalines;					
1	111332311233	26	F	SC	GRADUATION
2	131332323233	22	M	GEN	GRADUATION
3	131332323233	19	M	GEN	GRADUATION
4	313132323232	19	M	SC	GRADUATION
5	313332323232	19	M	SC	GRADUATION
6	331332323232	25	M	SC	HIGHER SECONDARY
7	331332321332	24	M	GEN	GRADUATION
8	311332323232	28	F	SC	GRADUATION
9	331332323233	52	F	SC	PRIMARY
10	331332323233	21	F	GEN	GRADUATION
11	113232311213	24	M	GEN	GRADUATION
12	331332321233	22	M	GEN	GRADUATION
;
run;

Second is without the macro definitions we have no clue what may be going on.

Re: input statement and merging of choice design and collected data(help)

monishwan — Wed, 05 Dec 2018 16:28:25 GMT

@ballardw. Thank you for your response. Yes I want to know how to write an input statement

Re: input statement and merging of choice design and collected data(help)

monishwan — Thu, 06 Dec 2018 14:44:52 GMT

I ran the input statement and removed all the tabs from the data entry. the results were greatly improved thanks to you. but I am still facing one minor issue in which summary of choices is showing more than 1 pattern after running phreg. Below is the screenshot of the result that I obtained.

I wish to calculate willingness to pay. it will be a great if you can help me figure this out. Below is the code that I have executed.

%mktruns(3 2 2 4 3 3);
%mktex(3 2 2 4 3 3, n=432);
%mkteval(data=randomized)
proc print data=randomized; run;
options validvarname=v7;
proc format;
value Waterquality   1 = 'A' 2 = 'B' 3 = 'C';
value Accessibility  1 = 'Common tap' 2 = 'Taps inside house';
value Connection     1 = 'Metered' 2 = 'Unmeterd'; 
value Price_increase 1 = '0.1 times' 2 = '0.15 times' 3 = '0.2 times' 4 = '0.25 times';
value Frequency      1 = '2 times' 2 = '3 times'  3 = '4times';
value Duration       1 = '1 hour' 2 = '2 hours' 3 = '3 hours';
run;
%mktlab(data=design, vars=Waterqual Accessibility Connection Priceinc Freq Duration, int=f1-f3, out=final,
stmts=format Waterqual Waterquality. Accessibility Accessibility. Connection Connection. Priceinc Price_increase. Freq Frequency. Duration Duration.);
proc print; run;
%choiceff(data=final, bestout=work.choicexpdes,
model=class(Waterqual Accessibility Connection Priceinc Freq Duration / sta),
nsets=12,
seed=145, 
flags=f1-f3, 
options=relative, 
beta=zero);
proc print; by set; id set; run;
%mktdups(generic, /* generic design (no brands) */
data=work.choicexpdes, /* the input design to evaluate */
/* factors in the design */
factors=Waterqual Accessibility Connection Priceinc Freq Duration,
nalts=3); /* number of alternatives */
proc format;
value zer -1e-12 - 1e-12 = ’ 0 ’;
run;
proc print data=bestcov label;
id __label;
label __label = ’00’x;
var WaterqualA -- Duration2_hours;
format _numeric_ zer5.2;
run;
data results;
   informat subject $2. rstr $12. Age best. Gender $1. Socialgrp $5. Edulvl $20.;
   input subject rstr Age Gender  Socialgrp  Edulvl ;
   array r{12};
   do i= 1 to 12;
      r[i]= input(substr(rstr,i,1),best.);
   end;
   drop i rstr;
datalines;					
1   111332311233 26 F SC  GRADUATE
2   131332323233 22 M GEN GRADUATE
3   131332323233 19 M GEN GRADUATE
4   313132323232 19 M SC  GRADUATE
5   313332323232 19 M SC  GRADUATE
6   331332323232 25 M SC  HS
7   331332321332 24 M GEN GRADUATE
8   311332323232 28 F SC  GRADUATE
9   331332323233 52 F SC  PRIMARY
10  331332323233 21 F GEN GRADUATE
11  113232311213 24 M GEN GRADUATE
12  331332321233 22 M GEN GRADUATE
13  331332321233 19 F SC  HS
14  332332321232 27 M SC  GRADUATE
15  113232311232 32 M SC  HS
16  111232321232 19 F OBC HS
17  332332321132 37 M OBC GRADUATE
18  321332321232 38 M GEN GRADUATE
19  113212111213 45 M OBC GRADUATE
20  331332321233 38 M GEN SECONDARY
21  311332321233 27 F GEN HS
22  113332321233 39 F SC  GRADUATE
23  131332323233 42 F GEN GRADUATE
24  113331311232 45 M OBC HS
25  113332313233 24 M OBC GRADUATE
26  313332321232 47 F SC  GRADUATE
27  311332321232 47 F GEN GRADUATE
28  331322233233 23 F GEN PG
29  313332111232 25 F GEN GRADUATE
30  313331323232 38 F SC  GRADUATE
31  313332321233 43 F GEN GRADUATE
32  331332321232 32 F SC  GRADUATE
33  313332321232 48 M GEN GRADUATE
34  331332321232 27 M OBC PG
35  311332321232 37 M OBC GRADUATE
36  113212323232 44 F ST  SECONDARY
37  113332311232 30 F SC  GRADUATE
38  311332311323 24 F GEN GRADUATE
39  313332313232 45 M OBC GRADUATE
40  313332321233 20 F GEN GRADUATE
41  311332323232 47 F GEN SECONDARY
42  113211321232 40 F GEN SECONDARY
43  313332313333 39 M GEN HS
44  331322321233 28 F GEN GRADUATE
45  113332321232 35 M GEN GRADUATE
46  113332311232 32 M GEN GRADUATE
47  321332323232 43 F GEN HS
48  311332311232 36 F OBC HS
49  113332321233 27 F GEN GRADUATE
50  113332311233 21 F GEN GRADUATE
51  331332321233 28 M ST  HS 
52  331332323233 37 F GEN GRADUATE
53  313212213312 32 F SC  GRADUATE
54  313332321232 39 F GEN HS
55  313332323232 59 F SC  PRIMARY
56  311332321232 27 F SC  HS
57  311332311322 42 F GEN GRADUATE
58  113331311233 48 F SC  HS
59  332321311232 33 F GEN GRADUATE
60  213331311232 28 M GEN GRADUATE
61  311332311322 37 M SC  GRADUATE
62  331332321233 45 F SC  SECONDARY
63  313332321232 22 F GEN GRADUATE
64  113332311232 24 F ST  GRADUATE
65  331332321233 37 F OBC GRADUATE
66  111332321232 44 F SC  SECONDARY
67  113212311213 35 F ST  GRADUATE
68  113331311213 53 F GEN SECONDARY
69  113332311232 51 F GEN PRIMARY
70  311332321232 33 F GEN HS
71  113332321232 30 M GEN GRADUATE
72  313332323232 42 F OBC SECONDARY
73  113332311232 24 F GEN HS
74  313332321232 25 F GEN HS
75  311332321333 26 M GEN GRADUATE
76  123332333232 35 F OBC BP
77  332323321233 43 F SC  BP
78  122332333233 39 F SC  BP
79  332323321233 56 F SC  BP
80  322322331233 56 F OBC BP
81  222332333132 27 F SC  SECONDARY
82  222332333233 50 F OBC BP
83  332323321233 44 F SC  BP
84  122332333132 19 F SC  SECONDARY
85  122322331233 63 M OBC BP
86  132321131213 24 F SC  HS
87  132221131213 45 F OBC BP
88  113322311232 45 F SC  BP
89  222332323233 42 F SC  BP
90  332323321233 39 F SC  BP
91  332323321233 60 M SC  BP
92  122332333133 66 M SC  BP
93  113232311213 43 F OBC BP
94  133321321233 42 F SC  BP
95  332332333133 41 F OBC BP
96  312221233212 40 F SC  BP
97  131222333133 40 F SC  BP
98  333332121211 33 F SC  PRIMARY
99  231322321211 22 M OBC HS
100 123232111213 24 F SC  DIPLOMA
101 332323323233 39 F OBC BP
102 132322331233 64 M SC  BP
103 332323231211 34 F SC  BP
104 312321221233 36 F SC  BP
105 122332331233 53 F SC  BP
106 332323321233 39 F SC  BP
107 222332333232 36 F OBC BP
108 322333333213 45 F SC  BP
109 332323321233 42 F OBC BP
110 332323321233 47 F OBC BP
111 231322231213 67 M SC  BP
112 122322331233 23 F SC  BP
113 332323321233 55 F SC  BP
114 312332331213 33 M SC  DIPLOMA
115 311332231313 62 M SC  BP
116 311332131212 28 F SC  SECONDARY
117 332323321233 55 F SC  BP
118 122332331233 32 F SC  SECONDARY
119 322323321233 30 F SC  HS
120 311322231213 52 F OBC BP
121 222331333132 33 F SC  SECONDARY
122 122332333233 52 F SC  BP
123 331332231312 30 F SC  SECONDARY
124 332323331233 27 F SC  DIPLOMA
125 331223321233 32 M OBC DIPLOMA
126 313322321233 33 M OBC PRIMARY
127 113321321233 29 M SC  SECONDARY
128 113232121233 25 M SC  SECONDARY
129 332323321233 21 F SC  DIPLOMA
130 112232321213 37 M OBC DIPLOMA
131 332322321233 26 M OBC DIPLOMA
132 331222333231 66 F OBC BP
133 312332331211 53 M SC  SECONDARY
134 312332331211 36 F SC  PRIMARY
135 312332231213 41 F SC  BP
136 133232321212 53 M OBC BP
137 332323321233 28 F SC  SECONDARY
138 311332231313 41 F OBC PRIMARY
139 333322333233 38 M SC  DIPLOMA
140 332322321233 25 M SC  DIPLOMA
141 122323331233 50 F OBC BP
142 332322321211 26 F SC  SECONDARY
143 312321131211 24 F OBC HS
144 113212311213 40 F SC  PRIMARY
145 112322321233 34 F SC  BP
146 312331323212 41 F SC  BP
147 332222321233 33 F SC  SECONDARY
148 131212313332 46 F SC  BP
149 312332321232 47 F OBC BP
150 112323321233 28 F SC  HS
151 331222321233 34 F OBC PRIMARY
152 312321131211 41 F SC  BP
153 331212332322 34 F SC  PRIMARY
154 113212111213 42 M SC  HS
155 332323221213 30 M OBC DIPLOMA
156 333233321331 42 F SC  BP
157 132332331233 28 F OBC SECONDARY
158 332323321233 49 F SC  BP
159 121213122332 42 F SC  BP
160 132322321233 48 M SC  BP
161 312321131111 23 F SC  HS
162 131321321223 30 F SC  SECONDARY
163 332332231213 46 M OBC BP
164 332332231213 33 F SC  SECONDARY
165 231213332332 32 F OBC SECONDARY
166 222332333233 29 M OBC DIPLOMA
167 331332331213 28 F SC  HS
168 122332331233 44 F SC  BP
169 331332331232 29 F SC  SECONDARY
170 132323321233 22 M SC  SECONDARY
171 332321131231 27 M SC  BP
172 132312111213 30 F SC  SECONDARY
173 333312311212 41 F SC  BP
174 113212111213 29 F SC  SECONDARY
175 332323321233 22 F SC  HS
176 313332311222 25 F GEN BP
177 211232113332 29 F GEN BP
178 113332211222 40 F GEN BP
179 113331211222 22 F GEN BP
180 313331211232 57 F GEN BP
181 113331321232 26 M GEN BP
182 113331311222 19 M GEN BP
183 313331211232 26 M GEN PG
184 311332321232 32 F GEN BP
185 311332311222 28 F GEN PG
186 113332311232 42 F GEN BP
187 213311111213 27 M GEN BP
188 113332311232 31 F OBC BP
189 113232211222 33 F OBC BP
190 313331311222 34 F GEN PG
191 113332311222 27 F OBC BP
192 113331211222 25 F GEN BP
193 313331211222 28 F GEN PG
194 313331221222 29 M OBC PG
195 313331211222 54 M OBC PG
196 313331311222 25 F GEN BP
197 113331311222 45 M GEN BP
198 113331321232 32 M GEN PG
199 211232113332 40 M GEN BP
200 113332211222 40 F GEN HS
;
run;
%mktmerge(design=work.choicexpdes, /* input design */
data=results, /* input data set */
out=res2, /* output data set with design and data */
nsets=12, /* number of choice sets */
nalts=3, /* number of alternatives */
setvars=r1-r12); /* variables with the chosen alt nums */
proc print data=res2(obs=12);
by set subject; id set subject;
run;