Hello all, I am not sure if this has been done before or not so here goes. Sorry this is not in a traditional SAS 'have', 'want' style* with some starter code. I have many reports going back decades that I want to read back in from excel into SAS. All have a few things in common. Each has a report name in cell A1. May skip one or more lines/rows and has column heading information broken over two lines not repeated but repeated implied (see image attached)  A random number of data/body lines with some type of time series indicator for the first column A, can have per separate tab or excel report a random number of columns (generally less than 40 columns). then a Notes or footer data. Note in this example how the first row of the column headings (Row 3) just has Academic, Room, Board, and 'Room & Board Rates'  in this case if you select each word/phrase they are in cells for example: Academic (A3), Room (B3), Board (F3), and 'Room & Board Rates' (L3)  in each case from for example 'Room' would be repeated in the columns from B3-E3 or B3 to ((L3)-1 column), then Board would be repeated til column K etc.. I have attempted to read this in with a few passes since the data sizes are very small in general I can read in with a few let statements per report and short macros, -custom written per sub-report area, get the report name, the body, the footer, and all its body lines.  I can read these correctly except my method has to ignore the column names and just read for example columns as A-M in this case.  What I am failing to do with this method is tie it back together with a single line for the column names. At this time does anyone have a solution that would handle reading this data and for example have a column name for column 'C' 'Room_Double' or 'Double_Room'? *I am forgoing that request style since I think my ideas to re-join the composite column headers to the columns have failed I just wanted to start fresh to see what the rest of SAS world might do to solve this read issue. My research on reading excel xlsx files is not very fruitful where the column header is over two lines.  TIA  -KJ ... View more

Hello All, I am not new to SAS, but 100% new to 'proc Soap', in fact, I have 0% experience with any post / API SAS procedures. I almost entirely work with ODBC SAS work. Can anyone help me debug this code? ...or point me at open WS with a working SAS example? /*filename request temp;*/ filename request "c:\temp\request.xml"; /*filename response temp;*/ filename response "c:\temp\responce.xml"; data _null_; file request; input; put _infile_; datalines4; <?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:xsi="https://MY_Server.My_Domain.edu/XMLSchema-instance" xmlns:xsd="http://MY_Server.My_Domain.edu/XMLSchema" xmlns:soap="http://MY_Server.My_Domain.edu/soap/envelope/"> <soap:Body> <getReshallData xmlns="https://MY_Server.My_Domain.edu/Odyssey/"> <term>AY2021</term> </getReshallData> </soap:Body> </soap:Envelope> ;;;; run; proc soap in=request out=response url="https://MY_Server.My_Domain.edu/ohms/ws/IRHousingService.asmx" soapaction="getReshallData"; run; I get this error: ERROR: java.lang.Exception: Server did not recognize the value of HTTP Header SOAPAction: getReshallData. There is virtually nothing on this error online when I search for the must have 'SAS', 'Proc Soap', 'Error', let alone the rest of this error.  Google did not have a full-page in fact. If helpful when I run this I do get the request and response files (I renamed them to .txt to upload), and I have replaced my server.domain name. I would be very happy to even go read a good blog on the topic if anyone has one, but for example, I cannot get the default examples here to work: https://documentation.sas.com/?docsetId=proc&docsetVersion=9.4&docsetTarget=p0q0stkf83myu6n13kxcljc12w7c.htm&locale=en it comes back with ERROR: org.springframework.ws.client.WebServiceIOException: I/O error: proxygw.unx.sas.com; nested exception is java.net.UnknownHostException: proxygw.unx.sas.com TIA  -KJ   ... View more

Hello All, Does anyone know the trick to make my SAS Viya jobs work again? I have [them] scheduled to run a few times a day they were working fine two days ago. Yesterday I changed my AD password. This morning I noticed in my logs they were failing with a access denied. D'oh I forgot to update "my credentials" in Viya. I verified the password was correctly entered with copy paste (I also checked by accessing another tool that takes AD). Still no joy?  Maybe a service needs bounced??  TIA.  -KJ ... View more

Hello everyone, I know this exists but have forgotten where to do this, I have my dev SAS Viya Windows system logging with the timestamps of the log files the same as my local timezone, however, I failed to save the configuration location for production setup. Can someone point me to the correct form SAS Viya V.03.04?  TIA. My logs in production seem to be off by +3 hours. ... View more