About Siva_Harish

Siva_Harish · ‎02-25-2021

Thank you for the explanation. In my code we didn't create any indexes eventhough I got this error because in my grouping variables one variable length is 4000 and changed length to hundreds then iam not able to see this error .

Siva_Harish · ‎02-23-2021

could you explore indexed variable mean?

Siva_Harish · ‎02-23-2021

Hi Folks, Can anyone help on below error . Tried in multiple ways : 1) options ibufsize=32767; 2)options ibufsize=32767; proc options option=ibufsize;run; ERROR: Index TEMPINDX cannot be created on file WORK.'SASTMP-000000132'n because the length of the index value (13408 bytes) is too large. The index page size (currently 32767) must be large enough to store three index values plus a small overhead structure. Reduce the length of the index value or use the IBUFSIZE= option to increase the index page size (up to a maximum of 32,767 bytes). ERROR: :Unable to create temporary index while processing summary functions.

Siva_Harish · ‎01-22-2021

When running same code separately in BASE SAS getting data but not getting in DEV, can anyone help on this.

Siva_Harish · ‎01-22-2021

This also worked for me but i want '%japan%' (including quotes) . I resolved the issue .Thank you..!!

Siva_Harish · ‎01-11-2021

%macro EM(cntry=); %let cntr = %sysfunc(compress(&cntry.)); %put cntry resolves to &cntry ; %if "&cntry."="OMAN" or "&cntry." = "CHINA" %then %let like_cntry=%nrbquote('&cntry.%'); %else %let like_cntry=%nrquote('%')||%bquote('&cntry.')||%nrquote('%') ; %put like_cntry resolves to &like_cntry.; %mend %em(cntry=japan) Hi, I want to resolve &like_cntry as '%japan%' since iam using in where clause when i was trying to resolve iam getting this output '%'||'japan'||'%' Can anyone help me on this?

Siva_Harish · ‎12-31-2020

ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: Image SASORA found but not loadable.. Please make sure Oracle environment is set correctly. Look in the install/Config doc for additional info for your platform. Other possible reasons - incomplete Oracle client install, 32/64-bit mismatch between Oracle client & SAS, incorrect Oracle client 2 The SAS System 13:10 Thursday, December 31, 2020 version(Oracle client must match the version picked during post-install process), incompatible sasora for your OS or its attribs don't permit SAS to load it. ERROR: Error in the LIBNAME statement. Hi Folks, I am getting the above error while connecting to Oracle developer through libname statement using SAS 9.4 32 bit version Followed below steps upto 2nd and stuck at 3rd point because when i look at bothpaths there is no quotation marks (attached Snapshots) Open the Windows Registry Editor: Select Start ► Run. Enter regedit in the search box. Navigate to HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\App Paths. Look for the key SAS.EXE. There are two entries under SAS.EXE. Remove the quotation marks from the beginning and end of the paths for both entries.

Siva_Harish · ‎12-03-2020

Original site validation data Current version: 9.04.01M3P062415 Expiration: 31DEC2020. Grace Period: 45 days (ending 14FEB2021). Warning Period: 45 days (ending 31MAR2021). System birthday: 28FEB2020. Operating System: W32_WKS . Product expiration dates: ---Base SAS Software 31DEC2020 ---SAS/STAT 31DEC2020 ---SAS/GRAPH 31DEC2020 ---SAS/ETS 31DEC2020 ---SAS/FSP 31DEC2020 ---SAS/OR 31DEC2020 ---SAS/AF 31DEC2020 ---SAS/IML 31DEC2020 ---SAS/QC 31DEC2020 ---SAS/SHARE 31DEC2020 ---SAS/CONNECT 31DEC2020 ---SAS/EIS 31DEC2020 ---SAS/SHARE*NET 31DEC2020 ---MDDB Server common products 31DEC2020 ---SAS/Secure 168-bit 31DEC2020 ---SAS/Secure Windows 31DEC2020 ---SAS Enterprise Guide 31DEC2020 ---OR OPT 31DEC2020 ---OR PRS 31DEC2020 ---OR IVS 31DEC2020 ---OR LSO 31DEC2020 ---SAS/ACCESS Interface to DB2 31DEC2020 ---SAS/ACCESS Interface to Oracle 31DEC2020 ---SAS/ACCESS Interface to PC Files 31DEC2020 ---SAS/ACCESS Interface to ODBC 31DEC2020 ---SAS/IML Studio 31DEC2020 ---SAS Workspace Server for Local Access 31DEC2020 ---SAS/ACCESS Interface to Netezza 31DEC2020 ---High Performance Suite 31DEC2020

