BookmarkSubscribeRSS Feed
sandeep_reddy
Quartz | Level 8

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.

8 REPLIES 8
skillman
SAS Employee

You can parse the data using the parsing node then use the standardization node with the English (India) QKB and the ENIND Address Extension Standards definition.

-shawn

sandeep_reddy
Quartz | Level 8

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.

DaveR_SAS
SAS Employee

Does your server have access to the appropriate QKB? As explained in the Prereq section of this topic:

Deploying Jobs to a Data Management Server

skillman
SAS Employee

You may wish to have a centralized location for the QKB that both the client and server can access, rather than having two distinct installations of the QKB (which can lead to versioning issues). Check that the QKB on the server is the same QKB version that the client uses.

sandeep_reddy
Quartz | Level 8

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.

skillman
SAS Employee

What type of database are you writing to? Are you inserting records into the same table that you are reading data in the data input step? That could cause your issue. Try inserting data into a separate table to see if that resolves table locking errors. Also, can you submit the whole log file?

sandeep_reddy
Quartz | Level 8


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
Quartz | Level 8


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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 8 replies
  • 2680 views
  • 4 likes
  • 3 in conversation