About helannivas88

helannivas88 · ‎05-27-2020

Thanks Kurt. Its due to Java library . SAS session points to different JRE and command line session points to different Java.

helannivas88 · ‎05-24-2020

Hi, Did anybody try calling DB2 clpplus from SAS Client tools via Unix Command (X (or) %sysexec?? Currently SAS are installed in Linux servers and the DB2 servers are catalogued in our DB2 drivers installed in SAS machines. When I tried launching clpplus from Command line , I can able to successfully connect to DB2 database. But when I launch clpplus from SAS Clients (EG) , Im trying the below failure [jcc][t4][2030][11211][4.25.23] A communication error occurred during operations on the connection's underlying socket, socket input stream, or socket output stream. Error location: Reply.fill() - socketInputStream.read (-1). Message: Received fatal alert: handshake_failure. ERRORCODE=-4499, SQLSTATE=08001 DB250018E: A connection attempt during the CLPPlus environment start sequence failed. The CLPPlus environment failed to start. I don't really think the above issue is to deal with any SAS programming. Do anybody have any idea on the issue please. I'm struggling to resolve this for the past few months. Thanks

helannivas88 · ‎03-18-2020

Please find the sas code proc sql; connect to DB2 as SRC (datasrc=&Datasrc AUTHDOMAIN="ABC") ; create table WORK.TEMP as select Upcase(trim(left(MSG_DESC))) as MSG_DESC, MONOTONIC() as ROW_NUM, input("&SYSDATE9 &SYSTIME",DATETIME25.6) as LOADTM format=DATETIME25.6 informat=DATETIME25.6 from ( select * from connection to SRC ( select * from &Schema..TABLENAME ) ); disconnect from SRC; quit; proc append data=WORK.TEMP base=STG.STG_TAB ( BULKLOAD=YES BL_METHOD=CLILOAD ); run;

helannivas88 · ‎03-18-2020

Thanks Ksharp for the info. But we are using proc sql to connect to the data source as like below proc sql; connect to DB2 (datasrc=&Datasrc AUTHDOMAIN="ABC") ; create table WORK.TEMP_ABC as select upcase(trim(kleft(ColA))) as ColA ); disconnect from DB2; quit; We dont store the data in the permanent dataset. Its just a work dataset and then finally append into the database. Where to use CVPmulitpler option in the proc sql? THanks

helannivas88 · ‎03-18-2020

Db2 is the data source

helannivas88 · ‎03-18-2020

Hi, Currently we have defined SAS encoding for one of the Level (out of 5) as UTF 8 . All others are in latin - 9. But in the UTF - 8 session, when I tried to extract the data from different data source from SAS , the data gets truncated in the sas dataset. We have identified that the values which got truncated has special characters. We have defined the logic for extraction as upcase(trim(left(ColumnA))). But when I remove the upcase in the logic , then I dont see any problem and no data truncation is happening. I dont understand about the UTF - 8 and upcase dependency on the data truncation ?? Should I need to remove the upcase for these scenario?? Please let me know. Thanks in advance.

helannivas88 · ‎02-15-2020

Thanks both. Yes, I have made a mistake initially that below that environment variable I had another entry that is pointing to old value and that overwrite the new value. So , After I have removed the old value from sasenv_local I can able to get my desired results. But there is another problem related to same environmental variable. Initially I had a environmental variable in sasenv_local and that is common across two levels. But I don't want to share that across 2 level, so I have removed from the sasenv_local and in other level (level_env_usermods.sh ) I have added those env variable. Then I started my new SAS EG session and check whether the variable is removed in one level. But still its referring the same value. Even I restarted my object spawner to check again. But no luck. Is there any way to find where the environment variable has been defined??? Thanks in advance.

helannivas88 · ‎02-10-2020

Hi, I have made a small changes in the environment variable defined in sasenv_local file. After saving the file, in order to check whether the changes has made reflected in our SAS session , I have ran the below query in a new SAS EG session X ' env > /home/test/test.txt'; But the output ofthat variable is not the latest and its still pointing to old value. ( May be the output from cache)?? Do i need to restart the object spawner to make that effect??? Please let me know. Thanks in advance.

