About Cugel

Cugel · ‎08-08-2023

I will discuss with our technical colleagues whether this is the solution to our problem.

Cugel · ‎08-01-2023

I'm looking for a way to read a JSON column from an Oracle table into SAS. The Oracle table contains a column called "Document" in which a JSON structure is stored. Now our organization uses an ODBC link to Oracle but the ODBC link has a 1024 limitation on the number of characters. The "Document" column contains 32767 characters broken down into a large number of JSON arrays. Is there a possibility to access this Oracle table directly on the Oracle server and then read it into SAS tables?.

Cugel · ‎11-18-2021

Hi Tom, Our organization uses SAS DI studio.

Cugel · ‎11-18-2021

Hi Tom, Thanks for your response. You made the right assumption that the tables should be linked based on the client_id and the dbc_id. Your solution works but uses proc_sql while I'm looking for a solution to include as expression code. Your sequencing assumption is also correct and should be determined based on the client_id, dbc_id and d_examination. [cid:image001.jpg@01D7DCA1.A7380230]

Cugel · ‎11-18-2021

Hi I'm looking for a way to add a sequence number to a data series. When joining two oracle tables I can use the OVER and PARTITION BY function. But now I'm looking for an equivalent function that I can use when it comes to SAS tables. My employer wants me to find the solution in a data step expression. At the moment we are still working with an Oracle database, but in 2022 the database will become a Microsoft SQL server database. So in the future I can't use “real” Oracle SQL statements Thanks in advance for any kind of help. With kind regards.

Cugel · ‎01-18-2021

Hi Chris, Thanks you for your explanation. But where can I find the "format box". Is it a setting that must be placed on the SAS server or is it a format that can be set locally.

Cugel · ‎01-18-2021

Hi Tom, Thanks for your comment. I looked for the solution in the same direction and already formatted the datetime () as a string. But your solution is more compact and neat.

Cugel · ‎01-17-2021

Hi Kurt, Thanks for tutorial tips. Will take some study hours in the evenings. For now I have solved the problem as follows. CAT(catx('-',put(DAY(DATEPART(DATETIME())),z2.) ,put( MONTH(DATEPART(DATETIME())),z2.) ,YEAR(DATEPART(DATETIME())) ),' ', catx(':',put(HOUR(DATETIME()),z2.) , put(MINUTE(DATETIME()),z2.) )) The loading date 17JAN2021:21:22:00 then becomes 17-01-2021 21:22. Maybe not so neat, but workable for the moment.

Cugel · ‎01-17-2021

I have included Kurt's solution in "SQL execute" transformation. In the job, this transformation is performed first. This solution works. However, if the job crashes, the variable is no longer available and the first step must be performed again.

Cugel · ‎01-16-2021

Hi Kurt, Thanks for your comment. Do you have maybe an example for me of such a code statement. There is no clear example in the DIS manual. Options fmtsearch = (myformat library work); myformat ???

Cugel · ‎01-16-2021

I would like to convert the date format ddmmmyyyy:hh:mm:ss to dd-mm-yyyy hh:mm:ss so European standard. I have been looking for a solution for some time but have not yet been able to find a clear example. I work with the graphics side of SAS Data Integration Studio. Any help is appreciated. datetime() format is now ddmmmyyyy:hh:mm:ss and I would like dd-mm-yyyy hh:mm:ss (European standard).

Cugel · ‎01-14-2021

No problem Peter thanks for your response.

Cugel · ‎01-14-2021

Hello Peter, Thanks for your response. However, I work with the graphics side of SAS DIS. To my knowledge, your solution cannot be applied here. In the expression field I have included the datetime(). So now the datetime() must be displayed in dd-mm-yyyy hh: mm: ss. Greetings Jos [cid:image001.png@01D6EA82.C173AD00]

Cugel · ‎01-14-2021

I would like to convert the date format ddmmmyyyy:hh:mm:ss to dd-mm-yyyy hh:mm:ss so European standard. I have been looking for a solution for some time but have not yet been able to find a clear example. I work with SAS Data Integration Studio. Any help is appreciated

Cugel · ‎01-13-2021

Hi Tom Thanks for your help, we are using SAS Data Integration Studio 4.903.

Online Status	Offline
Date Last Visited	‎08-24-2023 07:43 AM

Re: How to extract JSON data from a Oracle column

How to extract JSON data from a Oracle column

Re: Add sequence number to a data series

Re: Add sequence number to a data series

Add sequence number to a data series

Re: Convert ddmmmyyyy:hh:mmi:ss to dd-mm-yyyy hh:mm:ss

Re: Convert ddmmmyyyy:hh:mmi:ss to dd-mm-yyyy hh:mm:ss

Re: Convert ddmmmyyyy:hh:mmi:ss to dd-mm-yyyy hh:mm:ss

Re: How to create a variable for use in a job

Re: Convert ddmmmyyyy:hh:mmi:ss to dd-mm-yyyy hh:mm:ss

Re: Proc SQL Loop for days between start_date and end_date

Re: How to extract JSON data from a Oracle column

How to extract JSON data from a Oracle column

Re: Add sequence number to a data series

Re: Add sequence number to a data series

Add sequence number to a data series

Re: Convert ddmmmyyyy:hh:mmi:ss to dd-mm-yyyy hh:mm:ss

Re: Convert ddmmmyyyy:hh:mmi:ss to dd-mm-yyyy hh:mm:ss

Re: Convert ddmmmyyyy:hh:mmi:ss to dd-mm-yyyy hh:mm:ss

Re: How to create a variable for use in a job

Re: Convert ddmmmyyyy:hh:mmi:ss to dd-mm-yyyy hh:mm:ss

Re: Convert ddmmmyyyy:hh:mmi:ss to dd-mm-yyyy hh:mm:ss

Re: Convert ddmmmyyyy:hh:mmi:ss to dd-mm-yyyy hh:mm:ss

Re: Convert ddmmmyyyy:hh:mmi:ss to dd-mm-yyyy hh:mm:ss

Convert ddmmmyyyy:hh:mmi:ss to dd-mm-yyyy hh:mm:ss

Re: How to create a variable for use in a job