SAS Data Table Using PROC REPORT









up vote
2
down vote

favorite












I'm a beginner using SAS and I was tasked with creating a table that looks like the following:



 Group A Group B All
A B C D E F G H I J K L M
Age
n
mean(sd)
median
min-max
Gender
n
fl
ml
Race
n
white
asian
hispanic
black


The blanks in the table are just the calculations based on the criteria. What I've considered doing is the following but it doesn't look right and there are errors. Is there anyway to fix this or use proc freq/ proc tabulate if it's easier:



Libname test '/home/user/username'; 
DATA test;
SET test.test(keep = GROUP LETTER AGE GENDER RACE);
RUN;
PROC SORT DATA = test;
BY GROUP LETTER AGE GENDER RACE;
PROC MEANS DATA = test;
CLASS GROUP LETTER;
VAR AGE GENDER RACE;
RUN;
PROC PRINT DATA = test;
TITLE 'Demographics';
RUN;
PROC PRINT DATA=test;
RUN;
PROC TRANSPOSE DATA = test.test;
OUT = test.test;
BY GROUP LETTER;
VAR GROUP LETTER;
RUN;
PROC REPORT DATA = asl.asl;
COLUMN GROUP LETTER AGE GENDER RACE;
DEFINE GROUP /DISPLAY 'Group';
DEFINE LETTER /DISPLAY 'Letter';
DEFINE AGE /DISPLAY 'Age';
DEFINE GENDER /DISPLAY 'Gender';
DEFINE RACE /DISPLAY 'Race';
RUN;









