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

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 1779 views
  • 1 like
  • 3 in conversation