topic Re: macros in ODS and Base Reporting

macros

Pallavi_B — Mon, 24 Dec 2018 15:08:15 GMT

Hello, I am new to SAS. I have outcome variable "titer" grouping variable "treatment" how I can use macros to perform independent sample's t test (Mann-Whitney U test)?? I have no idea of macros. so if possible please give explaination

Re: macros

PaigeMiller — Mon, 24 Dec 2018 15:17:18 GMT

I don't think macros are needed here. SAS Documentation has examples of performing this test, for example: https://documentation.sas.com/?docsetId=statug&docsetTarget=statug_power_examples16.htm&docsetVersion=15.1&locale=en

Re: macros

Pallavi_B — Mon, 24 Dec 2018 15:57:47 GMT

Even though we have some more methods, I need macros. Because I need to
check for normality and have to do corresponding parametric or non
parametric tests.

Re: macros

Cynthia_sas — Mon, 24 Dec 2018 17:22:38 GMT

Hi:
Before you can write a SAS macro program, you need to have working code. The SAS Macro facility is ONLY a text generator. All the Macro facility does is write code for you. So the Macro facility in and of itself will NOT "check for normality ...and do corresponding parametric or non-parametric tests" -- SAS procedures do that work. If you wanted to repeat the same SAS procedure 100 times, changing the variable every time, THEN you would take your working SAS program that generates the results for 1 variable and you would "macro-ize" the program to work for any variable name you pass in. The Macro facility would generate the code for you, switching the variable name and the regular SAS processor would compile and execute the code.

Do you have a working SAS program? It is extremely hard to do anything with the Macro facility if you don't have a working program to start with.

But, here's a paper that shows the overall concepts of the Macro facility:

https://support.sas.com/resources/papers/proceedings13/120-2013.pdf

Hope this helps,
Cynthia

Re: macros

Pallavi_B — Tue, 25 Dec 2018 04:09:47 GMT

thank you