- #.ODT FILE FORMAT MESSED UP FULL#
- #.ODT FILE FORMAT MESSED UP CODE#
- #.ODT FILE FORMAT MESSED UP DOWNLOAD#
- #.ODT FILE FORMAT MESSED UP WINDOWS#
THEįOLLOWING NOTE INDICATES THE LEFT-MOST ARGUMENT THAT CAUSED TRUNCATION.įollowed by the message (for the SAS data step I posted here): THE CORRECT RESULT WOULD CONTAIN 229 CHARACTERS,īUT THE ACTUAL RESULT MAY EITHER BE TRUNCATED TO 200 CHARACTER(S) ORīE COMPLETELY BLANK, DEPENDING ON THE CALLING ENVIRONMENT. WARNING: IN A CALL TO THE CATX FUNCTION, THE BUFFER ALLOCATEDįOR THE RESULT WAS NOT LONG ENOUGH TO CONTAIN THE CONCATENATION The SAS log is producing this warning message:
#.ODT FILE FORMAT MESSED UP CODE#
So, after trying unsuccessfully with SQL, I came up with the following SAS code (please note I am very new at SAS): Now I am having trouble with String concatenation.Ģ_124_Hi, there old friend of mine, hope you are enjoying the weather Are you sure this is not your jacket, okay then. I want this to appear concatenated kinda like concat_group() from MYSQL but for some reason SAS does not have such functionality. Will give charity.Īnd I have to get a Table similar to this (table name = MKPLOGSA):ġ_123_This is some text which is part of the record. Now I am having trouble withĤ_123_String concatenation.ĥ_124_Hi there old friend of mine, hope you are enjoying the weatherĦ_124_Are you sure this is not your jacket, okay then. I want this to appearĢ_123_concatenated kinda like concat_group() from MYSQL but for some reasonģ_123_SAS does not have such functionality. _-_-ġ_123_This is some text which is part of the record. I am creating a SAS table in which one of the fields has to holds a huge string.įollowing is my table (TABLE name = MKPLOGS4): ODS listing body='/excelReport/theReport.xls' TRANTAB=ASCII Can I have something similar for ODS listing? Such as: However, in this case, as I mentioned, I am not using any other ODS option other than the default ODS listing. ODS html body='/htmlFiles/temp.html' TRANTAB=ASCII How can I possibly create the output file in ASCII format?įor example, if I was using ODS html, I could have said something like: Throughout the program, I am only using ODS listing - no other ODS.
I am using SAS 8.2 (we are due to get upgraded to SAS 9 soon but for now, I have to work in SAS 8.2) and because of the client's requirement for the Excel report, I had to manually code the excel report in xml because there is no other way to create a excel report in SAS 8.2 containing multiple worksheets and column filters.
#.ODT FILE FORMAT MESSED UP DOWNLOAD#
Ofcourse it works fine when I use FTP to download as FTP takes care of the conversion.
#.ODT FILE FORMAT MESSED UP WINDOWS#
All is going well however since the file being created is in EBCDIC format (format used on mainframes), when I download the file on to my Windows desktop (not FTP, download via website), the file is all messed up (contains only symbols) because of the difference in file format. What I’m asking then is if this has any solution at all (I foresee it does not), because it looks to me that LibreOffice does not provide this OS-independent features after all.I am using SAS on mainframe (z/OS) and I am creating a excel file using xml. This in turn makes that the pages are also different, where one table is in one page in Windows it appears in two pages in Linux. Text looks bigger in Linux, so that with the same “Page” dimensions the text distributes much worse in Linux than in Windows.
This is very frustrating, I had assumed the capability to work independently of the OS, but with this should I regret having bought a chromebook?Īctually, I can see that the problem is much larger than with tables. How is that if I open it in Windows (originally created there) it looks as expected, but if I open it in Ubuntu (chromebook and crouton) all tables have messed widths and where before I saw (for example) one row for the number 01 now I see it in two rows?
#.ODT FILE FORMAT MESSED UP FULL#
I have my LibreOffice ODT file of 5 Mb full of text, images and tables.