About Sanjeev

Sanjeev · ‎06-16-2015

Okay, Thank you.

Sanjeev · ‎06-15-2015

Hi Teja, This does not help. I would like to dynamically create the fiscal year - not hard code the return values. Here's how I would like to write the code: if Month(DatePart('PS_Record_DateEffective'n )) in (1,2,3) Return ToChar(Year(DatePart('PS_Record_DateEffective'n ))-1) +'-'+ ToChar(Year(DatePart('PS_Record_DateEffective'n )) else ToChar(Year(DatePart('PS_Record_DateEffective'n ))) + '-'+ToChar(Year(DatePart('PS_Record_DateEffective'n )+1) I just need a replacement for the ToChar function Sanjeev

Sanjeev · ‎06-15-2015

Hi Teja, This might help but could you send me the code itself...? As opposed to the Visual view. Thank you, Sanjeev

Sanjeev · ‎06-12-2015

In a SAS VA calculation, how can one convert an integer field to character. Say for example I'd like to build a fiscal year off a given data. I have the integer years 2013, 2014 and would like to concatenate them to be "2013-214" I'm using SAS VA 7.1

Sanjeev · ‎05-20-2015

My understanding is we're not using LDAP as this is a Windows Server 2008 R2 installation authenticating against AD. Or does LDAP always come into play?

Sanjeev · ‎05-14-2015

Hi, When trying to share a report via Email in Visual Analytics, I get the following error: E-mail could not be sent because: E-mail service error. I suspect it's because the SMTP server information has not been set. Where would one find this setting?

Sanjeev · ‎05-12-2015

I'm able to load users using the %mduimplb macro but cannot seem to add these users to the existing group titled 'Visual Analytics Users'. The error is 'The method is not directed to a repository. (The Reposid parameter is blank.) Do I need to create an external identity in Management console for the group? I did try this but still got the same error I've attached my script. Any pointers would be greatly appreciated.

Sanjeev · ‎05-11-2015

Here's how I've set it up: In the 'Accounts' tab of create new user, I definitely have it in the form domain name\userid. In the General tab, I have the users full name in the Name field. But the users still have to enter the domain name when logging into VA. Still not working....

Sanjeev · ‎05-08-2015

I'm using Windows authentication and currently my users must login by entering their userid in the form <domain name\userid>. But users are at times forgetting to enter the domain name. Is there a way to default to a given domain name so users can just login using only their userid?

Sanjeev · ‎04-01-2015

Hi Michelle, Thank you for your response. Your suggestion may be my only option. But it made me think, what about JavaScript? Could I do the following? 1) Create my own Language prompt sourced from a second data source (as you suggested). 2) Then using a JavaScript call , get the browser locale and populate the language prompt accordingly. 3) Then reference the language prompt in a calculated item. I just don't know where I can add the JavaScript. Sanjeev

Sanjeev · ‎03-31-2015

Hi, I'm building a multi-lingual report and thus far I've managed to successfully implement French and English labels using the File/Localize Report. However, I'm now trying to translate the data itself. For example, I'd like to be able to create a calculated item as follows: if (browser_local = 'EN') return DeptName_En else DeptName_Fr Is there a way to reference the browser locale from the calculated item expression window?

Sanjeev · ‎03-04-2015

Does one have to uninstall the older version of VA when moving from 6.4 to 7.1? In other words, is it an upgrade or a new install?

Sanjeev · ‎01-16-2015

We like the comments feature but would like to remove the attachments functionality as users are able to add .exe files as attachments. This has been flagged as a security threat in our organization. How can one keep the comments functionality but disallow attachments? Sanjeev

Sanjeev · ‎09-26-2014

Scenario Create a SAS dataset Load the above SAS dataset into a LASR table Create a SAS VA Exploration off the above LASR table Create some new custom hierarchies in this Exploration Add 5 new columns to the dataset created in step 1 and reload the LASR table Refresh the data in your Exploration The 5 new columns do not appear! How does one continue to use their Explorations while also picking up new columns added to the underlying LASR table? Note* Creating a new Exploration does pickup the new columns but then we lose the hierarchies created in Step 4. Sanjeev

Sanjeev · ‎09-18-2014

Hi Justin, I was hoping to solve this issue without creating a duplicate copy of the report... In other reporting tools, I've done the following: 1) Create a custom prompt based on 2 (hard coded) values: English and French 2) Then using an expression, dynamically control which column to use. ie. if (parameter.Language = 'English') Then Month_EN Else Month_FR Can VA do something like this? Sanjeev

Online Status	Offline
Date Last Visited	‎09-01-2015 07:12 AM

Re: Converting integer to character

Re: Converting integer to character

Re: Converting integer to character

Converting integer to character

Re: SAS Visual Analytics login page

Email functionality in VA

Loading users using macro %mduimplb

Re: SAS Visual Analytics login page

SAS Visual Analytics login page

Re: Browser locale

Browser locale

Re: Converting integer to character

Re: Converting integer to character

Re: Converting integer to character

Converting integer to character

Re: SAS Visual Analytics login page

Email functionality in VA

Loading users using macro %mduimplb

Re: SAS Visual Analytics login page

SAS Visual Analytics login page

Re: Browser locale

Browser locale

Question on moving from SAS VA 6.4 to 7.1

SAS VA - Disallowing attachments in comments

Adding new columns to a LASR table

Re: Bilingual Report