Hi! I think you can use my earlier suggestion, if I understand you correct 🙂 You can descide if you want to have 0/1 in both variables by changing the expression. //Fredrik     "You can create two new calculated measures:   occupied: ============= IF occupancy = '1' then  return 1 ELSE 0   nonoccupied: ============= IF occupancy = '0' then  return 1 ELSE 0   Keep default aggregation (SUM)." ... View more

I had this issue (using v 7.4) and to solve it I created a data variable for the last day of the week.  So in visualizations I can show both (or either) the date or the "week end date" for summaries. I could not find a way to set up weeks as summary periods for doing any periodic comparisons. ... View more

Hi! https://lmgtfy.com/?q=sas+viya+connect+to+hadoop   https://lmgtfy.com/?q=sas+viya+load+data+from+enterprise+guide   😉   //Fredrik ... View more

I thought it would work by selecting then check box "All other" ? //Fredrik ... View more

This sounds like it's exactly what I need! Thank you! ... View more

Hi Fredrik   Thanks for your reply!   It is a great alternative that you suggest, and I will go with that for now. I cross my fingers that someone knows how to do it in "my way".    ... View more

Hi! Sessions might help you, I have successfully used them in some of my reports 🙂   https://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/sessions.html   //Fredrik ... View more

It depends on the setup that you have for authentication, but your SAS Connection profile will have the answer.   Switch any one user SAS Connection Profile from Use Integrated Windows Authentication to Save Login in profile. Put in the user's login with or without the domain prefix, depending on your setup and save the profile.   The end-user should get a prompt once when they open EG and their credentials should stay saved until they change their password. ... View more

So you likely shouldn't be doing your data manipulations with VA, there's another tool or the Prep side to clean up and manipulate your data. Make sure your date is a SAS date or numeric with a date format. Then duplicate it three times and rename each one to Year Month Day. Then format each one to the respective format. And then you can build automatic filters and don't need to add any labels anywhere. ... View more

Hi,   Could someone provide me a solution for this in SAS DI as this is a project requirement which would help me ... View more

I have solved it by using a calculated dimension for time. I have a button bar with the different possible time dimensions (day, month, quarter and year) I have assigned a parameter to the button bar.   In my graph objects i use this calculated dimension as category. On the objects I have created a dynamic filter that uses the parameter to decide which time period to show.   In my data i have a flag for last day of month, last day of quarter and last day of year. I use these in the dynamic filter   //Fredrik ... View more