About AbhiD

AbhiD · ‎04-18-2019

Hi, Is there a way where we can update file reference of all the codes in an Enterprise Guide project at once.. I know we can do a single code at a time but as my Enterprise Guide project has a lot of codes hence want to know if there is a process for blanket update all file locations for all sas codes in an EG Project.

AbhiD · ‎08-26-2016

When u import the datasource.. at that time is it not possible to rename the variables; once u have renamed then use them in ur analysis objects... if you save this report i guess it won't change even if the data source is refreshed. Rgds, Abhi

AbhiD · ‎08-26-2016

if we just want to get the report to export data into excel we can open the report in excel using sas microsoft add-in. and them export whatever section of data is required to be extracted from the report. just a work around till the functionality is built into. Rgds, Abhi

AbhiD · ‎07-27-2016

Hi, just a small suggestion , when comparing text variable making them into same case, this will help resolve mis-match due to case inconsistency in the data.. Hope that helps Rgds, Abhi

AbhiD · ‎07-27-2016

May be it was covered earlier and i am not aware of but i wish these topics are covered. - HpRisk case study - Case study showing VA reporting where social media data is live streamed and analytics is shown over it. - Demo on SAS handling big data in a LASR environment.

AbhiD · ‎05-09-2016

Hi All, I have a LASR table which contains columns as below ID TranDate Flg_1 Val_1 1 31-Dec-15 AA 100 1 31-Jan-15 BB 200 2 31-Dec-15 DD 111 2 31-Jan-15 AA 2345 So i want to create calculated variables based on the comparision of values of Flg_1 for the 2 TranDate selected by the users for a particular ID (Something similar i can do with a merge using By variable as ID) Currently i am doing it in SAS and loading the results back to LASR server, but i wish to have this dynamic based on the TranDate's that the user of the report select. Let me know if there is any way to achive this requirement. SAS VA Version : 7.1 Rgds, Abhi

AbhiD · ‎01-18-2016

Hi, Can you put comma seperated values in a macro and use that as a parameter which can be mapped to the publish to email transform and then this can used as a macro variable in the email body. Rgds, Abhi

AbhiD · ‎01-18-2016

Hi, Please check there is a similar post about logged in user info for VA https://communities.sas.com/t5/SAS-Visual-Analytics/Determine-the-current-user-in-Visual-Analytics/td-p/145209 Rgds, Abhi

AbhiD · ‎11-25-2015

Hi, What is it that your are trying to import via the SPK file. Rgds, Abhi

AbhiD · ‎11-25-2015

Hi, Please could you elobrate ur issue with an example Rgds, Abhi

AbhiD · ‎11-25-2015

In ur macro call please could you pass the dataset name %check(dsName= <<YOUR DATASET NAME HERE LIBRARY.DATASETNAME)>> );

AbhiD · ‎11-25-2015

can you paste what macro call u used and the log for the same

AbhiD · ‎11-25-2015

Yes it works if you would have ran it you would have known Rgds, Abhi

AbhiD · ‎11-25-2015

%macro check(dsName = ); %let dsid = %sysfunc(open(&dsName, IS)); %if &DSID = 0 %then %put %sysfunc(sysmsg()); %let nlobs = %sysfunc(attrn(&dsid,NLOBS)); %put No of Observation in dataset %trim(&dsName) : %trim(&nlobs); %let rc = %sysfunc(close(&dsid)); %mend; %check(dsName = );

AbhiD · ‎11-25-2015

Please check the link pasted http://www2.sas.com/proceedings/sugi26/p095-26.pdf

Online Status	Offline
Date Last Visited	‎10-31-2020 12:39 PM

Updating code references in EG Project

Re: Renaming Data in VA

Re: Export to Excel in SAS Visual Analytics Modern look (HTML5)

Re: Adding quotes to a Macro Variable

Re: What topics would you like to see covered during SAS Global Forum ...

How to derive variables across rows based on a Key column

Re: Send ID's of dataset processed in an email

Re: Identify the logged user

Re: Error While Importing SPK package to SAS Management Console

Re: macro date format for automation

Re: Irritating warning in Proc FCMP

Re: Adding Leading Blank to specific Observation

Re: Identify the logged user

Re: Error While Importing SPK package to SAS Management Console

Re: SAS DATES

Updating code references in EG Project

Re: Renaming Data in VA

Re: Export to Excel in SAS Visual Analytics Modern look (HTML5)

Re: Adding quotes to a Macro Variable

Re: What topics would you like to see covered during SAS Global Forum ...

How to derive variables across rows based on a Key column

Re: Send ID's of dataset processed in an email

Re: Identify the logged user

Re: Error While Importing SPK package to SAS Management Console

Re: macro date format for automation

Re: Determine and return the number of physical observations in the sp...

Re: Determine and return the number of physical observations in the sp...

Re: Determine and return the number of physical observations in the sp...

Re: Determine and return the number of physical observations in the sp...

Re: Determine and return the number of physical observations in the sp...

SAS Analytics Explorers