Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- Analytics
- /
- Stat Procs
- /
- Non parametric Cuzick test for trend in SAS

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

01-25-2018 08:04 PM

Hi,

I have used following code to obtain percentages for some cardiac procedure complications, over the period of 10 years.

proc freq data=library.CRT;

tables (died complication1 complimortality majorcompli majcomplimortality hemreqtrans) *year /chisq;

where crt51=1;

Title 'Table 2- yearwise- 0051';

run;

I got the ouput that look like this:

To test the trend I need to obtain the __p value __ ( to compare 10 counts of percentages over 10 years),by using __Cuzick test for trend in SAS.__

Is there any easy/simple way without using any macro to accomplish this in SAS? I have never used this test before.

Any help would be greatly appreciated!

Thanks,

Ashwini

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Ashwini_uci

01-26-2018 10:54 AM

If you have access to the SAS/IML language, you can use this blog post and program to get started.

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Ashwini_uci

01-26-2018 03:06 PM - edited 03-12-2018 11:45 PM

You would probably do better with the stratum adjusted Spearman rank correlation coefficient. It is hidden in proc freq as described here:

To get the p-value for your data, create a dataset with columns *Complication*, *Year*, and *Value*.

Then run the program:

```
proc freq data=myData;
table Complication * Year * Value / scores=ridit cmh1 noprint;
ods output cmh=stratSpearman;
run;
proc print data=stratSpearman noobs; where statistic=1; run;
```

(untested)

PG

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to PGStats

03-12-2018 04:46 PM

Thank you! This was helpful!

Ashwini

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to PGStats

03-12-2018 04:49 PM

Is is possible for you to post the link (that you've shared in the following message) again? For some reason, it opens the same message window.

Thanks!

Ashwini

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Ashwini_uci

03-12-2018 11:46 PM

Sorry. I corrected the link.

PG

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to PGStats

04-25-2018 05:54 PM

Thank you!