Hi SAS Community! The aim id to calculate the sample size for average bioequivalence trial. I would like to replicate the below example from "Sample Size Calculations in Clinical Research" by Chow and Shao (3rd edition).  Below you can see the formula that is used as well.     So, with the SD=0.4, delta = 0.05, limit = 0.223, alpha = 0.05 and 80% power I am using the below code:   proc power; twosamplemeans test=equiv_diff DIST=NORMAL lower = -0.223 upper = 0.223 meandiff = 0.05 stddev = 0.4 npergroup = . power = 0.8; run;   But I am getting 69 subjects required, not 21 (as in the book, or 24 from the table approximation)   Is there a different formula SAS is using? Or should I use a different procedure? Sorry if I am missing something, just trying to get my head around that.   Thank you Guys, Agnieszka     ... View more

When submitting a relatively large (>20k lines) SAS program in SAS Studio we are getting the 403 below     We are also unable to upload the file to SAS Content, or the SAS Server directly using the file explorer (just hangs) SYSVLONG=V.04.00M0P030625   Product name: SAS® Studio (Analyst) Version: Stable 2025.03 Release: 20250506.1746542786204   Any hints / suggestions? ... View more

Good morning everyone, I'm using SAS Visual Analytics and unfortunately, I can't figure out how to perform a certain operation. Let me describe the situation in general terms: I have a report with two sections: Section 1 and Section 2. Section 1 contains two graphs, Graph 1 and Graph 2, while Section 2 contains a crosstab. All objects are based on the same data source. The two graphs differ only in the assigned Category field (in one case it's A, in the other it's B). Graph 1 filters Graph 2 through an action, and Graph 2 contains a link to the crosstab. In view mode, when I follow the link, the crosstab only receives the selection made on Graph 2, but not the one made on Graph 1 (even though Graph 1 correctly filtered Graph 2). In edit mode, the filter from Graph 1 to Graph 2 doesn't work (an error appears: "Unable to find a column referenced by the query") — however, if I double-click on the bar that appears below the error message, I'm correctly redirected to the desired section with all filters applied, including the selection from Graph 1. If I add Category A as a hidden data element in Graph 2, everything works correctly, but the initial display of Graph 2 changes — and I'd prefer to keep it unchanged. How can I fix this? I have another report that appears to be identical, where everything seems to work without needing hidden elements — but perhaps I’ve missed some detail that allows it to function correctly. ... View more

I have a data set of ~10K hospital visits. Each observation has about 60 variables describing the patient. Below is a mock sample of a small part of the data set. Hosp id AI_Pace PSR cPWR RTG BOARD A 1 1 3       A 2 1       2 B 1 1 2 2 2   B 2 2 1 1 1 3 B 3 3         B 4 2   1   1 B 5           B 6 2         C 1   2 3 2   C 2         2 C 3 3       1 C 4 3     3   C 5           C 6 1 1 1   3   I'd like to transform this data into a set of transactions, almost as if every patient were a consumer at a store. Below is the data set above transformed into what I'd like. Please note that if a patient doesn't have any columns marked, then they are deleted. Thanks!!!!! Andrew Hosp id           A 1 AI_PACE = 1 PSR=3       A 2 AI_PACE = 1 BOARD = 2       B 1 AI_PACE = 1 PSR = 2 cPWR = 2 RTG = 2   B 2 AI_PACE = 2 PSR = 1 cPWR = 1 RTG = 1 BOARD = 3 B 3 AI_PACE = 3         B 4 AI_PACE = 2 cPWR = 1 BOARD = 1     B 6 AI_PACE = 2         C 1 PSR = 2 cPWR = 3 RTG = 2     C 2 BOARD =2         C 3 AI_PACE = 3 BOARD = 1       C 4 AI_PACE = 3 RTG = 3       C 6 AI_PACE = 1 PSR = 1 cPWR = 1 BOARD = 3   ... View more

Hi experts,   I need to deploy SAS Viya on-prem on OpenShift with no Internet access at all (dark site) using the SAS Deployment Operator. Looking at https://documentation.sas.com/doc/en/sasadmincdc/v_056/dplyml0phy0dkr/p0nid9gu3x2cvln1pzpcxa68tpom.htm#p012wq5dhcqbx8n12abyqe25m4nu at the --repository-warehouse parameter and I see it is required for a dark site deployment but no further info is available.   I am in contact with SAS Technical Support but I wonder if there is anyone out there who actually managed to install SAS Viya with this configuration and can share their input about this --repository-warehouse parameter and how they used it.   Thanks. ... View more