share|improve this question



















  • 2




    Bottom of the page you'll fin dthe link to a paper (and code) that illustrates how to do this. It's not as straightforward as it could be :( communities.sas.com/t5/SAS-Studio/Demographic-table-creation/…
    – Reeza
    Nov 8 at 22:52






  • 1




    Thanks so much Reeza. This is extremely helpful and I'm glad to see I'm not the only one scratching my head at this.
    – Serena Lee
    Nov 8 at 22:55














up vote
2
down vote

favorite












I'm a beginner using SAS and I was tasked with creating a table that looks like the following:



 Group A Group B All
A B C D E F G H I J K L M
Age
n
mean(sd)
median
min-max
Gender
n
fl
ml
Race
n
white
asian
hispanic
black


The blanks in the table are just the calculations based on the criteria. What I've considered doing is the following but it doesn't look right and there are errors. Is there anyway to fix this or use proc freq/ proc tabulate if it's easier:



Libname test '/home/user/username'; 
DATA test;
SET test.test(keep = GROUP LETTER AGE GENDER RACE);
RUN;
PROC SORT DATA = test;
BY GROUP LETTER AGE GENDER RACE;
PROC MEANS DATA = test;
CLASS GROUP LETTER;
VAR AGE GENDER RACE;
RUN;
PROC PRINT DATA = test;
TITLE 'Demographics';
RUN;
PROC PRINT DATA=test;
RUN;
PROC TRANSPOSE DATA = test.test;
OUT = test.test;
BY GROUP LETTER;
VAR GROUP LETTER;
RUN;
PROC REPORT DATA = asl.asl;
COLUMN GROUP LETTER AGE GENDER RACE;
DEFINE GROUP /DISPLAY 'Group';
DEFINE LETTER /DISPLAY 'Letter';
DEFINE AGE /DISPLAY 'Age';
DEFINE GENDER /DISPLAY 'Gender';
DEFINE RACE /DISPLAY 'Race';
RUN;









share|improve this question



















  • 2




    Bottom of the page you'll fin dthe link to a paper (and code) that illustrates how to do this. It's not as straightforward as it could be :( communities.sas.com/t5/SAS-Studio/Demographic-table-creation/…
    – Reeza
    Nov 8 at 22:52






  • 1




    Thanks so much Reeza. This is extremely helpful and I'm glad to see I'm not the only one scratching my head at this.
    – Serena Lee
    Nov 8 at 22:55












up vote
2
down vote

favorite









up vote
2
down vote

favorite











I'm a beginner using SAS and I was tasked with creating a table that looks like the following:



 Group A Group B All
A B C D E F G H I J K L M
Age
n
mean(sd)
median
min-max
Gender
n
fl
ml
Race
n
white
asian
hispanic
black


The blanks in the table are just the calculations based on the criteria. What I've considered doing is the following but it doesn't look right and there are errors. Is there anyway to fix this or use proc freq/ proc tabulate if it's easier:



Libname test '/home/user/username'; 
DATA test;
SET test.test(keep = GROUP LETTER AGE GENDER RACE);
RUN;
PROC SORT DATA = test;
BY GROUP LETTER AGE GENDER RACE;
PROC MEANS DATA = test;
CLASS GROUP LETTER;
VAR AGE GENDER RACE;
RUN;
PROC PRINT DATA = test;
TITLE 'Demographics';
RUN;
PROC PRINT DATA=test;
RUN;
PROC TRANSPOSE DATA = test.test;
OUT = test.test;
BY GROUP LETTER;
VAR GROUP LETTER;
RUN;
PROC REPORT DATA = asl.asl;
COLUMN GROUP LETTER AGE GENDER RACE;
DEFINE GROUP /DISPLAY 'Group';
DEFINE LETTER /DISPLAY 'Letter';
DEFINE AGE /DISPLAY 'Age';
DEFINE GENDER /DISPLAY 'Gender';
DEFINE RACE /DISPLAY 'Race';
RUN;









share|improve this question















I'm a beginner using SAS and I was tasked with creating a table that looks like the following:



 Group A Group B All
A B C D E F G H I J K L M
Age
n
mean(sd)
median
min-max
Gender
n
fl
ml
Race
n
white
asian
hispanic
black


The blanks in the table are just the calculations based on the criteria. What I've considered doing is the following but it doesn't look right and there are errors. Is there anyway to fix this or use proc freq/ proc tabulate if it's easier:



Libname test '/home/user/username'; 
DATA test;
SET test.test(keep = GROUP LETTER AGE GENDER RACE);
RUN;
PROC SORT DATA = test;
BY GROUP LETTER AGE GENDER RACE;
PROC MEANS DATA = test;
CLASS GROUP LETTER;
VAR AGE GENDER RACE;
RUN;
PROC PRINT DATA = test;
TITLE 'Demographics';
RUN;
PROC PRINT DATA=test;
RUN;
PROC TRANSPOSE DATA = test.test;
OUT = test.test;
BY GROUP LETTER;
VAR GROUP LETTER;
RUN;
PROC REPORT DATA = asl.asl;
COLUMN GROUP LETTER AGE GENDER RACE;
DEFINE GROUP /DISPLAY 'Group';
DEFINE LETTER /DISPLAY 'Letter';
DEFINE AGE /DISPLAY 'Age';
DEFINE GENDER /DISPLAY 'Gender';
DEFINE RACE /DISPLAY 'Race';
RUN;






stored-procedures sas tabular






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 9 at 8:04









Brian Tompsett - 汤莱恩

4,153133699




4,153133699










asked Nov 8 at 22:43









Serena Lee

977




977







  • 2




    Bottom of the page you'll fin dthe link to a paper (and code) that illustrates how to do this. It's not as straightforward as it could be :( communities.sas.com/t5/SAS-Studio/Demographic-table-creation/…
    – Reeza
    Nov 8 at 22:52






  • 1




    Thanks so much Reeza. This is extremely helpful and I'm glad to see I'm not the only one scratching my head at this.
    – Serena Lee
    Nov 8 at 22:55












  • 2




    Bottom of the page you'll fin dthe link to a paper (and code) that illustrates how to do this. It's not as straightforward as it could be :( communities.sas.com/t5/SAS-Studio/Demographic-table-creation/…
    – Reeza
    Nov 8 at 22:52






  • 1




    Thanks so much Reeza. This is extremely helpful and I'm glad to see I'm not the only one scratching my head at this.
    – Serena Lee
    Nov 8 at 22:55







2




2




Bottom of the page you'll fin dthe link to a paper (and code) that illustrates how to do this. It's not as straightforward as it could be :( communities.sas.com/t5/SAS-Studio/Demographic-table-creation/…
– Reeza
Nov 8 at 22:52




Bottom of the page you'll fin dthe link to a paper (and code) that illustrates how to do this. It's not as straightforward as it could be :( communities.sas.com/t5/SAS-Studio/Demographic-table-creation/…
– Reeza
Nov 8 at 22:52




1




1




Thanks so much Reeza. This is extremely helpful and I'm glad to see I'm not the only one scratching my head at this.
– Serena Lee
Nov 8 at 22:55




Thanks so much Reeza. This is extremely helpful and I'm glad to see I'm not the only one scratching my head at this.
– Serena Lee
Nov 8 at 22:55

















active

oldest

votes











Your Answer






StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













 

draft saved


draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53217259%2fsas-data-table-using-proc-report%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown






























active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes















 

draft saved


draft discarded















































 


draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53217259%2fsas-data-table-using-proc-report%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

𛂒𛀶,𛀽𛀑𛂀𛃧𛂓𛀙𛃆𛃑𛃷𛂟𛁡𛀢𛀟𛁤𛂽𛁕𛁪𛂟𛂯,𛁞𛂧𛀴𛁄𛁠𛁼𛂿𛀤 𛂘,𛁺𛂾𛃭𛃭𛃵𛀺,𛂣𛃍𛂖𛃶 𛀸𛃀𛂖𛁶𛁏𛁚 𛂢𛂞 𛁰𛂆𛀔,𛁸𛀽𛁓𛃋𛂇𛃧𛀧𛃣𛂐𛃇,𛂂𛃻𛃲𛁬𛃞𛀧𛃃𛀅 𛂭𛁠𛁡𛃇𛀷𛃓𛁥,𛁙𛁘𛁞𛃸𛁸𛃣𛁜,𛂛,𛃿,𛁯𛂘𛂌𛃛𛁱𛃌𛂈𛂇 𛁊𛃲,𛀕𛃴𛀜 𛀶𛂆𛀶𛃟𛂉𛀣,𛂐𛁞𛁾 𛁷𛂑𛁳𛂯𛀬𛃅,𛃶𛁼

Edmonton

Crossroads (UK TV series)