About sandeep_reddy

sandeep_reddy · ‎01-13-2017

Dear Team, I have created one stored process and i am trying to integrate with SAS web server. I have followed some sample steps in the following URL https://libraries.io/github/Boemska/sas-hot-editor. Requirement is , a user needs to select the path of a .csv file and a column from csv file needs to be updated in a database table. Thanks & Regards, Sandeep

sandeep_reddy · ‎12-23-2016

Hi SASKiwi , Perfectly worked now. Thank You Very Much. Thanks & Regards, Sandeep.o

sandeep_reddy · ‎12-23-2016

Hi, I am getting an error as "The server was unable to initialize the service the error message was "Not Licensed" ". But we have updated license files and validated in Data Management studio. Validation was successful.But the above error i am getting ,when i imported a job to Data management server and testing it.Please advice. Thanks & Regards, Sandeep

sandeep_reddy · ‎11-12-2014

Hi Teja, When you start creating a report, in the left side we have Objects Tab .You have to select first Crosstab/list tab/graphs. On top of it you can see drop controls here, there you have drag and drop -drop down list from objects tab. I am currently using sas VA 6.3 Version. Representations may change from version to version. Thanks, sandeep.

sandeep_reddy · ‎10-13-2014

Hi Anna, we are using Visual Analtics 6.3 version. I have a requirement like, I need to display top 50 customers. My, In memory dataset contains a Rank Column which has all the Rank values .But I am unable to create a filter based on Rank column because when i am selecting filter ,Rank column is not displaying. Kindly Let me know how i could resolve this issue. Many Thanks In Advance.

sandeep_reddy · ‎04-10-2014

hi all, I am working with sas data management studio.In that i was using update node in one of my job.My target node is having 65 lakh records and my transaction is having 74000 records. when i execute update node with following query update master a set a.action_status=( select b.action_status from trans b where a.cust_id=b.cust_id) when i ran the update node it is running for 1 1/2 day...and it is still running for the second day also.. can anyone help me on this and also share your views to increase the performance.. MANY THANKS IN ADVANCE.

sandeep_reddy · ‎03-18-2014

hi skillman, can you kindly suggest me how to increase cluster memory morethan 4GB.my data management server is running on 64 bit mode.I am unable to give morethan 2047 mb.When i give it to 4000mb it is prompting to enter integer 2 to 2047 .I checked in the dmserver.cfg file also.there i find cluster/bytes. your inputs are highly appreciated. many thanks in advance.

sandeep_reddy · ‎03-18-2014

skillman, I am trying to insert into oracle database and inserting into separate table.can i set anywhere options like set define off and set scan off.

sandeep_reddy · ‎03-17-2014

skillman, I am getting an error while inserting match codes into database output table.The error was 11: Data Access Plugin - Max. ODBC error count (500) exceeded. Last error:.My source data is having 92 lakhg records....when i try to inser match codes it is inserting only 111 records .Kindly help me on this. Many thanks in advance.

sandeep_reddy · ‎03-11-2014

skillman, I tried it by the following way.I created a definition and selected in substring.It is working fine in sas data management studio.But while running the same job in sas data management server it is showing following error as |error|DF001|0;|2;Blue fusion error -801:invalid definition name :address>this definition may not exist in your qkb.

sandeep_reddy · ‎03-06-2014

I have a fields named ADDRESS, which contains varchar data of 120 bytes(i.e. Sample is shown below). I need to standardize a portion of string, for example: Address #39/1, Electronic City, St. Green Glen, Bangalore I need to convert St. to Street and rest all will be same ( #39/1, Electronic City, Street Green Glen, Bangalore ) Kindly help me on this.

sandeep_reddy · ‎03-05-2014

Skillman, Thanks for your reply.It is working fine now.I have one question regarding address standardization. I have a fields named ADDRESS, which contains varchar data of 120 bytes(i.e. Sample is shown below). I need to standardize a portion of string, for example: Address #39/1, Electronic City, St. Green Glen, Bangalore I need to convert St. to Street and rest all will be same ( #39/1, Electronic City, Street Green Glen, Bangalore ) Kindly help me on this.

sandeep_reddy · ‎03-03-2014

HI shawn, Thanks for your reply.I tried it what you had suggested. But it is not working as you said..it is fetching again the exact match only. I tried with the following process. first i created an output having matchcodes on names by using a data job.Then i used external data provider->match codes node->sql lookup.In sql lookup i had given the condition CUST_NAME_MATCHCODE=CUST_NAME_MATCHCODE. I used the same definitions and same sensitivity. Even after trying this it is giving exact matchcode for given input custopmer name. Kindly help me on this.. Many thanks in advance

sandeep_reddy · ‎03-03-2014

Hi skillman, I am working with sas data management studio.I got a requirement like this.Thge records which are matching with given input need to be shown in output.For example if i just enter smith as input it should retrieve the records having smith,smithy,smithi,smit.I used external data provider and sql lookup to look in the database table.Kindly anyone help on this or this can be done in any way. Your help is highly appreciated. Thanks in advance

sandeep_reddy · ‎02-28-2014

Hi All, I am working with sas data management studio.I got a requirement like this.Thge records which are matching with given input need to be shown in output.For example if i just enter smith as input it should retrieve the records having smith,smithy,smithi,smit.I used external data provider and sql lookup to look in the database table.Kindly anyone help on this or this can be done in any way. Your help is highly appreciated. Thanks in advance.

Online Status	Offline
Date Last Visited	‎04-21-2025 02:47 AM

How to use encrypt=true option in JDBC URL in SAS JVM

HTTP Header Errors on port 8443

How to update ExternalIdentifier of a user in sas Management console t...

SAS WebApplication Server DB connections

SAS FRAUD MANAGEMENT V61

Re: Solr version upgrade from 5.5.5 to 8.6.2

Solr version upgrade from 5.5.5 to 8.6.2

Re: gemfire error - Error creating bean with name 'sas_gemfire_cache'

Solr with SSL

Re: Starting SAS VA services through code

Re: Polish and share reports in SAS Visual Analytics 7.1

Re: Polish and share reports in SAS Visual Analytics 7.1

Re: gemfire error - Error creating bean with name 'sas_gemfire_cache'

Re: WEB Server Upgrade from 2.2 to 2.4

SAS JVM 8_1 and 12_1 monitoring

SAS Web URL Login Check

SAS Web infra structure DATA server monitoring tool

Re: Polish and share reports in SAS Visual Analytics 7.1

Stored process integration with web server

Re: dataflux data management studio

dataflux data management studio

Re: About Drop-Down list

Re: Polish and share reports in SAS Visual Analytics 7.1

how to improve update performance

Re: standardization through Data flux studio

Re: standardization through Data flux studio

Re: standardization through Data flux studio

Re: standardization through Data flux studio

standardization through Data flux studio

Re: In Data management studio, SQL lookup fetches exact match but how ...

Re: In Data management studio, SQL lookup fetches exact match but how ...

Re: SCHEDULING SAS DATA MANAGEMENT STUDIO JOBS

external data provider