topic Re: Present Result in 'Journal Format' in SAS Programming

Present Result in 'Journal Format'

arii — Mon, 19 Mar 2018 21:17:36 GMT

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:

ab	cd	ef	gh
100	800	901	565
200	820	345	453
300	840	567	565
400	880	871	598
500	900	651	876
600	926	678	700
700	952	459	654
800	978	601	655
900	1004	502	333

3. Current SAS Output:

Root MSER-SquareDependent MeanAdj R-SqCoeff Var

13.54412	0.9985
500.00000	0.9976
2.70882

Parameter EstimatesVariable Label DF ParameterEstimate StandardError t Value Pr > |t|Intercept1cd1ef1gh1

Intercept	-2882.48846	70.17627	-41.07	<.0001
cd	3.79174	0.07009	54.10	<.0001
ef	-0.06167	0.02884	-2.14	0.0855
gh	0.01354	0.03297	0.41	0.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.

Re: Present Result in 'Journal Format'

PGStats — Mon, 19 Mar 2018 22:00:09 GMT

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=14.3&locale=en

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

Re: Present Result in 'Journal Format'

arii — Sun, 25 Mar 2018 15:35:51 GMT

This is helpful. Thank you, PGStats.

Re: Present Result in 'Journal Format'

Cynthia_sas — Sun, 25 Mar 2018 15:51:19 GMT

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