I'm trying to get this if then do statement to work with a lookup macro.  Does the macro have to be in multiple places throughout this data step or can I just use it one time? And if so, where does it go? I assume it goes where I have them, but then I don't get all columns after the macro does a lookup of the id and dttm so I'm wondering if the data step is in the order it should be when a macro is being used in an if then do statement. DATA work.wf_mcd work.wf_mcd_user work.wf_mci (KEEP=id_key) ; SET mcd.asign; dts_tm = put(cats(userid, "_", put(datepart(dttm), yymmddn8.)), $mdm_rda_dts_team.); if dts_tm in ("MCD") THEN DO; OUTPUT work.wf_mcd; IF PUT(userid, $mcd_wq_list.) ^= "#" THEN OUTPUT work.wf_mcd_user; END; dts_tm = put(cats(userid, "_", put(datepart(dttm), yymmddn8.)), $mdm_rda_dts_team.); if dts_tm =: 'MCI' THEN OUTPUT work.wf_mci; %dts_lookup(userid, dttm); RUN; ... View more

Is anyone utilizing a public dataset or any dataset with health data to teach undergraduate students? Has anyone already created assignment/project that entails analyzing health data? I ask because would like to collaborate on creating a basic health data analysis assignment/project using SAS Studio. ... View more

Hi,    I have a question about what CV should be entered in CV or PairCVs option in Pairmeans of Power Procedure for lognormal data. See the SAS documentation for CV below.   CV=number-list specifies the coefficient of variation that is assumed to be common to both members of a pair. The coefficient of variation is defined as the ratio of the standard deviation to the mean on the original data scale. You can use this option only with DIST=LOGNORMAL. For information about specifying the number-list, see the section Specifying Value Lists in Analysis Statements.   This sounds like, when data are assumed lognormally distributed, CVs entered should be STD/mean, and STD and Mean are calculated from data in the original scale.   However, in SAS/STAT® 13.1 User’s Guide The POWER Procedure,  Page 6445-6446 If CV=SD/Mean, where SD and Mean are calculated from data in original scale, how the σ* (SD from log-transformed data) can be derived from sqrt(log(CV2+1))?   Instead, if CV is calculated from CV=sqrt(exp(SDlog2)-1) where SDlog is the SD from natural Log scale data, then it makes sense that σ* (SDlog) can be derived by back-calculating. However, the documentation clearly indicates the inputted CV is from data in original scale.   This confuses me. Also have a similar question about the correlation, as the documentation states to enter "correlation of the original untransformed pairs (Y1; Y2)".   Thanks, ... View more

Hi Folks,  We have a VBA Excel macro that's been in use in our enterprise for at least 5-10 years. The macro makes use of the SASWorkspaceManager 1.1 Type Library to connect to our Workspace Server to extract SAS data into Excel. We have some beta testers of MS Office 365 who are getting errors during the SAS connection step from the same VBA macro. The chief difference is that o365 is running as a 64bit app on Win11(x64) in the beta test environment while previously it runs in 32bit MS Office Excel installed on Win10(x64). The error message is not very helpful. Something like, "Object not registered." It is raised in the VBA code with the first reference to SASWorkspaceManager during an object declaration. I'm wondering if this a bitwise issue between o365 and the SAS library. The users are able to connect to the SAS Metadata Server without issue from the SAS Add-in in o365 Excel. ... View more