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:
13.54412 | 0.9985 |
500.00000 | 0.9976 |
2.70882 |
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.
SAS provides some slightly different ODS journal styles called journal, journala, journal2, journal2a journal3 and journal3a.
you can use them with rtf, pdf and html output destinations, among others.
This is helpful. Thank you, PGStats.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.