Recently in the SAS Community Library: SAS' @SophiaRowland spells out how SAS Model Manager's new model card works. Think of it like a "nutrition label" for AI models. ... View more

When I do survival analysis，all strata have events, but why still got this warning: "The likelihood ratio test for strata homogeneity is questionable since some strata have no events." ?   Log as below:    Output Added: ------------- Name: HomTests Label: Homogeneity Tests Template: Stat.Lifetest.HomTests Path: Lifetest.ByGroup3.StrataHomogeneity.HomTests ------------- WARNING: The likelihood ratio test for strata homogeneity is questionable since some strata have no events.     My code as below, in my dataset cnsr value inclued (0 1), and all trt01an have events(0 1). Why still got this warning? What the meaning? Does it affect other analyses like ProductLimitEstimates, Quartiles etc. ? Is this survival analysis still valid? proc lifetest data=adtte timelist=(0 to 20 by 2) atrisk outsurv=surviv reduceout; by TYPEN; time aval*cnsr(1); strata trt01an; run; ... View more

I would like to transpose column sord only. here is the sample data below.   I tried using ID statement. but other columns are also getting transpose. ... View more

Dear SAS colleagues,                  I have to import "CSV" file and I have working code for "ACCESS" file. Here is the sample code for access database (just  proc import out = work.want datatable= "GIVEN" dbms = ACCESSCS replace; database= "\\WELSFGO\KDRIVE$\Test_File.mdb"; server= 'WELSFGO.NETIZENS.BANK-DSb.COM'; port = 7845; run; I tried different ways to import similar kind of code like the one shown below. proc import out=want DATAFILE="\\WELSFGO\KDRIVE$\Test_File.csv" dbms=csv replace; server= 'WELSFGO.NETIZENS.BANK-DSb.COM'; port = 7845; run; I get the following error.    ERROR: Import unsuccessful. See SAS Log for details.   I don't have any other details to know further. Could someone help me fix the syntax so that I  could import the csv file?    Thanks in Advance!!!     ... View more

hello, I would like to run the model of Fine and Gray to analyse the effect of a binary character (IA = 0 vs 1) on "reop". unfortunately, death is a competing event. I created a new variable named "compet" (=0 when censor, 1 when reop and 2 in case of death). proc phreg data = ; class IA (ref= first); model futime*compet(0) = IA : eventcode =1; run; data WORK.THOM; infile datalines dsd truncover; input N°:BEST. DDN:MMDDYY10. sexe:BEST. DBO:MMDDYY10. IA:BEST. fu:MMDDYY10. death:BEST. reop:BEST. dreop:MMDDYY10. compet:32. futime:32.; format N° BEST. DDN MMDDYY10. sexe BEST. DBO MMDDYY10. IA BEST. fu MMDDYY10. death BEST. reop BEST. dreop MMDDYY10.; label N°="N°" DDN="DDN" sexe="sexe" DBO="DBO" IA="IA" fu="fu" death="death" reop="reop" dreop="dreop"; datalines; 1 12/25/1987 1 03/26/2003 1 07/20/2022 0 1 11/29/2013 1 3901 2 05/07/1983 1 03/26/2003 1 05/23/2023 0 1 02/24/2015 1 4353 3 05/19/1966 1 04/14/2003 1 06/10/2023 0 0 06/10/2023 0 7362 4 11/28/1980 1 05/20/2003 0 12/07/2012 0 0 12/07/2012 0 3489 5 06/27/1989 0 10/04/2004 1 04/27/2022 0 0 04/27/2022 0 6414 6 09/04/1958 1 02/21/2005 1 08/17/2023 0 0 08/17/2023 0 6751 7 02/27/1970 1 04/04/2005 1 08/22/2023 0 1 01/29/2021 1 5779 8 10/09/1974 1 11/21/2005 1 09/01/2020 0 1 06/26/2006 1 217 9 07/17/1967 0 02/27/2006 1 04/12/2022 0 0 04/12/2022 0 5888 10 03/11/1970 0 03/01/2006 1 06/10/2023 0 0 06/10/2023 0 6310 11 10/10/1979 0 05/22/2006 1 06/13/2023 0 0 06/13/2023 0 6231 12 03/16/1982 0 04/23/2007 1 10/20/2022 0 0 10/20/2022 0 5659 13 03/30/1974 1 10/09/2009 0 06/10/2023 0 0 06/10/2023 0 4992 14 12/25/1961 1 11/18/2009 0 06/10/2023 0 0 06/10/2023 0 4952 15 09/27/1987 0 02/17/2010 0 06/05/2023 0 0 06/05/2023 0 4856 16 09/28/1976 1 04/19/2010 0 05/30/2022 0 0 05/30/2022 0 4424 17 01/18/1997 1 05/10/2010 0 06/05/2020 0 0 06/05/2020 0 3679 18 12/27/1982 0 05/28/2010 0 07/07/2023 0 0 07/07/2023 0 4788 19 11/10/1967 1 05/31/2010 1 06/21/2023 0 0 06/21/2023 0 4769 20 09/11/1981 1 06/23/2010 0 07/01/2019 0 0 07/01/2019 0 3295 21 05/23/1985 1 07/02/2010 0 06/15/2023 0 0 06/15/2023 0 4731 22 03/03/1967 1 07/19/2010 0 06/10/2023 0 0 06/10/2023 0 4709 23 03/23/1973 1 07/19/2010 0 01/01/2011 0 0 01/01/2011 0 166 24 02/04/1995 1 07/27/2010 0 10/11/2022 0 0 10/11/2022 0 4459 25 09/07/1974 1 10/12/2010 1 10/01/2021 0 0 10/01/2021 0 4007 26 09/14/1988 0 10/25/2010 1 12/19/2022 0 0 12/19/2022 0 4438 27 04/14/1985 1 11/03/2010 1 10/17/2022 0 0 10/17/2022 0 4366 28 04/24/1987 0 11/03/2010 0 06/10/2023 0 0 06/10/2023 0 4602 29 06/18/1965 0 11/29/2010 0 03/02/2015 1 0 03/02/2015 2 1554 30 10/12/1982 1 12/01/2010 1 06/10/2023 0 0 06/10/2023 0 4574 31 04/12/1980 1 12/03/2010 0 06/28/2023 0 0 06/28/2023 0 4590 32 12/21/1973 0 12/14/2010 0 06/15/2022 0 0 06/15/2022 0 4201 33 07/30/1969 1 01/07/2011 1 12/01/2022 0 1 03/17/2014 1 1165 34 08/19/1982 0 01/31/2011 0 05/21/2023 0 0 05/21/2023 0 4493 35 09/13/1971 1 01/31/2011 0 02/06/2023 0 1 10/11/2016 1 2080 36 05/21/1985 1 02/14/2011 1 03/30/2023 0 0 03/30/2023 0 4427 37 06/11/1968 1 02/16/2011 0 04/11/2022 0 0 04/11/2022 0 4072 38 07/23/1989 0 02/21/2011 0 12/30/2019 0 0 12/30/2019 0 3234 39 03/03/1994 1 02/23/2011 1 06/01/2023 0 0 06/01/2023 0 4481 40 06/20/1997 1 03/04/2011 0 05/23/2023 0 0 05/23/2023 0 4463 41 06/05/1986 0 03/07/2011 0 08/30/2023 0 0 08/30/2023 0 4559 42 02/25/1966 0 03/14/2011 0 05/12/2023 0 0 05/12/2023 0 4442 43 01/25/1973 1 04/05/2011 1 06/10/2023 0 0 06/10/2023 0 4449 44 08/03/1981 1 04/06/2011 1 03/21/2022 0 0 03/21/2022 0 4002 45 08/10/1994 1 05/06/2011 1 07/13/2023 0 0 07/13/2023 0 4451 46 01/28/1981 1 05/09/2011 1 06/16/2023 0 0 06/16/2023 0 4421 47 12/06/1979 1 05/20/2011 1 08/23/2021 0 0 08/23/2021 0 3748 48 06/22/1976 1 06/15/2011 1 06/16/2023 0 0 06/16/2023 0 4384 49 08/26/1964 1 06/20/2011 0 04/12/2022 0 0 04/12/2022 0 3949 50 06/12/1967 1 06/29/2011 1 07/12/2023 0 0 07/12/2023 0 4396 51 09/26/1982 1 07/19/2011 1 05/18/2018 0 0 05/18/2018 0 2495 52 04/28/1975 1 07/22/2011 1 05/15/2023 0 0 05/15/2023 0 4315 53 10/09/1974 1 07/22/2011 1 02/06/2023 0 0 02/06/2023 0 4217 54 04/11/1975 1 07/26/2011 1 11/24/2022 0 0 11/24/2022 0 4139 55 03/14/1969 1 09/12/2011 1 09/07/2023 0 0 09/07/2023 0 4378 56 05/08/1960 1 10/10/2011 1 06/21/2023 0 0 06/21/2023 0 4272 57 11/30/1980 0 10/17/2011 0 03/16/2023 0 0 03/16/2023 0 4168 58 07/28/1962 1 10/18/2011 0 08/16/2023 0 0 08/16/2023 0 4320 59 02/25/1993 0 11/07/2011 0 03/03/2023 0 0 03/03/2023 0 4134 60 08/24/1962 1 11/14/2011 1 03/07/2022 0 0 03/07/2022 0 3766 61 04/23/1995 1 12/06/2011 0 06/26/2023 0 0 06/26/2023 0 4220 62 11/10/1985 1 12/12/2011 0 11/15/2022 0 0 11/15/2022 0 3991 63 05/23/1970 0 12/21/2011 0 12/24/2011 1 0 12/24/2011 2 3 64 04/12/1974 1 01/18/2012 0 03/18/2022 0 0 03/18/2022 0 3712 65 06/19/1987 1 01/25/2012 1 06/21/2023 0 0 06/21/2023 0 4165 66 03/05/1988 0 02/14/2012 0 08/24/2023 0 0 08/24/2023 0 4209 67 07/16/1980 0 03/05/2012 0 03/25/2022 0 0 03/25/2022 0 3672 68 02/07/1989 1 02/12/2012 1 06/08/2023 0 0 06/08/2023 0 4134 69 03/09/1982 1 03/21/2012 0 03/26/2012 1 0 03/26/2012 2 5 70 03/27/1995 1 07/02/2012 0 05/17/2017 0 0 05/17/2017 0 1780 71 05/30/1994 0 07/17/2012 0 09/14/2015 0 0 09/14/2015 0 1154 72 03/19/1969 1 07/18/2012 0 11/21/2022 0 0 11/21/2022 0 3778 73 07/01/1974 1 07/23/2012 1 06/21/2023 0 1 08/18/2012 1 26 74 02/15/1990 1 07/23/2012 1 09/12/2022 0 0 09/12/2022 0 3703 75 05/14/1983 1 07/25/2012 0 04/14/2022 0 0 04/14/2022 0 3550 76 10/18/1991 1 09/05/2012 1 02/15/2023 0 0 02/15/2023 0 3815 77 04/28/1983 1 09/18/2012 0 06/21/2023 0 0 06/21/2023 0 3928 78 04/06/1991 1 10/10/2012 0 05/09/2023 0 0 05/09/2023 0 3863 79 12/02/1977 1 10/10/2012 0 08/22/2023 0 0 08/22/2023 0 3968 80 07/28/1981 1 12/03/2012 0 06/21/2023 0 0 06/21/2023 0 3852 81 04/02/1992 1 01/16/2013 1 06/21/2023 0 0 06/21/2023 0 3808 82 06/05/1993 1 01/29/2013 1 12/09/2022 0 0 12/09/2022 0 3601 83 02/23/1990 1 02/19/2013 1 09/04/2023 0 0 09/04/2023 0 3849 84 05/03/1967 1 02/20/2013 0 03/03/2023 0 0 03/03/2023 0 3663 85 11/03/1983 1 05/17/2013 0 09/23/2021 0 0 09/23/2021 0 3051 86 03/28/1997 1 07/05/2013 0 06/02/2020 0 0 06/02/2020 0 2524 87 07/27/1992 0 07/17/2013 0 09/23/2021 0 0 09/23/2021 0 2990 88 04/02/1969 1 10/08/2013 0 07/29/2023 0 0 07/29/2023 0 3581 89 01/14/1978 0 11/18/2013 0 09/11/2019 0 0 09/11/2019 0 2123 90 07/27/1973 1 01/20/2014 0 08/23/2023 0 0 08/23/2023 0 3502 91 11/16/1996 1 01/27/2014 0 03/02/2023 0 0 03/02/2023 0 3321 92 01/03/1991 1 01/31/2014 1 05/22/2023 0 1 02/26/2018 1 1487 93 06/27/1991 1 02/07/2014 0 08/24/2023 0 0 08/24/2023 0 3485 94 04/04/1976 1 02/17/2014 0 03/29/2023 0 0 03/29/2023 0 3327 95 05/23/1985 1 02/25/2014 0 07/29/2023 0 0 07/29/2023 0 3441 96 01/07/1997 1 03/11/2014 0 07/02/2020 0 0 07/02/2020 0 2305 97 12/16/1969 0 03/19/2014 0 11/29/2022 0 0 11/29/2022 0 3177 98 10/06/1994 1 04/23/2014 1 02/09/2023 0 0 02/09/2023 0 3214 99 05/31/1986 1 04/25/2014 1 12/09/2022 0 1 04/25/2018 1 1461 100 07/09/1983 0 04/30/2014 0 11/07/2022 0 0 11/07/2022 0 3113 101 01/30/1995 1 06/06/2014 1 11/28/2022 0 0 11/28/2022 0 3097 102 11/24/1994 1 06/23/2014 0 02/27/2023 0 0 02/27/2023 0 3171 103 10/01/1976 1 10/08/2014 1 06/09/2023 0 0 06/09/2023 0 3166 104 02/03/1977 1 10/15/2014 1 12/23/2022 0 0 12/23/2022 0 2991 105 12/28/1984 1 11/03/2014 0 03/09/2023 0 0 03/09/2023 0 3048 106 12/14/1995 1 12/09/2014 1 08/24/2023 0 0 08/24/2023 0 3180 107 09/18/1995 1 12/22/2014 1 07/18/2023 0 0 07/18/2023 0 3130 108 02/17/1974 0 01/20/2015 0 02/20/2023 0 0 02/20/2023 0 2953 109 11/11/1993 0 01/27/2015 0 09/13/2023 0 0 09/13/2023 0 3151 110 06/17/1993 1 01/28/2015 1 02/17/2021 0 0 02/17/2021 0 2212 111 03/10/1971 1 01/30/2015 1 02/15/2022 0 0 02/15/2022 0 2573 112 09/20/1983 1 02/17/2015 0 05/11/2021 0 0 05/11/2021 0 2275 113 07/07/1981 0 04/01/2015 0 07/18/2023 0 0 07/18/2023 0 3030 114 02/28/1992 1 04/08/2015 1 06/23/2022 0 0 06/23/2022 0 2633 115 03/08/1990 0 04/22/2015 0 08/29/2023 0 0 08/29/2023 0 3051 116 06/27/1990 1 05/11/2015 0 03/07/2023 0 0 03/07/2023 0 2857 117 07/28/1998 1 10/14/2015 0 10/13/2022 0 0 10/13/2022 0 2556 118 09/14/1984 0 10/15/2015 0 06/17/2021 0 0 06/17/2021 0 2072 119 09/22/1980 1 12/02/2015 1 05/02/2016 0 0 05/02/2016 0 152 120 01/19/2002 1 12/09/2015 0 06/19/2017 0 0 06/19/2017 0 558 121 04/04/1969 1 02/17/2016 0 09/30/2022 0 0 09/30/2022 0 2417 122 11/05/2004 1 03/02/2016 0 09/28/2022 0 0 09/28/2022 0 2401 123 03/07/1997 1 03/08/2016 0 10/23/2017 0 0 10/23/2017 0 594 124 06/16/1977 1 04/11/2016 0 04/03/2023 0 0 04/03/2023 0 2548 125 07/18/1986 1 04/13/2016 1 05/04/2023 0 0 05/04/2023 0 2577 126 05/15/1985 1 04/18/2016 1 06/23/2021 0 0 06/23/2021 0 1892 127 07/09/1982 0 06/14/2016 0 04/05/2023 0 0 04/05/2023 0 2486 128 09/26/1983 1 06/20/2016 0 01/11/2017 0 0 01/11/2017 0 205 129 11/25/1985 0 09/14/2016 0 12/12/2016 0 0 12/12/2016 0 89 130 09/17/1964 1 09/21/2016 0 06/30/2023 0 0 06/30/2023 0 2473 131 11/26/1967 1 09/28/2016 0 05/02/2022 0 0 05/02/2022 0 2042 132 04/04/1994 1 10/10/2016 0 12/07/2022 0 0 12/07/2022 0 2249 133 12/25/1971 1 10/19/2016 1 01/09/2023 0 0 01/09/2023 0 2273 134 03/04/1985 0 11/21/2016 0 12/17/2019 1 0 12/01/2019 2 1121 135 08/22/2001 1 11/29/2016 0 03/01/2023 0 0 03/01/2023 0 2283 136 06/28/1988 1 12/13/2016 1 07/17/2023 0 0 07/17/2023 0 2407 137 03/22/1982 1 02/13/2017 0 02/18/2022 0 0 02/18/2022 0 1831 138 11/15/1990 1 02/13/2017 0 11/02/2022 0 0 11/02/2022 0 2088 139 03/25/1979 0 03/01/2017 0 02/06/2023 0 0 02/06/2023 0 2168 140 07/13/1978 0 03/21/2017 0 05/23/2023 0 0 05/23/2023 0 2254 141 03/04/1974 1 05/24/2017 1 05/10/2021 0 0 05/10/2021 0 1447 142 08/19/1982 1 06/12/2017 0 08/09/2023 0 1 02/19/2021 1 1348 143 01/14/1977 1 07/17/2017 1 11/09/2022 0 0 11/09/2022 0 1941 144 01/22/1976 1 08/24/2017 1 03/04/2019 0 0 03/04/2019 0 557 145 01/07/2001 1 08/31/2017 1 03/13/2023 0 0 03/13/2023 0 2020 146 12/02/2000 0 10/11/2017 1 01/24/2023 0 0 01/24/2023 0 1931 147 09/28/1990 0 10/17/2017 0 10/11/2021 0 0 10/11/2021 0 1455 148 02/28/1978 0 10/25/2017 1 01/19/2023 0 0 01/19/2023 0 1912 149 12/17/1996 1 11/08/2017 0 07/24/2023 0 0 07/24/2023 0 2084 150 09/11/2003 1 11/20/2017 0 07/10/2023 0 0 07/10/2023 0 2058 151 11/29/1984 1 11/21/2017 0 08/09/2022 0 0 08/09/2022 0 1722 152 10/12/1982 1 11/21/2017 1 05/16/2023 0 0 05/16/2023 0 2002 153 06/11/1979 1 11/28/2017 1 12/05/2022 0 0 12/05/2022 0 1833 154 03/14/1990 1 12/12/2017 1 12/28/2022 0 0 12/28/2022 0 1842 155 08/05/1995 1 12/12/2017 0 05/04/2023 0 0 05/04/2023 0 1969 156 02/23/1965 1 01/15/2018 0 05/27/2023 0 0 05/27/2023 0 1958 157 01/28/1980 1 01/22/2018 0 03/27/2023 0 0 03/27/2023 0 1890 158 02/28/1981 1 03/20/2018 1 09/04/2023 0 0 09/04/2023 0 1994 159 02/17/1968 1 03/30/2018 1 11/26/2022 0 0 11/26/2022 0 1702 160 02/19/1976 1 05/25/2018 1 09/05/2023 0 0 09/05/2023 0 1929 161 02/19/1987 0 05/28/2018 0 07/21/2023 0 0 07/21/2023 0 1880 162 04/19/1984 1 06/22/2018 1 07/27/2023 0 0 07/27/2023 0 1861 163 06/14/1979 1 07/24/2018 0 11/19/2022 0 0 11/19/2022 0 1579 164 03/01/1976 0 07/30/2018 0 12/13/2022 0 0 12/13/2022 0 1597 165 07/22/1975 1 08/10/2018 0 03/30/2023 0 0 03/30/2023 0 1693 166 01/16/1977 0 10/08/2018 1 10/04/2022 0 0 10/04/2022 0 1457 167 07/22/1974 1 10/08/2018 0 03/22/2021 0 0 03/22/2021 0 896 168 12/07/2001 1 10/09/2018 1 06/26/2023 1 1 06/23/2023 2 1718 169 10/28/1999 1 10/09/2018 1 05/24/2023 0 0 05/24/2023 0 1688 170 11/15/1973 1 10/10/2018 0 02/14/2023 0 0 02/14/2023 0 1588 171 04/22/1986 1 10/14/2018 1 08/30/2023 0 0 08/30/2023 0 1781 172 10/20/1979 0 11/12/2018 0 11/22/2018 1 0 11/22/2018 2 10 173 10/01/1998 1 11/26/2018 1 03/17/2023 0 0 03/17/2023 0 1572 174 05/03/1978 0 12/12/2018 0 09/05/2023 0 0 09/05/2023 0 1728 175 06/22/1995 1 01/28/2019 0 06/28/2023 0 0 06/28/2023 0 1612 176 08/13/1997 0 01/28/2019 0 04/17/2023 0 0 04/17/2023 0 1540 177 05/22/1990 1 02/26/2019 0 09/07/2022 0 0 09/07/2022 0 1289 178 12/04/1987 0 04/23/2019 0 04/13/2023 0 0 04/13/2023 0 1451 179 07/13/1987 1 04/23/2019 0 11/23/2020 0 0 11/23/2020 0 580 180 07/25/1975 1 04/26/2019 0 07/21/2023 0 0 07/21/2023 0 1547 181 10/09/1977 0 05/06/2019 0 10/24/2022 0 0 10/24/2022 0 1267 182 12/26/2000 0 05/29/2019 0 05/24/2023 0 0 05/24/2023 0 1456 183 02/01/1979 1 07/09/2019 0 05/04/2023 0 0 05/04/2023 0 1395 184 04/24/1967 0 07/25/2019 0 03/12/2021 0 0 03/12/2021 0 596 185 11/16/1988 1 08/20/2019 0 06/25/2021 0 0 06/25/2021 0 675 186 09/11/1994 0 08/30/2019 0 03/13/2023 0 0 03/13/2023 0 1291 187 12/07/1985 1 12/08/2020 0 03/07/2023 0 0 03/07/2023 0 819 188 05/22/1992 1 12/09/2020 0 04/13/2023 0 0 04/13/2023 0 855 189 01/01/1996 1 12/14/2020 1 08/25/2022 0 0 08/25/2022 0 619 ;;;; by running the program, the journal claims "invalid characters". By running the program with eventcode(cox), it works. Could you give me an help, please ? kind regards   ... View more