About shlomiohana

shlomiohana · ‎12-12-2023

It works, how do I change that there won't be a 5 second wait, that the user will go directly to the link

shlomiohana · ‎12-12-2023

hello, I use a stored process , i need to open a permanent link at the end or the run. I worte the following code: data _null_; file _webout; put '<HTML dir="rtl" >'; put '<body>'; put '<HEAD><TITLE>PEGA</TITLE></HEAD>'; put '<h1>Welcome '; put '<br>'; put '<a href ="https://crmpg.com">CLICK TO OPEN</a>'; put '</h1>'; put '</body>'; put '</HTML>'; run; The user need to click on "CLICK TO OPEN" in web browser to get to https://crmpg.com. Is there a possibility that the link opens automatically without user intervention? Thanks.

shlomiohana · ‎11-21-2023

This is not good i get an error because the full urlencode is: original_string = urlencode('<?xml version="1.0" encoding="UTF-8"?><SMF_REPLY><SMF_REQUEST_ID>aaa</SMF_REQUEST_ID><SMF_RETURN_CODE>1</SMF_RETURN_CODE><SMF_RETURN_MESSAGE>&globalVar</SMF_RETURN_MESSAGE></SMF_REPLY>'

shlomiohana · ‎11-20-2023

Hello, I try to pass a global variable in the urlencode function and get an invalid link, I run the following code: %let globalVar = 201080; data test; original_string = urlencode('<SMF_REPLY><SMF_REQUEST_ID>aaa</SMF_REQUEST_ID><SMF_RETURN_CODE>1</SMF_RETURN_CODE><SMF_RETURN_MESSAGE>&globalVar</SMF_RETURN_MESSAGE></SMF_REPLY>'); run; If I enter the number itself 201080 I will get a proper link. my question is how to pass a global variable to the urlencode function? I get a valid link: urlencode('<SMF_REPLY><SMF_REQUEST_ID>aaa</SMF_REQUEST_ID><SMF_RETURN_CODE>1</SMF_RETURN_CODE><SMF_RETURN_MESSAGE>201080</SMF_RETURN_MESSAGE></SMF_REPLY>') thanks.

shlomiohana · ‎11-18-2023

I would appreciate help on how to solve the issue?

shlomiohana · ‎11-16-2023

Hi, I ran libname resp xmlv2; and got several errors: Error: PCDATA content found outside column/table boundary. content is CREATE_INTERACTION Error: XML data is not in a format supported natively by the XML libname engine. Files of this type may require an XMLMap to be input properly.

shlomiohana · ‎11-15-2023

Hi, I ran libname data xmlv2 resp; and got several errors: ERROR: Libref DATA is not assigned. ERROR: Error in the LIBNAME statement. ERROR 23-7: Invalid value for the RESP option.

shlomiohana · ‎11-14-2023

Hello, I run the following code: filename resp temp; proc http url="https://https-url.com" method="GET" out=resp; run; The resp file contains: <?xml version="1.0" encoding="UTF-8"?><SMF_REPLY><SMF_SERVICE_NAME>CREATE_INTERACTION</SMF_SERVICE_NAME><SMF_REQUEST_ID>4VF1 o8j/4=</SMF_REQUEST_ID><SMF_RETURN_CODE>1</SMF_RETURN_CODE><SMF_RETURN _MESSAGE>SMF-I-1-SUCCESS [SEND successful]</SMF_RETURN_MESSAGE></SMF_REPLY> I want to create a table that will be created dynamically according to the tags that will be in the resp file. for example: SMF_SERVICE_NAME SMF_REQUEST_ID SMF_RETURN_CODE SMF_RETURN_MESSAGE CREATE_INTERACTION 4VF1o8j/4= 1 SMF-I-1-SUCCESS [SEND successful] If there is an additional tag in the resp file, a field will be added to the table automatically. thanks.

shlomiohana · ‎07-13-2023

Hi, How can i convert XML to URL with sas? Example: Xml: <?xml version="1.0" encoding="UTF-8"?> <SMF_REQUEST_PARAMS> <customerIdType>1</customerIdType> <customerId>312755468</customerId> </SMF_REQUEST_PARAMS> URL CONVERT: %3C%3Fxml%20version%3D%221.0%22%20encoding%3D%22UTF-8%22%3F%3E%0A%0A%3CSMF_REQUEST_PARAMS%3E%0A%0A%20%20%20%3CcustomerIdType%3E1%3C%2FcustomerIdType%3E%0A%0A%20%20%20%3CcustomerId%3E312755468%3C%2FcustomerId%3E%0A%0A%3C%2FSMF_REQUEST_PARAMS%3E Thanks.

shlomiohana · ‎05-08-2023

Hello, I have a table called POLAIM_MERGE that includes the field LOAD_LAST_DATETIME (format=datetime20, informat=datetime20) data POLAIM_ADD_FORMAT; set POLAIM_MERGE; mydate =datepart(LOAD_LAST_DATETIME); mytime = timepart(LOAD_LAST_DATETIME); format mydate ddmmyy10. mytime time5.; LOAD_LAST_DATETIME_NEW= put(mydate,ddmmyy10.)||' '||put(mytime,time5.); run; I wrote the following code but I get in the field "mytime" the time 9:03, I would like the leading 0 to be displayed at the time, desired display: 09:03 How do I change the code to show as I need? Thanks.

shlomiohana · ‎05-30-2022

You are amazing, thank you so much for the types of solution

shlomiohana · ‎05-29-2022

I edited the post, now there is output.

shlomiohana · ‎05-29-2022

Hello, I have the following table named CALLS: The code to create the table: data CALLS; input FIRST_NAME $ DAY_OF_MONTH :ddmmyy10. NUM_OF_CALLS; format DAY_OF_MONTH ddmmyy10.; datalines; TONY 01/01/2021 75 STEVE 01/01/2021 61 NATASHA 01/01/2021 50 TONY 02/01/2021 64 STEVE 02/01/2021 80 NATASHA 02/01/2021 100 TONY 03/01/2021 33 STEVE 03/01/2021 99 NATASHA 03/01/2021 91 TONY 04/01/2021 70 STEVE 04/01/2021 71 NATASHA 04/01/2021 70 ; run; I have 2 questions: 1. Who are the employees who made the same number of calls that day? The output: 2. Add to the table CALLS a field that shows the number of calls the day before. The output: I need to answer 2 questions in a code, preferably in sql code. Thanks.

shlomiohana · ‎04-24-2022

There is a system that is on a windows server until today my Guide was on a windows server so I had no problem running the code I attached, but now my Guide is on a Linux server and I need to create this table with an index, but the system is on the windows server does not accept the index created in Linux, so I used the option outrep = windows_64 so that the output would be in windows and not in Linux.

shlomiohana · ‎04-24-2022

Hello, Today I use SAS Enterprise Guide 7.15 on a Linux server. I need to create a table with an index to the windows server I run the following code: libname tavtdata "/cifs/sastest2012 "; data tavtdata.areamatch (outrep=windows_64); set tavtdata.areamatch; run; data tavtdata.areamatch (outrep=windows_64 index=(areaCode)); set tavtdata.areamatch; run; The error obtained in creating the index: I will ask for your help on how to create an index in Linux and the table will be windows_64. Thanks.

Online Status	Offline
Date Last Visited	‎12-13-2023 03:15 AM

Re: How to open link automatically stored process

How to open link automatically stored process

Re: How to pass a global variable to urlencode

How to pass a global variable to urlencode

Re: how to create table from proc http

Re: how to create table from proc http

Re: how to create table from proc http

how to create table from proc http and XML data

How to convert xml to url

How to leave a leading 0 in a date

Re: How to create global variables in a loop

Re: How to send an email from an existing table

Delete a post

Re: How to open link automatically stored process

How to open link automatically stored process

Re: How to pass a global variable to urlencode

How to pass a global variable to urlencode

Re: how to create table from proc http

Re: how to create table from proc http

Re: how to create table from proc http

how to create table from proc http and XML data

How to convert xml to url

How to leave a leading 0 in a date

Re: how to write sql code

Re: how to write sql code

how to write sql code

Re: How to create an index

How to create an index