topic Re: Unknown statement in proc export in SAS Programming

Unknown statement in proc export

ErikLund_Jensen — Wed, 06 Feb 2019 17:43:01 GMT

Hi community

I came across this piece of code in a job. The job writes several sheets to the same excel workbook in identical steps, just with different where-conditions and sheet names.

proc export data=&_INPUT (where=(FejlID=2)) dbms=xlsx
	outfile="&xlsxfil" replace;
	WXLX;
	sheet="Kun AMMO";
run;

The code works as expected, and it executes without any errors, warnings or notes related to the WXLX statement in both Windows and Linux (9.4M5), so the stetement is accepted by Proc Export. But it is marked red in the enhanced editor, and I have not been able to find it documented anywhere, even uncle Google lets me down.

I hate not beeing able to figure out what's going on in code I am running, so I hope that somebody in this community knows what the statement does, and will take the time to explain it and - if possible - give a link to where it is documented. Thanks in advance.

Re: Unknown statement in proc export

Kurt_Bremser — Wed, 06 Feb 2019 19:17:32 GMT

A search for "sas proc export wxlx" gave me this: https://marc.info/?l=sas-l&m=147819121210860&w=2

Re: Unknown statement in proc export

Tom — Wed, 06 Feb 2019 20:02:56 GMT

As the link @Kurt_Bremser found says that strange command (or token) is something that PROC IMPORT/EXPORT generates and occasionally ends up in the SAS log.

It doesn't cause any error and you can remove it.

Someone must have copied the code from the log into their program and kept it because they weren't sure what it was.

Re: Unknown statement in proc export

ErikLund_Jensen — Fri, 08 Feb 2019 17:08:29 GMT

@Tom @Kurt_Bremser

Thanks to both of you for taking time to clarify. I accept Tom's answer as a solution because og his convincing explanation of how it ended up in the code.