topic Re: SAS program corruption - lines of code partially deleted/truncated in SAS Programming

SAS program corruption - lines of code partially deleted/truncated

lbarwick — Wed, 04 Mar 2020 14:48:58 GMT

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!

Re: SAS program corruption - lines of code partially deleted/truncated

s_lassen — Wed, 04 Mar 2020 16:16:39 GMT

Probably something with the S option, which controls the length of source lines being read. Just specify

options s=max;

in the beginning of your code, that should solve the problem (unless your programs set the S option to something else along the way).

If you are using %INCLUDE files, you may also want to set S2=MAX.

Re: SAS program corruption - lines of code partially deleted/truncated

lbarwick — Wed, 04 Mar 2020 16:20:27 GMT

The problem is that some lines are truncated at say column 100 and then other lines truncate at column 300. If it was S option would all lines be truncated at the same exact column?

Re: SAS program corruption - lines of code partially deleted/truncated

s_lassen — Wed, 04 Mar 2020 16:22:05 GMT

Yes, that should be the case. Unless you explicitly set the S option somewhere, or you are using %INCLUDE, and S2 is different from S.

Re: SAS program corruption - lines of code partially deleted/truncated

lbarwick — Wed, 04 Mar 2020 16:24:41 GMT

I am not explicitly setting S option anywhere in the program. Is there an implicit S option too that is set in preferences?

Re: SAS program corruption - lines of code partially deleted/truncated

Kurt_Bremser — Wed, 04 Mar 2020 16:45:30 GMT

Are these lines truncated in the stored programs (do not check this with SAS, use the operating system for this - type (Windows) or cat (UNIX)), or only while being executed by SAS job?

Re: SAS program corruption - lines of code partially deleted/truncated

lbarwick — Wed, 04 Mar 2020 18:13:00 GMT

I'm not sure what you mean. I am in a Windows environment using 9.4

Re: SAS program corruption - lines of code partially deleted/truncated

s_lassen — Wed, 04 Mar 2020 18:53:11 GMT

Yes, there may be a default set in Config.sas, in the program invocation command line, or in the autoexec.sas file. If you have no S or S2 options statements anywhere else, try putting this in the beginning of the programs you are running:

options s=max s2=max;

Re: SAS program corruption - lines of code partially deleted/truncated

lbarwick — Wed, 04 Mar 2020 18:56:50 GMT

So say someone with a local setting different from mine opened the program and then saved it, could that cause this?

Re: SAS program corruption - lines of code partially deleted/truncated

s_lassen — Wed, 04 Mar 2020 19:01:30 GMT

No. But if someone (including yourself) ran the program with a different config.sas, autoexec.sas, or different command line options, that could explain the problem. When running in batch, all of these may be different, check the batch environment, or try my proposed solution.

Re: SAS program corruption - lines of code partially deleted/truncated

lbarwick — Wed, 04 Mar 2020 19:03:28 GMT

OK - the proposed solution did not work. I'll check the configs.

Re: SAS program corruption - lines of code partially deleted/truncated

Kurt_Bremser — Wed, 04 Mar 2020 20:08:46 GMT

@lbarwick wrote:
I'm not sure what you mean. I am in a Windows environment using 9.4

Then open the .sas files with the Windows Editor and check if the lines are truncated there.

Re: SAS program corruption - lines of code partially deleted/truncated

lbarwick — Thu, 05 Mar 2020 13:43:24 GMT

Yes the lines are truncated in the enhanced editor.

Re: SAS program corruption - lines of code partially deleted/truncated

Kurt_Bremser — Thu, 05 Mar 2020 13:47:41 GMT

And also in the Windows Editor (or Notepad++)? This will determine if the problem happens only when reading the files, or when they were last stored.

If the latter, look at the last modification timestamp; it might give you a hint when it happened.

Re: SAS program corruption - lines of code partially deleted/truncated

lbarwick — Thu, 05 Mar 2020 13:57:28 GMT

The code in text editor is identical to code in enhanced editor. There appears to be extraneous blank spaces inserted in random places. Unfortunately I made a minor edit the other day that wouldn't have affected any of this, so time stamp is unreliable. I've asked my IT dept to recover an archived copy.

Re: SAS program corruption - lines of code partially deleted/truncated

Kurt_Bremser — Thu, 05 Mar 2020 14:24:30 GMT

Just a hunch: have them run a thorough file system check where your programs are stored.