Hello,   I am making my first steps with json file and I need help.   First, I am connecting to an oracle db to read a precise table which is brought into the dataset test.   Here's what it look like   JSON_FORMAT "{""contacts"":[{""firstName"":""Rokaya"",""lastName"":""Bablabla"",...""}]}" "{""contacts"":[{""firstName"":""Nazalene"",""lastName"":""Bablabla"",...""}]}"   I have retrieve a lot of information for safety purpose.  I would like to read / import each fields such as firstName, lastName and so on. Then I will replace all the email , agentEmail and managerEmail for my email , for testing purpose.   Then from that point, I need to reproduce the original file above as it was before but with the 3 email fields updated.   After that, I will take this file save it on our server. Thereafter, I will develop the SAS code to send the information to an API web server.         ... View more

Hello,   Few weeks ago, I have developped a SAS script which permits to obtain Survey Results using Proc HTTP.  That script is shared for the community.   Now I need to send information to a company, I believe probably using their API Web site. Do someone of the community already done a similar task using SAS.   Thanks for sharing your thoughs ... View more

Hello,   I am trying to read a csv file which contains strange characters like below: Pas encore inscrit mais j'espère si tôt.   j'espère should be j'espère si tôt. should be si tôt.   Is there a way to change that when the file is unzip (see the Unix command below) x %sysfunc(quote(unzip -jo /.../report.zip -d /.../report)));   Is it possible to use an encoding option while reading the  decompressed file or does the tranwrd function is the only option?    ... View more

Hello,   Hello, I have tried the procedure proc import to import a csv file that might have some structure problems and it failed. I have also tried the code generated by the import tool but without the cleansing option.  However, it is like some data lines (see the attached Excel file) are spread on multiple lines instead of staying on one line (original file structure). For example, the three first variables should be as below: Startdate: 2022-12-06 16:56:08 Endate: 2022-12-06 17:00:58 Status: IP Address And so on… So each line should start with Startdate, Endate, Status IP and so on.  If it is not the case, this partial line should concatenate with the previous one.  Again if there is a second and a third partial line, than this third partial line should concatenate with the second partial line and this concatenated result should concatenate with the first partial line.   If it is possible to polish this dataset in that manner, it will be possible either to use an infile statement or a proc import.   The difficulties is how it is possible to clean (polish) that dataset first.  I never did that before? Any suggestions?     ... View more