I'm curious if anyone has experience with SAS file corruption, specifically lines of code randomly being partially deleted. For example, I have several programs that run as scheduled tasks and I noticed them failing all of a sudden.After opening the programs I noticed some comments had been truncated leaving them open, and also some lines of code being truncated, e.g.:   proc transpose data=metafree out=metatrans1free prefix=field; by projid prot table_name screenname; var field_name; run;   changed to:   proc transpose data=metafree out=metatrans1free prefix=field; by projid prot table_name    Only I have access to the program so it's not a matter of someone going in and accidentally altering these lines of code.   Thanks! ... View more

I have an existing SAS table that is produced from my company's SQL database. One of the fields contains each record's audit trail and I am trying to parse that field for reporting purposes. When I read the table into SAS the length, format, and informat are 2000 which is truncating some of the data contained in the field. I have tried changing the length, format, and informat as follows:   data want; length audit $ 10000; informat audit $10000.; format audit $10000.; set datain.have; run;   But, the result is still a truncation at 2000 characters. I'm assuming there is nothing else I can do in SAS and need to contact the SQL DB admin to change the format of the field in the source data set.   Thoughts? ... View more

Morning,   I am using ODS LAYOUT to generate a PDF report with several pages. At the top of each page I have defined a header area as follows: ods region height=1in style={background=VLIGB }; ods text = " "; ods region y = 0.35 in; ods text = "^{style[background=VLIGB foreground=white font_size=16pt font_face='arial' just=c textdecoration=underline font_weight=bold]Investigator Request for Materials}"; ods region x = 0.15 in y = 0.035 in; ods text = '^{style[preimage="&preimage"]}'; The preimage macro variable (&preimage) value is a directory path to a logo .png file on my company's network. As I mentioned above there are multiple pages I am configuring for this report so I have defined this header information for each page. The problem I am running into is that SAS crashes when I use the preimage on more than one page. I will get the popup that says "sas.exe has stopped working - Check online for solution, close the program, or Debug the program".  If I use it on just one page, the program runs just fine. If I remove the ods region/ods text statements that define the preimage, the program also runs just fine. Additionally, the program is nearly identical to another program I have that calls the preimage multiple times and that program runs fine as well.   I have tried outputting my log and viewing the results I don't see any errors or warnings, all macros are resolving as they should, etc. so at this point I am stuck on how to troubleshoot this further. Any ideas?   ... View more