Programming the statistical procedures from SAS

SAS: ODS LATEX tagsets omits LINE ENDING MARK

Reply
Occasional Contributor
Posts: 12

SAS: ODS LATEX tagsets omits LINE ENDING MARK


Hi,


I'm running a 'proc means' command to print out summary stats on two

variables below: stakeVO and payoutVO. I'm creating latex on-the-fly

and picking the latex up in a larger document with the appropriate

headers for the table and all that. It works perfectly if I have only

one variable in the 'var' part of the PROC MEANS command. I can even

have a number of class statements there and it works. However, if I

add another variable to the 'var' statement, there is a carriage

return missing from the latex output.

This is the output I'm getting:

stakeVO    & 48.05    & 10.00    & 192.10    & 0.01    & 24000.00    &

payoutVO    & -1.96    & 0.14    & 170.02    & -24000.00    & 10002.78

  \tabularnewline

This is the output I want:

stakeVO    & 48.05    & 10.00    & 192.10    & 0.01    & 24000.00

\tabularnewline

payoutVO    & -1.96    & 0.14    & 170.02    & -24000.00    & 10002.78

  \tabularnewline

I'm using the following sas command to create the table (which does

display perfectly in the SAS results viewer).

ods tagsets.customMinimal file="summaryPanelA_data.tex" (notop nobot)

newfile=table;

proc means data=phd.formatted mean median stddev min max maxdec=2;

var stake payout;

run;

ods tagsets.customMinimal close;

I've tried using all the original tagsets for latex output i.e. Latex,

SimpleLatex and TablesOnlyLatex, but it still doesn't print an

end-of-line character.

This is the contents of my customer tagset:

*START REGION: Running this creates a new template;

Proc template;

define tagset Tagsets.customMinimal;

define event byline;end;

define event proc_title;end;

define event note;end;

define event Error;end;

define event Warn;end;

define event Fatal;end;

define event system_footer;end;

define event leaf;end;

define event proc_branch;end;

define event branch;end;

define event pagebreak;end;

define event system_title;end;

define event table;end;

define event table_head;end;

define event colspecs;end;

define event colspec_entry;end;

define event row;

        break /if ^contains( $HTMLCLASS, "data");

        put "                " NL "  " /if ^exists( $colspan);

    finish:

        break /if cmp( $sascaption, "true");

        break /if contains( HTMLCLASS, "data");

        break /if ^exists($hasdata);

        put "\tabularnewline" NL /if ^exists( $colspan);

        unset $hasdata;

end;

define event data;

    start:

        put VALUE /if cmp( $sascaption, "true");

        break /if cmp( $sascaption, "true");

        break /if ^contains( HTMLCLASS, "data");

        break /if exists( $colspan) | exists ( $cell_align );

        put %nrstr(" & ") /if ^cmp( COLSTART, "1");

        unset $colspan;

        set $colspan colspan;

        set $hasdata '1';

        /*put tranwrd(VALUE,"-","$-$") /if contains( HTMLCLASS, "data"); */

        put tranwrd(VALUE,"-","-") /if contains( HTMLCLASS, "data");

        put VALUE /if ^contains( HTMLCLASS, "data");

        put "   ";

    finish:

        break /if ^contains( HTMLCLASS, "data");

        break /if cmp( $sascaption, "true");

        break /if exists( $colspan) | exists ( $cell_align );

end;

parent = tagsets.simplelatex;

end;

quit;


I'd appreciate any help at all on this.

Ask a Question
Discussion stats
  • 0 replies
  • 186 views
  • 0 likes
  • 1 in conversation