About dincooo

dincooo · ‎01-10-2019

Hi experts, I have a banking transaction table and I want to track that for today() - x days time period if Y times same amount transactions occured. Fore example for the last 5 days a customer receives swift 10 times.And 3 of them are the same amount. How can write this sas code? Many thanks, Best Regards

dincooo · ‎01-03-2019

Hi, Thank you for your comment can you please write the code that does the last step? Many thanks

dincooo · ‎01-02-2019

Hi, Thank you for the answer. If it is possible can you please write the code that does like this?

dincooo · ‎01-02-2019

These two datasets are Oracle tables and we have the right to see them at SAS EG.

dincooo · ‎01-02-2019

Hi experts, I have a table named table_a with 2 million records. I want to update a column of table_a from another 2 millon rows table- named table_b. My query is: proc sql; update table_a u set BIRTH_PLACE=(select BIRTH_PLACE from table_b as n where u.party_number=n.party_number) where u.party_number in (select party_number from table_b); quit; This query takes too much time and never ending. Do you have any suggestion how to update this table? Many thanks, Onur

dincooo · ‎08-02-2018

Hi all, We have a real time SAS server which takes and sends real time requests. It works for 2 years but from yesterday there is an error: After waiting nearly 110 seconds the requests are getting error like this: Response : <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> <html><head> <title>502 Proxy Error</title> </head><body> <h1>Proxy Error</h1> <p>The proxy server received an invalid response from an upstream server.<br /> The proxy server could not handle the request <em><a href="/SASBIWS/services/claim_info_ws">POST /SASBIWS/services/claim_info_ws</a></em>.<p> Reason: <strong>Error reading from remote server</strong></p></p> <hr> <address>Apache/2.2.29.0 (Unix) PivotalWebServer/5.4.3 mod_ssl/2.2.29.0 OpenSSL/1.0.1j-fips mod_bmx/0.9.4 Also when logging to a SAS web UI the error is: 2018-08-01 20:05:05,190 [task-scheduler-2] ERROR [unknown] org.springframework.integration.handler.LoggingHandler - java.lang.RuntimeException: java.io.IOException: Server returned HTTP response code: 502 for URL: at org.jasig.cas.client.util.CommonUtils.getResponseFromServer(CommonUtils.java:328) at org.jasig.cas.client.util.CommonUtils.getResponseFromServer(CommonUtils.java:291) at org.jasig.cas.client.util.CommonUtils.getResponseFromServer(CommonUtils.java:344) at org.jasig.cas.client.proxy.Cas20ProxyRetriever.getProxyTicketIdFor(Cas20ProxyRetriever.java:65) at org.jasig.cas.client.authentication.AttributePrincipalImpl.getProxyTicketFor(AttributePrincipalImpl.java:87) at com.sas.svcs.authentication.helper.LazySpringSecurityContext.getSecurityContextWithAuthManager(LazySpringSecurityContext.java:155) at com.sas.svcs.authentication.helper.LazySpringSecurityContext.getSecurityContext(LazySpringSecurityContext.java:234) at com.sas.svcs.authentication.helper.LazySpringSecurityContext.getAuthentication(LazySpringSecurityContext.java:245) at com.sas.svcs.security.aop.RunAsInterceptor.invoke(RunAsInterceptor.java:84) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy1985.loadRelationships(Unknown Source) at com.sas.svcs.content.relationship.dao.scheduling.RelationshipSchedulingHandler$LoadRunnable.run(RelationshipSchedulingHandler.java:317) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:53) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: java.io.IOException: Server returned HTTP response code: 502 for URL: at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1627) at org.jasig.cas.client.util.CommonUtils.getResponseFromServer(CommonUtils.java:311) ... 20 more

dincooo · ‎05-31-2018

I missed that point you're right.. Do you have any other suggestion how can i make passport numbers unique? All suggestions are more than welcome 🙂

dincooo · ‎05-31-2018

No it is a case which i dont want. So i missed that point. Do you have any idea how can make these passport numbers as unique number?

dincooo · ‎05-31-2018

