I want to use an estimated effect size (like Cohen’s d) to do the sample size calculation. To perform the sample size calculation using a range of effect sizes, for example, 0.2, 0.3, 0.4, 0.5. Could you please let me know what is the code for that?  Thanks   ... View more

I want to find out how many distinct individuals have clocked in per day in VA.   Imagine a person clocks in every time they enter a building. I don't care if they enter building multiply times a day, but want to know how many unique individuals clock in per day. Data I have is f.i. like this:     Monday  John Monday  John Monday  Michael Monday  Jake Monday  Bob Tuesday Bob Tuesday Jake Tuesday Michael Tuesday John Wednesday Bob Wednesday Bob Wednesday Jake Thursday Charles Thursday Jacob Thursday John Thursday Bob Thursday Bob Friday  Charles Friday  John Friday  Charles Friday  Bob Friday  Jake Friday  John   If I use just a 'Count' on the "Name" then I get 23, which is not what I'm after, since this counts all duplicates during a day. If I use 'Distinct' then I get 6, which is not what I'm after either, since it won't separate days.   I want a total Distinct count per day, so the number I'm after from this example is 18.  So I want a dashboard to saying that number 18, fairly simple to achieve in Excel but I can't figure out how to do this in VA.   Basically I need a 'Distinct' count for all values in "Monday" then a 'Distinct' count for all values in "Tuesday" and so on. Then I need to summarize the days to get to the total for the week. Is this possible to achieve directly in VA?   Or would I need to prep data and create a separate column for each day? ... View more

In this short post we’ll quickly identify some levers and considerations for bolstering the Viya end user experience. It’s important to note this is not an exhaustive list of levers and considerations AND that SAS Viya itself (server and client-side) is constantly evolving. As such, what may be true/accurate today may not be so, a few months down the line. So the bottom line is to always consult the latest documentation, posts and technical support notes on a regular basis.   ... View more

Hi, I would like to deduplicate the dataset 'have' with the constraint that for each 'group' there will be an observation for each 'id' and that across ids within 'group' all the 'x' values are different. My dataset want should be like this: group  id x a 2 1 a 3 2 a 4 3 b 2 1 b 3 3 b 4 4 b 5 2   I would appreciate very much a range of techniques.   thank you very much in advance   ... View more

https://communities.sas.com/t5/SAS-Programming/Overlapping-drugs/m-p/930264#M365992 My query is in continuation of the above question which I posted few weeks back, I was unable to continue the same topic as it was closed. How can I know the difference between 'SGA_START' and 'start'? I am trying to merge the dataset 'want' with 'SGA2', how ever I cannot identifying the difference/no. of days between SGA_START and start dates. Can someone please help me with the code.   Thank you ... View more