cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
gjanuary
‎06-30-2025
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

How to create a Date field for a Previous Date in Visual Analytics usi...

by Calcite | Level 5 in SAS Visual Analytics
‎06-06-2024 07:26 PM
‎06-06-2024 07:26 PM
Create Custom Date Items to be used for Display or Calculations. This example will create three Items. A Date for the Previous Monday and a Date for the Previous Friday. These will be used to aggregate data between those dates. The aggregation uses the two custom dates and a date column from your data that can be used for aggregation. This is a basic way of doing a one week lookback without using filters or creating parameters. Using the Following you can copy paste into a new calculated item to create a static Data Element for The previous Monday's date.  TreatAs(_Date_, ( ( ( TreatAs(_Number_, DatePart(Now())) - DayOfWeek(DatePart(Now())) ) + 2 ) - 7 )) This code will create a date for the previous Friday. TreatAs(_Date_, ( ( ( ( TreatAs(_Number_, DatePart(Now())) - DayOfWeek(DatePart(Now())) ) + 2 ) - 7 ) + 4 )) TreatAs(_Date_, ( ( ( ( TreatAs(_Number_, DatePart(Now())) - DayOfWeek(DatePart(Now())) ) + 2 ) - 7 ) + 4 )) Used together to create a custom calculation In the following code date_str is a column from the data loaded to VA. IF ( TreatAs(_Number_, TreatAs(_Number_, 'DATE_STR'n)) BetweenInclusive(TreatAs(_Number_, 'PrevMonday'n), TreatAs( _Number_, 'PrevFriday'n)) ) RETURN 'CompletedAppointments'n ELSE 0 IF ( TreatAs(_Number_, TreatAs(_Number_, 'DATE_STR'n)) BetweenInclusive(TreatAs(_Number_, 'PrevMonday'n), TreatAs( _Number_, 'PrevFriday'n)) ) RETURN 'CompletedAppointments'n ELSE 0 ... View more

SAS DI Studio 9.04 with SAS Studio Enterprise 3.6 Security question

by Calcite | Level 5 in Administration and Deployment
‎08-22-2018 01:16 PM
‎08-22-2018 01:16 PM
I currently have five separate databases that require completely different security. On the meta-data side of things I have security handled. My problem is with SAS Studio and its connection to my metadata server. Its not just applying the security I've setup in management console in metadata its also using security from the metadata physical server. The test user that I'm using had to be added to a security group on the physical windows server in order to even access the application. I guess I should add that the application is being accessed via browser. How is windows security overriding security from metadata. What does windows security have to do with access to SAS Studio Enterprise. I've already taken the steps in management console so that the users can't see the physical server drives in SAS Studio, but that wouldn't stop a savvy user from creating their own shortcut to a physical drive. Are we left with having to manage windows security as well as meta data security if we desire to have users using SAS Studio Enterprise. I must be missing something. If not any suggestions on windows server security groups and permissions. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-30-2025 06:48 PM
Group Hubs for gjanuary
View All
Quick links