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
SAS Super FREQ
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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