value set over 200 value

Discussions about CSEntry
Post Reply
mgtoukam
Posts: 29
Joined: March 24th, 2015, 4:23 am

value set over 200 value

Post by mgtoukam »

Dear Team

I'm working in a poject and i have dynamic value set with more than 200 value.

It is possible to share and application to solvee this issue?

Regards.
Gregory Martin
Posts: 1792
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: value set over 200 value

Post by Gregory Martin »

What is the problem that you are facing? I have used value sets with hundreds of values, so I doubt that the number of values is the issue.

You can send your program to cspro@lists.census.gov.
mgtoukam
Posts: 29
Joined: March 24th, 2015, 4:23 am

Re: value set over 200 value

Post by mgtoukam »

Hi team,

This the problems.

We have the fllowing questions

Q1.a Choose one items
Q1.a Others
Q1.b. Choose more than one items (exepted Q1.a)
Q1.b Others
Q2. Choose more than one items (excepted Q1.a and Q1.b)
Q3. Choose more than one items (in the folowing Q1.a, Q1.b and Q2, and add Q1.a Others or Q1.b Others, and and don't know and refused)
Q4. Chose more than one item (In the item choose in Q3). and add the other response in the chose Q1.a others or Q1.b Other and refused and don't know=
Q5. Chose one item (In the item choose in Q3, and add the other response in the chose, and don't know and refused + add Q1.a Others or Q1.b Others ).

This is the following items response for those question.

Q1.a Q1.b Q2 Q3 Q4 Q5
Televison name 1 1 1 1 1 1 1
Televison name 2 2 2 2 2 2 2
Televison name 3 3 3 3 3 3 3
Televison name 4 4 4 4 4 4 4
Televison name 5 5 5 5 5 5 5
Televison name 6 6 6 6 6 6 6
Televison name 7 7 7 7 7 7 7
Televison name 8 8 8 8 8 8 8
Televison name 9 9 9 9 9 9 9
Televison name 10 10 10 10 10 10 10
Televison name 11 11 11 11 11 11 11
Televison name 12 12 12 12 12 12 12
Televison name 13 13 13 13 13 13 13
Televison name 14 14 14 14 14 14 14
Televison name 15 15 15 15 15 15 15
Televison name 16 16 16 16 16 16 16
Televison name 17 17 17 17 17 17 17
Televison name 18 18 18 18 18 18 18
Televison name 19 19 19 19 19 19 19
Televison name 20 20 20 20 20 20 20
Televison name 21 21 21 21 21 21 21
Televison name 22 22 22 22 22 22 22
Televison name 23 23 23 23 23 23 23
Televison name 24 24 24 24 24 24 24
Televison name 25 25 25 25 25 25 25
Televison name 26 26 26 26 26 26 26
Televison name 27 27 27 27 27 27 27
Televison name 28 28 28 28 28 28 28
Televison name 29 29 29 29 29 29 29
Televison name 30 30 30 30 30 30 30
Televison name 31 31 31 31 31 31 31
Televison name 32 32 32 32 32 32 32
Televison name 33 33 33 33 33 33 33
Televison name 34 34 34 34 34 34 34
Televison name 35 35 35 35 35 35 35
Televison name 36 36 36 36 36 36 36
Televison name 37 37 37 37 37 37 37
Televison name 38 38 38 38 38 38 38
Televison name 39 39 39 39 39 39 39
Televison name 40 40 40 40 40 40 40
Televison name 41 41 41 41 41 41 41
Televison name 42 42 42 42 42 42 42
Televison name 43 43 43 43 43 43 43
Televison name 44 44 44 44 44 44 44
Televison name 45 45 45 45 45 45 45
Televison name 46 46 46 46 46 46 46
Televison name 47 47 47 47 47 47 47
Televison name 48 48 48 48 48 48 48
Televison name 49 49 49 49 49 49 49
Televison name 50 50 50 50 50 50 50
Televison name 51 51 51 51 51 51 51
Televison name 52 52 52 52 52 52 52
Televison name 53 53 53 53 53 53 53
Televison name 54 54 54 54 54 54 54
Televison name 55 55 55 55 55 55 55
Televison name 56 56 56 56 56 56 56
Televison name 57 57 57 57 57 57 57
Televison name 58 58 58 58 58 58 58
Televison name 59 59 59 59 59 59 59
Televison name 60 60 60 60 60 60 60
Televison name 61 61 61 61 61 61 61
Televison name 62 62 62 62 62 62 62
Televison name 63 63 63 63 63 63 63
Televison name 64 64 64 64 64 64 64
Televison name 65 65 65 65 65 65 65
Televison name 66 66 66 66 66 66 66
Televison name 67 67 67 67 67 67 67
Televison name 68 68 68 68 68 68 68
Televison name 69 69 69 69 69 69 69
Televison name 70 70 70 70 70 70 70
Televison name 71 71 71 71 71 71 71
Televison name 72 72 72 72 72 72 72
Televison name 73 73 73 73 73 73 73
Televison name 74 74 74 74 74 74 74
Televison name 75 75 75 75 75 75 75
Televison name 76 76 76 76 76 76 76
Televison name 77 77 77 77 77 77 77
Televison name 78 78 78 78 78 78 78
Televison name 79 79 79 79 79 79 79
Televison name 80 80 80 80 80 80 80
Televison name 81 81 81 81 81 81 81
Televison name 82 82 82 82 82 82 82
Televison name 83 83 83 83 83 83 83
Televison name 84 84 84 84 84 84 84
Televison name 85 85 85 85 85 85 85
Televison name 86 86 86 86 86 86 86
Televison name 87 87 87 87 87 87 87
Televison name 88 88 88 88 88 88 88
Televison name 89 89 89 89 89 89 89
Televison name 90 90 90 90 90 90 90
Televison name 91 91 91 91 91 91 91
Televison name 92 92 92 92 92 92 92
Televison name 93 93 93 93 93 93 93
Televison name 94 94 94 94 94 94 94
Televison name 95 95 95 95 95 95 95
Televison name 96 96 96 96 96 96 96
Televison name 97 97 97 97 97 97 97
Televison name 98 98 98 98 98 98 98
Televison name 99 99 99 99 99 99 99
Televison name 100 100 100 100 100 100 100
Televison name 101 101 101 101 101 101 101
Televison name 102 102 102 102 102 102 102
Televison name 103 103 103 103 103 103 103
Televison name 104 104 104 104 104 104 104
Televison name 105 105 105 105 105 105 105
Televison name 106 106 106 106 106 106 106
Televison name 107 107 107 107 107 107 107
Televison name 108 108 108 108 108 108 108
Televison name 109 109 109 109 109 109 109
Televison name 110 110 110 110 110 110 110
Televison name 111 111 111 111 111 111 111
Televison name 112 112 112 112 112 112 112
Televison name 113 113 113 113 113 113 113
Televison name 114 114 114 114 114 114 114
Televison name 115 115 115 115 115 115 115
Televison name 116 116 116 116 116 116 116
Televison name 117 117 117 117 117 117 117
Televison name 118 118 118 118 118 118 118
Televison name 119 119 119 119 119 119 119
Televison name 120 120 120 120 120 120 120
Televison name 121 121 121 121 121 121 121
Televison name 122 122 122 122 122 122 122
Televison name 123 123 123 123 123 123 123
Televison name 124 124 124 124 124 124 124
Televison name 125 125 125 125 125 125 125
Televison name 126 126 126 126 126 126 126
Televison name 127 127 127 127 127 127 127
Televison name 128 128 128 128 128 128 128
Televison name 129 129 129 129 129 129 129
Televison name 130 130 130 130 130 130 130
Televison name 131 131 131 131 131 131 131
Televison name 132 132 132 132 132 132 132
Televison name 133 133 133 133 133 133 133
Televison name 134 134 134 134 134 134 134
Televison name 135 135 135 135 135 135 135
Televison name 136 136 136 136 136 136 136
Televison name 137 137 137 137 137 137 137
Televison name 138 138 138 138 138 138 138
Televison name 139 139 139 139 139 139 139
Televison name 140 140 140 140 140 140 140
Televison name 141 141 141 141 141 141 141
Televison name 142 142 142 142 142 142 142
Televison name 143 143 143 143 143 143 143
Televison name 144 144 144 144 144 144 144
Televison name 145 145 145 145 145 145 145
Televison name 146 146 146 146 146 146 146
Televison name 147 147 147 147 147 147 147
Televison name 148 148 148 148 148 148 148
Televison name 149 149 149 149 149 149 149
Televison name 150 150 150 150 150 150 150
Televison name 151 151 151 151 151 151 151
Televison name 152 152 152 152 152 152 152
Televison name 153 153 153 153 153 153 153
Televison name 154 154 154 154 154 154 154
Televison name 155 155 155 155 155 155 155
Televison name 156 156 156 156 156 156 156
Televison name 157 157 157 157 157 157 157
Televison name 158 158 158 158 158 158 158
Televison name 159 159 159 159 159 159 159
Televison name 160 160 160 160 160 160 160
Televison name 161 161 161 161 161 161 161
Televison name 162 162 162 162 162 162 162
Televison name 163 163 163 163 163 163 163
Televison name 164 164 164 164 164 164 164
Televison name 165 165 165 165 165 165 165
Televison name 166 166 166 166 166 166 166
Televison name 167 167 167 167 167 167 167
Televison name 168 168 168 168 168 168 168
Televison name 169 169 169 169 169 169 169
Televison name 170 170 170 170 170 170 170
Televison name 171 171 171 171 171 171 171
Televison name 172 172 172 172 172 172 172
Televison name 173 173 173 173 173 173 173
Televison name 174 174 174 174 174 174 174
Televison name 175 175 175 175 175 175 175
Televison name 176 176 176 176 176 176 176
Televison name 177 177 177 177 177 177 177
Televison name 178 178 178 178 178 178 178
Televison name 179 179 179 179 179 179 179
Televison name 180 180 180 180 180 180 180
Televison name 181 181 181 181 181 181 181
Televison name 182 182 182 182 182 182 182
Televison name 183 183 183 183 183 183 183
Televison name 184 184 184 184 184 184 184
Televison name 185 185 185 185 185 185 185
Televison name 186 186 186 186 186 186 186
Televison name 187 187 187 187 187 187 187
Televison name 188 188 188 188 188 188 188
Televison name 189 189 189 189 189 189 189
Televison name 190 190 190 190 190 190 190
Televison name 191 191 191 191 191 191 191
Televison name 192 192 192 192 192 192 192
Televison name 193 193 193 193 193 193 193
Televison name 194 194 194 194 194 194 194
Televison name 195 195 195 195 195 195 195
Televison name 196 196 196 196 196 196 196
Televison name 197 197 197 197 197 197 197
Televison name 198 198 198 198 198 198 198
Televison name 199 199 199 199 199 199 199
Televison name 200 200 200 200 200 200 200
Televison name 201 201 201 201 201 201 201
Televison name 202 202 202 202 202 202 202
Televison name 203 203 203 203 203 203 203
Televison name 204 204 204 204 204 204 204
Televison name 205 205 205 205 205 205 205
Televison name 206 206 206 206 206 206 206
Televison name 207 207 207 207 207 207 207
Televison name 208 208 208 208 208 208 208
Televison name 209 209 209 209 209 209 209
Televison name 210 210 210 210 210 210 210
Televison name 211 211 211 211 211 211 211
Televison name 212 212 212 212 212 212 212
Televison name 213 213 213 213 213 213 213
Televison name 214 214 214 214 214 214 214
Televison name 215 215 215 215 215 215 215
Televison name 216 216 216 216 216 216 216
Televison name 217 217 217 217 217 217 217
Televison name 218 218 218 218 218 218 218
Televison name 219 219 219 219 219 219 219
Televison name 220 220 220 220 220 220 220
Televison name 221 221 221 221 221 221 221
Televison name 222 222 222 222 222 222 222
Televison name 223 223 223 223 223 223 223
Televison name 224 224 224 224 224 224 224
Televison name 225 225 225 225 225 225 225
Televison name 226 226 226 226 226 226 226
Televison name 227 227 227 227 227 227 227
Televison name 228 228 228 228 228 228 228
Televison name 229 229 229 229 229 229 229
Televison name 230 230 230 230 230 230 230
Televison name 231 231 231 231 231 231 231
Televison name 232 232 232 232 232 232 232
Televison name 233 233 233 233 233 233 233
Televison name 234 234 234 234 234 234 234
Televison name 235 235 235 235 235 235 235
Televison name 236 236 236 236 236 236 236
Televison name 237 237 237 237 237 237 237
Televison name 238 238 238 238 238 238 238
Televison name 239 239 239 239 239 239 239
Televison name 240 240 240 240 240 240 240
Televison name 241 241 241 241 241 241 241
Televison name 242 242 242 242 242 242 242
Televison name 243 243 243 243 243 243 243
Televison name 244 244 244 244 244 244 244
Televison name 245 245 245 245 245 245 245
Televison name 246 246 246 246 246 246 246
Televison name 247 247 247 247 247 247 247
Televison name 248 248 248 248 248 248 248
Televison name 249 249 249 249 249 249 249
Televison name 250 250 250 250 250 250 250
Televison name 251 251 251 251 251 251 251
Televison name 252 252 252 252 252 252 252
Others 253 253 253 253 253 253
Don't know 254 254 254 254 254 254
Refused 255 255 255 255 255 255


I send you an email.

regards
Gregory Martin
Posts: 1792
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: value set over 200 value

Post by Gregory Martin »

Personally, I would suggest rethinking that question. Presenting a list of 255 multiple response values seems like it would be hard to work with. However, if you choose to continue with this, you have to setup Q1A as a checkbox field, so make it an alpha of length 765 (255 responses x 3 digits per response). Then make each value unique: "001," "002," ..., "765."

You can use the isChecked function to determine if a certain value is picked. For example:
if isChecked("253", Q1A) then
    // they selected other
Then for the other questions you have to work with dynamic value sets. See here for more information:

viewtopic.php?f=1&t=3883&p=12077
mgtoukam
Posts: 29
Joined: March 24th, 2015, 4:23 am

Re: value set over 200 value

Post by mgtoukam »

Hi Greg,

I'am created the following application.

Numeric len = 185;
array string alphabet4(len) = "001", "002", "003", "004", "005", "006", "007", "008", "009", "010", "011", "012", "013", "014", "015", "016", "017", "018", "019", "020", "021", "022", "023", "024", "025", "026", "027", "028", "029", "030", "031", "032", "033", "034", "035", "036", "037", "038", "039", "040", "041", "042", "043", "044", "045", "046", "047", "048", "049", "050", "051", "052", "053", "054", "055", "056", "057", "058", "059", "060", "061", "062", "063", "064", "065", "066", "067", "068", "069", "070", "071", "072", "073", "074", "075", "076", "077", "078", "079", "080", "081", "082", "083", "084", "085", "086", "087", "088", "089", "090", "091", "092", "093", "094", "095", "096", "097", "098", "099", "100", "101", "102", "103", "104", "105", "106", "107", "108", "109", "110", "111", "112", "113", "114", "115", "116", "117", "118", "119", "120", "121", "122", "123", "124", "125", "126", "127", "128", "129", "130", "131", "132", "133", "134", "135", "136", "137", "138", "139", "140", "141", "142", "143", "144", "145", "146", "147", "148", "149", "150", "151", "152", "153", "154", "155", "156", "157", "158", "159", "160", "161", "162", "163", "164", "165", "166", "167", "168", "169", "170", "171", "172", "173", "174", "175", "176", "177", "178", "179", "180", "181", "182", "183", "184", "185";

the following proc is not working.I have to remove the value check at Q10_A.

PROC Q10_B_ALPHA

preproc
vs_Q10_B_ALPHA = vs_Q10_A;

alpha Letter4;
letter4 = Q10_A;

do i = 1 while i <= len

if pos(alphabet4(i), letter4) = 1 then
vs_Q10_B_ALPHA.remove(alphabet4(i));
endif;
enddo;

setvalueset(Q10_B_ALPHA, vs_Q10_B_ALPHA);

onfocus

Q10_B_ALPHA = "";

What is the issue?

Find attached the app.

Regards.
Television.zip
(24.96 KiB) Downloaded 178 times
mgtoukam
Posts: 29
Joined: March 24th, 2015, 4:23 am

Re: value set over 200 value

Post by mgtoukam »

thanks Gred.

but i have the following issue.

In Q1 we choose one value.
In Q2 we remove the value choose in Q1.
In Q3, We have to chose value from the combination of Q1 and Q2 .

How to do?
aaronw
Posts: 565
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: value set over 200 value

Post by aaronw »

Let me clarify what you want.

Q1 is a radio button (one selection made)? Q2 is a check box (multiple selection possible)? Q3's response set is everything chosen in Q1 and Q2? Is it a radio button or check box?
mgtoukam
Posts: 29
Joined: March 24th, 2015, 4:23 am

Re: value set over 200 value

Post by mgtoukam »

Q1 is a radio button (one selection made)? yes

Q2 is a check box (multiple selection possible)? yes

Q3's response set is everything chosen in Q1 and Q2? check box ok
aaronw
Posts: 565
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: value set over 200 value

Post by aaronw »

Once you understand dynamic value sets you'll be able to create any combination of responses you need. We have a blog post on the topic that I would recommend reading: https://www.csprousers.org/posts/2019-0 ... bject.html.

I've attached a demo application that does what you ask. Take a look at the logic, but also make note of the fields types and lengths.
Attachments
vs.zip
(2.36 KiB) Downloaded 187 times
Post Reply