Thank you very much for your answer. Actually these are passport numbers and I think there are no passport numbers with exactly the same char-number combination. rank function can be used but char values may be in the beggining, middle etc.. how I take the char value, convert to number and put it to record? Many thanks

dincooo · ‎05-31-2018

Hi experts, I have a party_number varible which may contain records like these: A12345 , 123E45 , 67588H. I want to change the character letters with their alphabetic order numbers. For example A is the first character of the alphabet and I want to convert A12345 to 112345. 123E45 ==> 123545 67588H ==> 675888 How can I do this with SAS coding? Many thanks, Onur

dincooo · ‎05-16-2018

Thank you for your answer, but the thing is that these tables are populated by a batch code. I dont have the chance to edit these codes so I have to find a way to delete today()-10 date tables.

dincooo · ‎05-16-2018

Hi experts, I have daily populated SAS tables under a library. These tables are in the format like that: (date is in the end) table_x20180516 table_x20180515 table_x20180514 ..... table_xy20180516 table_xy20180515 ..... I want to write a script that runs at the server and deletes today()-10 dated tables. How can i write that kind of script. Thank you very much, Best Regards Onur

dincooo · ‎05-08-2018

Hi experts, There is a big inner join which takes approximately 20 minutes before. But today we are getting an error like this (saswork space is 2 TB) NOTE: There were 34434671 observations read from the data set <table_name> ERROR: An I/O error has occurred on file <table_name> ERROR: Failure while merging sorted runs from utility file 1 to final output. ERROR: Failure encountered during external sort. ERROR: File <table_name> is damaged. I/O processing did not complete. NOTE: The SAS System stopped processing this step because of errors. NOTE: SAS set option OBS=0 and will continue to check statements. This might cause NOTE: No observations in data set. Many thanks, Best Regards

dincooo · ‎02-20-2018

Hi everyone, I have a table containing Turkish character in it and it is stored in SAS library. This table's encoding option is latin5 which supports Turkish characters. When I'm trying to transfer this table to Oracle library it is saying Failed to transcode data from U_UTF8_CE to U_LATIN5_CE. (Also attached the entire error) I try to change Oracle library option ==> encoding=latin5 but it didn't work. Do you have any idea about this situation. Many thanks, Onur

dincooo · ‎02-05-2018

Hi everyne, Suppose that I have a data like this: (It shows company A made 4 times transaction to company B, company C made 1 time transaction to company D etc..) A B 4 C D 1 A E 3 I need to transform this data like this: ID Target 1 A 1 B 2 A 2 B 3 A 3 B 4 A 4 B ---------4 (A,B) 5 C 5 D ---------1 (C,D) 6 A 6 E 7 A 7 E 8 A 8 E ----------3 (A, E) How can I do that? Thank you very much! Onur

Online Status	Offline
Date Last Visited	‎01-11-2019 05:37 AM

Detecting same amounts of transactions

Re: Updating 2 million table from another 2 mio table

Re: Updating 2 million table from another 2 mio table

Re: Updating 2 million table from another 2 mio table

Updating 2 million table from another 2 mio table

502 Proxy Error: The proxy server received an invalid response from a...

Re: Converting a character including number to unique number

Re: Converting a character including number to unique number

Re: Converting a character including number to unique number

Converting a character including number to unique number

Re: ERROR: An I/O error has occurred on file

Re: Client wants to put their logo to VA, ECM and SNA UI

Detecting same amounts of transactions

Re: Updating 2 million table from another 2 mio table

Re: Updating 2 million table from another 2 mio table

Re: Updating 2 million table from another 2 mio table

Updating 2 million table from another 2 mio table

502 Proxy Error: The proxy server received an invalid response from a...

Re: Converting a character including number to unique number

Re: Converting a character including number to unique number

Re: Converting a character including number to unique number

Converting a character including number to unique number

Re: Auto deleting old tables

Auto deleting old tables

ERROR: An I/O error has occurred on file

Data Integration Studio - Failed to transcode data from U_UTF8_CE to U...

Table transformation