DATA Step, Macro, Functions and more

Present Result in 'Journal Format'

Reply
Contributor
Posts: 33

Present Result in 'Journal Format'

Hi Colleagues,

 

Are there codes I can use to ensure SAS automatically present my results in the format required by most journals for articles?

Please see below: 

1. SAS codes

2. Sample data

3. Current SAS output

4. Intended 'journal  output format' 

 

 

1. SAS Codes:

proc reg data = sample;
model ab = cd ef gh;


run;

 

 

 

2. Sample data:

abcdefgh
100800901565
200820345453
300840567565
400880871598
500900651876
600926678700
700952459654
800978601655
9001004502333

 

 

 

 

3. Current SAS Output:

 

Root MSER-SquareDependent MeanAdj R-SqCoeff Var 
13.544120.9985
500.000000.9976
2.70882 

 

Parameter EstimatesVariable Label DF ParameterEstimate StandardError t Value Pr > |t|Intercept1cd1ef1gh1
Intercept-2882.4884670.17627-41.07<.0001
cd3.791740.0700954.10<.0001
ef-0.061670.02884-2.140.0855
gh0.013540.032970.410.6983

 

 

 

 

 

4. Intended 'Journal Output Format':

 

Panel A:

 

(1)

 

 

 

 

VARIABLE

ab

 

 

 

 

 

 

 

 

 

 

cd

 3.79174*

 

 

 

 

 

(54.10)

 

 

 

 

ef

    -0.06167*

 

 

 

 

 

(-2.14)

 

 

 

 

gh

   0.01354

 

 

 

 

 

(0.41)

 

 

 

 

 

 

 

 

 

 

Constant

-2882.48846***

 

 

 

 

 

(-41.07)

 

 

 

 

 

 

 

 

 

 

Observations

9

 

 

 

 

R-squared

0.9985

 

 

 

 

F-stat

1088.59

 

 

 

 

Prob > F

<.0001

 

 

 

 

Robust standard errors in parentheses

 *** p<0.01, ** p<0.05, * p<0.1

 

 

 

I basically want the results in something close to the Intended 'Journal Output Format' as shown above.

 

 

 

Esteemed Advisor
Posts: 5,627

Re: Present Result in 'Journal Format'

SAS provides some slightly different ODS journal styles called journal, journala, journal2, journal2a journal3 and journal3a.

 

http://documentation.sas.com/?docsetId=statug&docsetTarget=statug_odsgraph_sect060.htm&docsetVersion...

 

you can use them with rtf, pdf and html output destinations, among others.

PG
Contributor
Posts: 33

Re: Present Result in 'Journal Format'

This is helpful. Thank you, PGStats.

SAS Super FREQ
Posts: 9,435

Re: Present Result in 'Journal Format'

Hi:
And, if you look at Example 1 and Example 8 in this paper, you'll see some different ways to use PROC REPORT to further "massage" your report to get it into the format you need: http://www2.sas.com/proceedings/forum2008/173-2008.pdf

Cynthia
Ask a Question
Discussion stats
  • 3 replies
  • 141 views
  • 1 like
  • 3 in conversation