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;
... View more
