BookmarkSubscribeRSS Feed
arii
Obsidian | Level 7

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.

 

 

 

3 REPLIES 3
PGStats
Opal | Level 21

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
arii
Obsidian | Level 7

This is helpful. Thank you, PGStats.

Cynthia_sas
Diamond | Level 26
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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1785 views
  • 1 like
  • 3 in conversation