Hi everybody, I have a question about designing a DCE. I have 2 unlabeled alternatives (Alt1 and Alt2) and also a no-choice option. I have 4 attributes (X1, X2, X3, X4) with their levels mentioned below:   X1: %5 %10 %15 %20 X2: 0=no 1=yes X3: 0=no 1=yes X4: 30 40 50 60   Based on what I read, I created this orthogonal design. Here is the design;   %mktruns(4 2 2 4 4 2 2 4) /* factor level list for all attrs and alts */ %mktex(4 2 2 4 4 2 2 4, /* factor level list for all attrs and alts */ n=64, /* number of choice sets */ seed=17) /* random number seed %mktblock(data=randomized, /* block randomized design */ nblocks=2, /* create 2 blocks of 32 choice sets */ out=blocked, /* output data set for blocked design */ seed=17) /* random number seed */ data key; input Brand $ Knd $ Omg $ Mrk $ Price $; datalines; Alt1 x1 x2 x3 x4 Alt2 x5 x6 x7 x8 None . . . . . ; %mktroll(design=blocked, /* make choice design from blocked */ /* linear arrangement from %mktblock */ key=key, /* use rules in KEY data set */ alt=brand, /* alternative name variable is Place */ out=work.food64, /* permanent data set for results */ keep=block) /* keep the blocking variable */ proc format; value knd 1 = ’%5’ 2 = ’%10’ 3 = ’%15’ 4 = ’%20’ . = ’ ’; value omg 1 = ’no’ 2 = ’yes’ . = ’ ’; value mrk 1 = ’no’ 2 = ’yes’ . = ’ ’; value price 1 = $30 2 = $40 3 = $50 4 = $60 . = ’ ’; run; data work.food64; set work.food64; format knd knd. omg omg. mrk mrk. price price.; run; proc print data=work.food64(obs=192); by set; id set; run; When I examined the generated choice sets, I noticed that in some choice sets, every level was the same except for price. For example, the choice set shown below; What can I do to avoid these choice sets? Thank you so much! ... View more

Hello Community,  I remember being able to map variable value into LINE statement text in the past, but cannot figure out it now. I believe there is an elementary item that I'm missing (which is unfamiliar to me).  Currently,  to map a variable value into the LINE I keep hardcoding, eg. using IF/ELSE (see below #1).  Could anyone fix #2 and explain how to avoid hardcoding part?  Many thanks! data have; input visitnum visit $; if visit eq 'Screen' then do score= 1 to 5; output; end; else do score= 1 to 6; output; end; cards; 1 Screen 2 Week_1 3 Week_2 4 Week_3 ; run; proc format; value score 1= 'Very severe' 2= 'Severe' 3= 'Moderate' 4= 'Mild' 5= 'Minimal' 6= 'No pain'; run; /* 1. Current coding */ proc report data=have; column visitnum visit score; define visitnum/order noprint; define visit/ noprint; define score/'Response Category' format=score. style(column)={just=l} display; compute before visitnum/style={just=l}; line @1 text $40.; length text $40; if visitnum=1 then text='Screen'; else if visitnum=2 then text='Week_1'; else if visitnum=3 then text='Week_2'; else if visitnum=4 then text='Week_3'; endcomp; run; /* 2. Wanted coding - needs to be fixed to get the same result as #1*/ proc report data=have; column visitnum visit score; define visitnum/order noprint; define visit/ noprint; define score/'Response Category' format=score. style(column)={just=l} display; compute before visitnum/style={just=l}; line @1 text $40.; length text $40; text=visit; endcomp; run; ... View more

Hello, I have an array that searches seven variables for numbers. The seven variables contain the number of days between two dates (this could range from -300 to +300). Based on the numbers that it finds it is classified into 1 of 8 categories. In this case I want certain categories to take precedence over others, so I have created IF/else statements so that if the best match is found. My code is the following: Treat_cat = "No treatment listed"; array diff{7} Days_bt_PHAC_Tx1-Days_bt_PHAC_Tx7; do i= 1 to 7; if diff(i) GE -14 and diff(i) LE 3 then Treat_cat = "1. Within 3 days"; else if diff(i) GE 4 and diff(i) LE 7 then Treat_cat = "2. Between 4 to 7 days"; else if diff(i) GE 8 and diff(i) LE 14 then Treat_cat = "3. Between 8 to 14 days"; else if diff(i) GE 15 and diff(i) LE 30 then Treat_cat = "4. Between 15 to 30 days"; else if diff(i) GE 31 and diff(i) LE 365 then Treat_cat = "5. Between 31 to 365 days"; else if diff(i) GT 365 then Treat_cat = "6. More than 365 days"; else if diff(i) NE '' and diff(i) LE -15 then Treat_cat = "7. Below categories"; end; drop i; However, i'm finding that the code is working in that it is assigning all cases to a category. However it will assign them to the last category in the set of else/if statements. For example, if the days between dates for a case are 0, 16, the case will be assigned to the "Between 15 and 30 days" instead of "within 3 days". If the same case had 0, 16, and 76 then they would be assigned to "Between 31 and 365". It seems to always take the last category in my else if statements instead of the first. Any help would be appreciated.  ... View more