Good day: I have this data set: data have; input Order ID; cards; 1 ROBERT 2 CARLOS 3 EDWARD 4 JHON ; now i need this: ORDER ID STATUS 1 ROBERT ok 1.1 ROBERT ok 1.2 ROBERT ok 1.3 ROBERT ok 2 CARLOS ok 2.1 CARLOS ok 2.2 CARLOS ok 2.3 CARLOS ok 3 EDWARD ok 3.1 EDWARD ok 3.2 EDWARD ok 3.3 EDWARD ok 4 JHON ok 4.1 JHON ok 4.2 JHON ok 4.3 JHON ok     ... View more

data new; input day live death; cards; Day_0 37 0 Day_6 36 1 Day_12 21 16 Day_18 8 29 Day_24 2 35 ;   SO, in this case i want to estimate the survival rate between days and find statistical differences between them, and  estimate, in the same way, in wich day occured the major mortality. THs objective here is to obtain a table like this:   Day Total Survival Day_0 37 100.00% Day_6 36 97.30% Day_12 21 56.76% Day_18 8 21.62% Day_24 2 5.41%         ... View more

I have this dataset:   data have; length day$ 20; input week day$ sell_item; format sell_item sell_item_.; datalines; 1 Monday 6 1 Tuesday 51 1 Wednesday 69 1 Thursday 68 1 Friday 28 1 Saturday 16 1 Sunday 94 ; proc freq data=have; tables day / nopercent norow nocol deviation expected chisq; weight sell_item; run;     here i see information of selling items in a store. Regarding chi squared test, can be found statistical significance (p<0.01), but i would like to estimate individual difference of selling between each day.   thanks in advance ... View more

Good morning:   i have this data set:   Question Sex yes_no 1 male 1 1 male 1 1 male 0 1 male 0 1 male 0 1 male 0 1 male 0 2 male 1 2 male 1 2 male 1 2 male 0 2 male 0 2 male 0 2 male 0 3 male 1 3 male 1 3 male 1 3 male 1 3 male 1 3 male 0   and i need to obtain this one, as follows:   Sex Question_1 Question_2 Question_3 male 1 1 1 male 1 1 1 male 0 1 1 male 0 0 1 male 0 0 1 male 0 0 0 male 0 0        .   Thanks in advance     ... View more

HI friends:   I have this data set:   data have; input Questions sex yes no; cards; Question_1 male 2 5 Question_2 male 3 4 Question_3 male 5 1 ; and i have to obtain this table:   Question Sex yes_no 1 male 1 1 male 1 1 male 0 1 male 0 1 male 0 1 male 0 1 male 0 2 male 1 2 male 1 2 male 1 2 male 0 2 male 0 2 male 0 2 male 0 3 male 1 3 male 1 3 male 1 3 male 1 3 male 1 3 male 0     need to be notice that 0 means NO and 1 means YES, from the origin dataset   Thanks in advance ... View more

Good morning SAS friends:   I have this data set:   data have; input box length weight ; cards; 1 8.1 6.3 1 9.1 9.6 1 10.2 11.6 1 11.9 18.5 1 12.2 26.2 1 13.8 36.1 1 14.8 40.1 1 15.7 47.3 2 16.6 65.6 2 17.7 69.4 2 18.7 76.4 2 19 82.5 2 20.6 106.6 2 21.9 119.8 2 22.9 169.2 2 23.5 173.3 ;     using this data set, i apply two regressions, one for box 1 and other for box 2, resulting some tables, the first one for ANOVA and the second one indicating the estimates of the variables, the last of the is the main reason to note:   For box 1: Parameter Estimates Variable DF Parameter Estimate Standard Error t Value Pr > |t| Intercept 1 -42.10680 5.35822 -7.86 0.0002 length 1 5.55902 0.43770 12.70 <.0001   and for Box 2: Parameter Estimates Variable DF Parameter Estimate Standard Error t Value Pr > |t| Intercept 1 -224.06587 41.01922 -5.46 0.0016 length 1 16.50296 2.02574 8.15 0.0002   The main objective of this problem is create a new data set containing both the intercept and slope for each box, like this: Box intercept length 1 -42.1068 5.55902 2 -224.06587 16.50296   Thanks in advance       ... View more