Hi all,   Anyone know how to do the mann-kendall trend significant test in SAS?  I could only do the following code to get the Kendall's tau coefficient, but I don't know how to test thesignificant.  proc corr data=input KENDALL noprint OUTK=output; Var prep; With year; by station; Run;   And If I use  proc corr data=input KENDALL; Var prep; With year; by station; Run; It seems like there has a number under the kendall's tau in the output is p-value, but I don't know how to get the results in an dataset, not only print in SAS.   Thanks SO much!   Best, Hua ... View more

Hello all,   I tried to export the data by group to text file (.txt), but still have some trouble to do so. Hope someone in the SAS community groups can help. I would greatly appreciate it! Thanks a lot! I have a dataset like this: stn time var1 var2 var3 1 1       1 2       1 3       1 4       1 5       2 1       2 2       2 3       2 4       2 5       I want to export the data by stn, and named input1.txt. And inside each file, drop stn, year and the header (the first line). What I want to get in each file is only the several varibles without header.   Thanks a lot!   Regards, Hua ... View more

Hello all,   I tried to find the sum of continous non-missing value in a dataset by group (stn and year), but still have some trouble to do so. I hope someone in the SAS community groups can help. Thanks a lot! I have a dataset looks like this: stn year month day var 1 2000 12 28 0.2 1 2000 12 29 0.5 1 2000 12 30 . 1 2000 12 31 2 1 2001 1 1 0.2 1 2001 1 2 1 1 2001 1 3 . 2 2000 12 28 0.6 2 2000 12 29 . 2 2000 12 30 . 2 2000 12 31 . 2 2001 1 1 0 2 2001 1 2 1.5 2 2001 1 3 3   And I want to get  the following: stn year month day var sum 1 2000 12 28 0.2 0.7 1 2000 12 29 0.5 0.7 1 2000 12 30 .   1 2000 12 31 2 2 1 2001 1 1 0.2 1.2 1 2001 1 2 1 1.2 1 2001 1 3 .   2 2000 12 28 0.6 0.6 2 2000 12 29 .   2 2000 12 30 .   2 2000 12 31 .   2 2001 1 1 0 4.5 2 2001 1 2 1.5 4.5 2 2001 1 3 3 4.5 If any one can assist in this problem I would greatly appreciate it!   Thank you and hope for your reply!   Best, Hua ... View more