helannivas88 · ‎02-09-2020

I have changed like below and it worked perfectly. proc format ; picture myfmt other= '%Y-%0m-%0d %0H:%0M:%0s' (datatype=datetime ); run; data _null_; x='08FEB2020:18:29:00.022020'dt; x=myfmt26.6; run;

helannivas88 · ‎02-09-2020

Thanks @Kurt_Bremser .It was successful with your query. .

helannivas88 · ‎02-09-2020

Thanks @mkeintz for the picture format. But using the format , Im unable to derive the microseconds(or) milli seconds For Eg: proc format ; picture myfmt other= '%Y-%0m-%0d:%0H:%0M:%0S' (datatype=datetime ); run; data _null_; x='08FEB2020:18:29:00.000000'dt; put x=datetime27. / x=e8601dt19. / x=myfmt.; run; I'm not getting output as 2020-02-08 18:29:00.000000. I tried the picture format as '%Y-%0m-%0d:%0H:%0M:%000000S' (datatype=datetime ) (or) '%Y-%0m-%0d:%0H:%0M:%0S.nnnnnn' (datatype=datetime ) , but nothing works. Please let me know if we are able to get the desired output. Thanks in Advance.

helannivas88 · ‎02-08-2020

Hi, Im trying to create a test file with today date in Linux from SAS program using the below query , but I'm not able to result. X "bhosts | sed 's/ /,/g' | sed 's/,\{2,\}/,/g' > /home/test_"$(date +%%F)".txt"; But I when I run directly in Linux the below query its working. bhosts | sed 's/ /,/g' | sed 's/,\{2,\}/,/g' > /home/test_"$(date +%F)".txt Whether variable will not able to be passed in X command??? Thanks.

helannivas88 · ‎02-07-2020

Hi Team, We have three compute servers ( Grid machines) which is currently running in primary mode. Now I want to capture the cpu statistics of each grid machine via sas program ( because I have to call a Unix script from SAS via X command). By default the Schedule SAS jobs will hit any of the Grid machine randomly , but I want to write a program ( may be three different program) to explicitly mention the host name where the program has to run. How to write a sas program for this requirement??? Thanks in advance.

helannivas88 · ‎01-30-2020

Hi, I have a dataset where the datetime column stored as 'DDMONYYYY:HH:MI:SS.mmmmmm'. I want to format to 'YYYY-MM-DD:HH:MI:SS.mmmmmm'. I have tried with format as e8601dt19. But i got output as '2019-05-20T11:03:22'. I dont want to have T in my output. Is there any other format that can be used to get the desired output. Thanks in Advance.

helannivas88 · ‎01-29-2020

Thanks @SASKiwi for your response. In the Management Console, SASApp --> SASApp - Connect Server --> Options --> Remote Host and it has been given as the same host which I have been used in my program. I have checked the ConnectSpawner status on the host directly ,by running ./Connectspawner.sh status and its up and running . Port has been defined in SMC as 7551 and SIGNON Types as Scriptless. But still I'm getting the same error message.

Online Status	Offline
Date Last Visited	‎10-13-2023 12:18 PM

Stacked bar Clarification

Stored Process autoexec

Error : Issue in do loop comparison with character variable

Re: Suppress Warning

Suppress Warning

SAS session variable for Libname

Preserving leading spaces in txt file

Re: SAS Management console libraries - Password missing

Re: SAS Management console libraries - Password missing

Re: SAS Management console libraries - Password missing

SAS Management console libraries - Password missing

Systask return code

Locale file changes - Not reflected in SAS

Re: Connection to DB2 from SAS via clpplus

Connection to DB2 from SAS via clpplus

Re: UTF 8 data truncation

Re: UTF 8 data truncation

Re: UTF 8 data truncation

UTF 8 data truncation

Re: sasenv_local environment variable

sasenv_local environment variable

Re: Date time format conversation

Re: X Command data variable

Re: Date time format conversation

X Command data variable

SAS Program to include the host where it has to run

Date time format conversation

Re: ERROR: Remote signon to HOST canceled.