Good day SAS friends:   I need to know how to name this variable in the example, im working in categorical variables, so when the sample has no decimal characters, this means succes ("1") and when the characters have decimal characters means no succes ("0").   here is the data set and my programming (help me to fix it please):   data main; input sample; cards; 23 24 25 26.7 28 28.1 28.2 28.3 ; run; data want; set have; z = .; if sample = (number with no decimals) then do; z = 1; result = "Succes!"; end; else if x = (number with decimals) then do; z = 0; result = "No Succes"; end; run; proc print data=want; var sample z result; run;   Thank you very much   ... View more

Good day SAS friends:   I would like to be helped to complete this routine in SAS. The data i have is as follows:   Data have: Input Sample age_in_days measure; cards; 1   10   3.6 1   15   4.0 1   20   4.2 1   25   5.0 1   30   5.5  2     3   3.6 2     4   4.0 2     5   4.2 2   10   5.0 2   25   5.5 ;   I need this result: Sample age_in_days measure 1     3   . 1     4   . 1     5   . 1   10   3.6 1   15   4.0 1   20   4.2 1   25   5.0 1   30   5.5 2     3   3.6 2     4   4.0 2     5   4.2 2   10   5.0 2   15   . 2   20  . 2   25   5.5 2   30   .   as you can see, i need to complete the missing values in the list, lateron i will use to estimate this values using non linear regression.   Thank you very much ... View more

Good Night:   I'm trying to create data based in PROC MEANS, i need to use the information that PROC MEANS offers.   Thank you very much ... View more

Hi there my SAS friends:   I have this table, is an experiment os repeated measures in humans, each human with diferent ages and weights (as response variabel). Here you can see the original table:   Person Age1 weight_1 Age2 weight_2 Age3 weight_3 1 1672 61 1714 65.4 1775 51 2 1671 45 1713 49.2 1774 46 3 1670 55 1712 59.4 1773 44 4 1670 47.2 1712 50 1773 42.2 5 1669 50 1711 . 1772 46.1 6 1668 46.2 1710 50.4 1771 43.3 7 1668 47 1710 51 1771 43 8 2153 48 2195 54.2 2256 48.2 9 2152 51 2194 54 2255 47 10 2151 56.1 2193 63.4 2254 50.1   Now, the question is:   HOW CAN I OBTAIN A TABLE LIKE THIS, USINS SAS???   Person AGE Age_in_Days Weight Weigh_in_grams 1 Age1 1672 weight_1 61 1 Age2 1714 weight_2 65.4 1 Age3 1775 weight_3 51 2 Age1 1671 weight_1 45 2 Age2 1713 weight_2 49.2 2 Age3 1774 weight_3 46 3 Age1 1670 weight_1 55 3 Age2 1712 weight_2 59.4 3 Age3 1773 weight_3 44 4 Age1 1670 weight_1 47.2 4 Age2 1712 weight_2 50 4 Age3 1773 weight_3 42.2 5 Age1 1669 weight_1 50 5 Age2 1711 weight_2 0 5 Age3 1772 weight_3 46.1 6 Age1 1668 weight_1 46.2 6 Age2 1710 weight_2 50.4 6 Age3 1771 weight_3 43.3 7 Age1 1668 weight_1 47 7 Age2 1710 weight_2 51 7 Age3 1771 weight_3 43 8 Age1 2153 weight_1 48 8 Age2 2195 weight_2 54.2 8 Age3 2256 weight_3 48.2 9 Age1 2152 weight_1 51 9 Age2 2194 weight_2 54 9 Age3 2255 weight_3 47 10 Age1 2151 weight_1 56.1 10 Age2 2193 weight_2 63.4 10 Age3 2254 weight_3 50.1     As you can note, is an special transpose that i'm trying to solve but unhappily i coudlnt make it.   Thanks for your colaboration my SAS friends.     ... View more

Good Evening my SAS friends:   Here i am to get some help about constructing the significance difference ussing LS_MEANS means comparison matrix, weel i have an example to solve (with your help):   Here is the significance LS MEANS matrix :   i/j 1 2 3 4 5 6 7 8 9 10 11 12 1   1.0000 0.7619 0.2159 1.0000 1.0000 0.6868 0.1134 1.0000 1.0000 0.6291 0.0288 2 1.0000   0.8421 0.1318 1.0000 1.0000 0.7926 0.1631 0.9998 1.0000 0.7434 0.0442 3 0.7619 0.8421   0.0002 0.1632 0.7513 1.0000 0.9999 0.0840 0.5783 1.0000 0.9929 4 0.2159 0.1318 0.0002   0.0630 0.0037 <.0001 <.0001 0.0843 0.0053 <.0001 <.0001 5 1.0000 1.0000 0.1632 0.0630   0.9658 0.0070 <.0001 1.0000 0.9915 0.0017 <.0001 6 1.0000 1.0000 0.7513 0.0037 0.9658   0.4299 0.0058 0.8339 1.0000 0.2921 0.0002 7 0.6868 0.7926 1.0000 <.0001 0.0070 0.4299   0.9337 0.0008 0.1717 1.0000 0.5166 8 0.1134 0.1631 0.9999 <.0001 <.0001 0.0058 0.9337   <.0001 0.0006 0.9121 1.0000 9 1.0000 0.9998 0.0840 0.0843 1.0000 0.8339 0.0008 <.0001   0.9205 0.0001 <.0001 10 1.0000 1.0000 0.5783 0.0053 0.9915 1.0000 0.1717 0.0006 0.9205   0.0828 <.0001 11 0.6291 0.7434 1.0000 <.0001 0.0017 0.2921 1.0000 0.9121 0.0001 0.0828   0.4230 12 0.0288 0.0442 0.9929 <.0001 <.0001 0.0002 0.5166 1.0000 <.0001 <.0001 0.4230     Following this table, arriving to the conclussion i arrives to this result:   1 -> bcde 2 -> bcde 3 -> abcd 4 -> e 5 -> cde 6 -> bcd 7 -> ab 8 -> c 9 -> de 10 -> bcd 11 -> ab 12 -> a   Well my friends, i made this manually...and for this case i would like to know if there is any command line to get this kind of results atumatically. to obtain this type of result:   EXAMPLE   Tukey Grouping                       Mean      N    Treatment                                    A        192.58      9   1                                    A                              B    A        183.69      9   2                              B    A                              B    A        161.21      9    3                              B    A                              B    A        156.47      9    4                              B    A                              B    A        147.69      9    5                              B    A                              B    A        142.30      9    6                              B    A                              B    A        142.30      9    7                              B    A                              B    A        142.30      9    8                              B    A                              B    A        142.30      9    9                              B    A                              B    A        142.30      9    10                              B    A                              B    A        142.30      9    11                              B                              B              128.63      9    12 ... View more