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;
@ballardw. Thank you for your response. Yes I want to know how to write an input statement
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-dat... 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.
@ballardw. Thank you for your response. Yes I want to know how to write an input statement
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.