Siva_Harish · ‎12-03-2020

proc sql threads noprint; connect to ODBC (dsn=&DSN. user=&USER. password=&PWD.); execute (delete from legal.m_f_tymetrix_lineitem_test where cast(date_format(Invoice_Processing_Date, '%Y%m') as signed) in (&mon_yrt.)) by odbc; execute (commit ) by odbc; disconnect from odbc; quit; When we ran the sas code we got below error

Siva_Harish · ‎12-03-2020

I want to configure My SQL odbc 5.3 driver 32 through odbc data source administrator(32-bit) .However we are not able to get in my system(above image for your reference) Any thoughts !!

Siva_Harish · ‎12-03-2020

Hello community, Iam getting below error when I was trying to connect to odbc server . Can anyone help me to fix this? Thanks in advance!!

Siva_Harish · ‎10-16-2020

Thank you soo much!! @Ksharp

Siva_Harish · ‎10-16-2020

Hi All, I have different type of data like com,.com and for some data don't have any com or .com just ended with .(dot). so, i want add '@gmail.com' to make it as valid mail address by removing dot at the end (if exists) . data have; input gh $50.; datalines; siva.harish.507.com charyawkward mankindcom sooper.12.dooper. ; run; data want; input gh $50.; datalines; siva.harish.507@gmailcom charyawkward@gmail.com mankind@gmail.com sooper12dooper@gmail.com ; run; My Code data ds; set have; sa=find(gh,"com"); bd=substr(gh,1,sa-1); sdj=compress(bd||'@gmail.com'); run;

Siva_Harish · ‎09-30-2020

Thank you!! @novinosrin

Siva_Harish · ‎09-30-2020

Hi Folks, i have data like beloow i want to replace soft in software as hard at first instance only but not in consecutive cases data have; input string $100.; datalines; He is a software and a software programmer software and a hardware ; want He is a hardware and software programmer hardware and a hardware worker

Online Status	Offline
Date Last Visited	‎04-01-2025 11:04 AM

Re: Mutliple conditions applying on multiple values based on row wise

Re: Mutliple conditions applying on multiple values based on row wise

Re: Mutliple conditions applying on multiple values based on row wise

Re: Mutliple conditions applying on multiple values based on row wise

Mutliple conditions applying on multiple values based on row wise

Re: How to get substring from a string of characters in clumsy data

Re: How to get substring from a string of characters in clumsy data

Re: How to get substring from a string of characters in clumsy data

How to get substring from a string of characters in clumsy data

How to convert comma delimited values to multiple rows when comma is p...

Re: How to get out of this WARNING(WARNING: Apparent symbolic referenc...

ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: Ima...

Re: ODBC connection error to mysqlworkbench through BaseSAS 9.4

Re: How do I increase IBUFSIZE

Re: How do I increase IBUFSIZE

How do I increase IBUFSIZE

Data is not retrieving properly in DEV

Re: How to resolve Concatenation(||) and percent,& symbols in macros

How to resolve Concatenation(||) and percent,& symbols in macros

ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: Ima...

Re: ODBC connection error to mysqlworkbench through BaseSAS 9.4

Re: ODBC connection error to mysqlworkbench through BaseSAS 9.4

Re: ODBC connection error to mysqlworkbench through BaseSAS 9.4

ODBC connection error to mysqlworkbench through BaseSAS 9.4

Re: How to make it ass valid email adrdress?

How to make it ass valid email adrdress?

Re: How to replace a substring at first instance in a string

How to replace a substring at first instance in a string