SAS macro for power calculations in stepped wedge cluster design

haoduonge — Sat, 25 Feb 2023 17:26:30 GMT

Hi all,

I calculate sample size for a stepped wedge design, follow instruction in this paper [swdpwr: A SAS macro and an R package for power calculations in stepped wedge cluster randomized trials - PubMed (nih.gov)]

Below is code in part 5.1 page 17, but get the error – please see output right after.

Can you tell how to fix it?

Thank you!

Hao

*The EPT Trial;

data ept;

input numofclusters time1 time2 time3 time4 time5;

cards;

6 0 1 1 1 1

6 0 0 1 1 1

6 0 0 0 1 1

6 0 0 0 0 1

;

run;

%swdpwr(K = 162, design = ept, family = "binomial", model = "marginal",link = "log", type = "cross-sectional", meanresponse_start = 0.05,

meanresponse_end0 = 0.049, meanresponse_end1 = 0.035, typeIerror = 0.05,alpha0 = 0.0047, alpha1 = 0.0047)

--OUTPUT

1 The SAS System 11:01 Saturday, February 25, 2023

1 %_eg_hidenotesandsource;

5 %_eg_hidenotesandsource;

WARNING: Unsupported device 'ACTIVEX' for EXCEL(EGXLSSX) destination. Using device 'ACTXIMG'.

WARNING: Apparent invocation of macro SWDPWR not resolved.

37 %swdpwr(K = 162, design = ept, family = "binomial", model = "marginal",link = "log", type = "cross-sectional", meanresponse_start = 0.05,

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

38 meanresponse_end0 = 0.049, meanresponse_end1 = 0.035, typeIerror = 0.05,alpha0 = 0.0047, alpha1 = 0.0047)

41 %_eg_hidenotesandsource;

NOTE: Writing EXCEL(EGXLSSX) file: /saswork/SAS_work9FC300000DDB_vhacdwdwhsas12.vha.med.va.gov/#LN00108

58 %_eg_hidenotesandsource;

Re: SAS macro for power calculations in stepped wedge cluster design

haoduonge — Sat, 25 Feb 2023 19:07:15 GMT

I got the file, thanks!

Re: SAS macro for power calculations in stepped wedge cluster design

ballardw — Sun, 26 Feb 2023 00:13:21 GMT

This error:

37 %swdpwr(K = 162, design = ept, family = "binomial", model = "marginal",link = "log", type = "cross-sectional", meanresponse_start = 0.05,

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

38 meanresponse_end0 = 0.049, meanresponse_end1 = 0.035, typeIerror = 0.05,alpha0 = 0.0047, alpha1 = 0.0047)

Means that the macro named SWDPWR has not been compiled in the current session. That means before you can use the macro call you have to have the code and submit the statements that start:

%macro swdpwr ( <parameters>);

and ends with

%mend;

topic SAS macro for power calculations in stepped wedge cluster design in Statistical Procedures

SAS macro for power calculations in stepped wedge cluster design

Re: SAS macro for power calculations in stepped wedge cluster design

Re: SAS macro for power calculations in stepped wedge cluster design