How do I vertically stack tables in SAS using ODS Excel?How to create Excel (.XLS and .XLSX) file in C# without installing Ms Office?How do I properly clean up Excel interop objects?Excel to CSV with UTF8 encodingHow to avoid using Select in Excel VBAText manipulation of macro list variables to stack datasets with automated namesExport Windows forms datagridview to excel power pivot table with C#Stack multiple cells of excel using ODS - SASExport excel spreadsheet to XML and sort array alphabetically during or after export?Combining forecasts into a data frame in R and then exporting into excelSAS DDE to Excel 2016 fix/ alternative?
Valid term from quadratic sequence?
Can I run a new neutral wire to repair a broken circuit?
Bullying boss launched a smear campaign and made me unemployable
Why can't we play rap on piano?
Arrow those variables!
Plagiarism or not?
Examples of smooth manifolds admitting inbetween one and a continuum of complex structures
How do I gain back my faith in my PhD degree?
Venezuelan girlfriend wants to travel the USA to be with me. What is the process?
How do I deal with an unproductive colleague in a small company?
Detention in 1997
Ambiguity in the definition of entropy
How dangerous is XSS?
Probability that a draw from a normal distribution is some number greater than another draw from the same distribution
How do I handle a potential work/personal life conflict as the manager of one of my friends?
Why doesn't using multiple commands with a || or && conditional work?
What's the in-universe reasoning behind sorcerers needing material components?
Can a virus destroy the BIOS of a modern computer?
Could the museum Saturn V's be refitted for one more flight?
Can compressed videos be decoded back to their uncompresed original format?
Expand and Contract
What do you call someone who asks many questions?
Madden-Julian Oscillation (MJO) - How to interpret the index?
Why is it a bad idea to hire a hitman to eliminate most corrupt politicians?
How do I vertically stack tables in SAS using ODS Excel?
How to create Excel (.XLS and .XLSX) file in C# without installing Ms Office?How do I properly clean up Excel interop objects?Excel to CSV with UTF8 encodingHow to avoid using Select in Excel VBAText manipulation of macro list variables to stack datasets with automated namesExport Windows forms datagridview to excel power pivot table with C#Stack multiple cells of excel using ODS - SASExport excel spreadsheet to XML and sort array alphabetically during or after export?Combining forecasts into a data frame in R and then exporting into excelSAS DDE to Excel 2016 fix/ alternative?
I'm exporting a series of crosstabs from SAS 9.3 to Excel using Excel ODS tagsets.
The syntax I've written is as follows:
%include 'C:UsersMyNameDocumentsexcltags.tpl';
ods tagsets.excelxp file = "M:Assess1718PARTIC_3-8.xml"
proc sort data = assess_elem;
by accommodations_ny participation_ny district;
run;
proc freq data = assess_elem
by accommodations_ny participation_ny district;
tables grade*proficiency / crosslist nocum nocol;
run;
ods tagsets.excelxp close;
The variables are:
- accommodations_ny: alphanumeric, N/Y
- participation_ny: alphanumeric, N/Y
- district: alphanumeric, 103 district names
- grade: numeric, 3-8
- proficiency: numeric, 0/1
The syntax above creates a table like this for each of the 103 districts:
have 103 separate tables
What I would like to have is something more like:
want 1 stacked table
excel sas crosstab ods
asked Mar 8 at 22:18
doctorjaydoctorjay
14
add a comment |
I'm exporting a series of crosstabs from SAS 9.3 to Excel using Excel ODS tagsets.
The syntax I've written is as follows:
%include 'C:UsersMyNameDocumentsexcltags.tpl';
ods tagsets.excelxp file = "M:Assess1718PARTIC_3-8.xml"
proc sort data = assess_elem;
by accommodations_ny participation_ny district;
run;
proc freq data = assess_elem
by accommodations_ny participation_ny district;
tables grade*proficiency / crosslist nocum nocol;
run;
ods tagsets.excelxp close;
The variables are:
- accommodations_ny: alphanumeric, N/Y
- participation_ny: alphanumeric, N/Y
- district: alphanumeric, 103 district names
- grade: numeric, 3-8
- proficiency: numeric, 0/1
The syntax above creates a table like this for each of the 103 districts:
have 103 separate tables
What I would like to have is something more like:
want 1 stacked table
excel sas crosstab ods
asked Mar 8 at 22:18
doctorjaydoctorjay
14
Are you images correct? They both look the same to me.
– Reeza
Mar 9 at 3:52
And SAS 9.3 is about 7 years old, if you have a valid license you're entitled to upgrades, I highly recommend it, since ODS EXCEL has a ton of more useful features than ODS TAGSETS.
– Reeza
Mar 9 at 3:57
Thanks! Revised! And yes, I'm supposed to get 9.4 very soon. I can't wait!
– doctorjay
Mar 13 at 16:23
add a comment |
I'm exporting a series of crosstabs from SAS 9.3 to Excel using Excel ODS tagsets.
The syntax I've written is as follows:
%include 'C:UsersMyNameDocumentsexcltags.tpl';
ods tagsets.excelxp file = "M:Assess1718PARTIC_3-8.xml"
proc sort data = assess_elem;
by accommodations_ny participation_ny district;
run;
proc freq data = assess_elem
by accommodations_ny participation_ny district;
tables grade*proficiency / crosslist nocum nocol;
run;
ods tagsets.excelxp close;
The variables are:
- accommodations_ny: alphanumeric, N/Y
- participation_ny: alphanumeric, N/Y
- district: alphanumeric, 103 district names
- grade: numeric, 3-8
- proficiency: numeric, 0/1
The syntax above creates a table like this for each of the 103 districts:
have 103 separate tables
What I would like to have is something more like:
want 1 stacked table
excel sas crosstab ods
asked Mar 8 at 22:18
doctorjaydoctorjay
14
I'm exporting a series of crosstabs from SAS 9.3 to Excel using Excel ODS tagsets.
The syntax I've written is as follows:
%include 'C:UsersMyNameDocumentsexcltags.tpl';
ods tagsets.excelxp file = "M:Assess1718PARTIC_3-8.xml"
proc sort data = assess_elem;
by accommodations_ny participation_ny district;
run;
proc freq data = assess_elem
by accommodations_ny participation_ny district;
tables grade*proficiency / crosslist nocum nocol;
run;
ods tagsets.excelxp close;
The variables are:
- accommodations_ny: alphanumeric, N/Y
- participation_ny: alphanumeric, N/Y
- district: alphanumeric, 103 district names
- grade: numeric, 3-8
- proficiency: numeric, 0/1
The syntax above creates a table like this for each of the 103 districts:
have 103 separate tables
What I would like to have is something more like:
want 1 stacked table
excel sas crosstab ods
excel sas crosstab ods
asked Mar 8 at 22:18
doctorjaydoctorjay
14
asked Mar 8 at 22:18
doctorjaydoctorjay
14
edited Mar 13 at 16:23
doctorjay
asked Mar 8 at 22:18
doctorjaydoctorjay
14
asked Mar 8 at 22:18
doctorjaydoctorjay
14
asked Mar 8 at 22:18
doctorjaydoctorjay
14
14
Are you images correct? They both look the same to me.
– Reeza
Mar 9 at 3:52
And SAS 9.3 is about 7 years old, if you have a valid license you're entitled to upgrades, I highly recommend it, since ODS EXCEL has a ton of more useful features than ODS TAGSETS.
– Reeza
Mar 9 at 3:57
Thanks! Revised! And yes, I'm supposed to get 9.4 very soon. I can't wait!
– doctorjay
Mar 13 at 16:23
add a comment |
Are you images correct? They both look the same to me.
– Reeza
Mar 9 at 3:52
And SAS 9.3 is about 7 years old, if you have a valid license you're entitled to upgrades, I highly recommend it, since ODS EXCEL has a ton of more useful features than ODS TAGSETS.
– Reeza
Mar 9 at 3:57
Thanks! Revised! And yes, I'm supposed to get 9.4 very soon. I can't wait!
– doctorjay
Mar 13 at 16:23
Are you images correct? They both look the same to me.
– Reeza
Mar 9 at 3:52
Are you images correct? They both look the same to me.
– Reeza
Mar 9 at 3:52
And SAS 9.3 is about 7 years old, if you have a valid license you're entitled to upgrades, I highly recommend it, since ODS EXCEL has a ton of more useful features than ODS TAGSETS.
– Reeza
Mar 9 at 3:57
And SAS 9.3 is about 7 years old, if you have a valid license you're entitled to upgrades, I highly recommend it, since ODS EXCEL has a ton of more useful features than ODS TAGSETS.
– Reeza
Mar 9 at 3:57
Thanks! Revised! And yes, I'm supposed to get 9.4 very soon. I can't wait!
– doctorjay
Mar 13 at 16:23
Thanks! Revised! And yes, I'm supposed to get 9.4 very soon. I can't wait!
– doctorjay
Mar 13 at 16:23
add a comment |
2 Answers
2
active
oldest
votes
Use tagset option OPTIONS(SHEET_INTERVAL="Proc").
ods tagsets.excelxp
file=...
style=...
options(doc="all" sheet_interval="Proc") /* <--- your magic --- */
;
The DOC="ALL" options option will show the ExcelXP tagset documentation in the log.
answered Mar 9 at 0:07
RichardRichard
9,84221329
Thanks! I wasn't aware of that option!
– doctorjay
Mar 13 at 16:24
add a comment |
You are not limited to two way in the TABLE statement, especially if you use the LIST option instead of CROSSLIST.
Here's a quick example using SASHELP.CARS
proc freq data=sashelp.cars;
table origin*make*cylinders / list;
run;
It creates a table like this:
This will not give you the unrepeated columns on the left most, if you do want that, PROC TABULATE gives you more control over the output or push it to a table and use PROC REPORT.
answered Mar 9 at 3:56
ReezaReeza
13.4k21227
Perfect! Thank you! That's exactly what I was looking for. Self-taught, coming from Stata, so I'm definitely still learning. Much appreciated!
– doctorjay
Mar 13 at 16:26
add a comment |
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',
autoActivateHeartbeat: false,
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
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55071772%2fhow-do-i-vertically-stack-tables-in-sas-using-ods-excel%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Use tagset option OPTIONS(SHEET_INTERVAL="Proc").
ods tagsets.excelxp
file=...
style=...
options(doc="all" sheet_interval="Proc") /* <--- your magic --- */
;
The DOC="ALL" options option will show the ExcelXP tagset documentation in the log.
answered Mar 9 at 0:07
RichardRichard
9,84221329
Thanks! I wasn't aware of that option!
– doctorjay
Mar 13 at 16:24
add a comment |
Use tagset option OPTIONS(SHEET_INTERVAL="Proc").
ods tagsets.excelxp
file=...
style=...
options(doc="all" sheet_interval="Proc") /* <--- your magic --- */
;
The DOC="ALL" options option will show the ExcelXP tagset documentation in the log.
answered Mar 9 at 0:07
RichardRichard
9,84221329
Thanks! I wasn't aware of that option!
– doctorjay
Mar 13 at 16:24
add a comment |
Use tagset option OPTIONS(SHEET_INTERVAL="Proc").
ods tagsets.excelxp
file=...
style=...
options(doc="all" sheet_interval="Proc") /* <--- your magic --- */
;
The DOC="ALL" options option will show the ExcelXP tagset documentation in the log.
answered Mar 9 at 0:07
RichardRichard
9,84221329
Use tagset option OPTIONS(SHEET_INTERVAL="Proc").
ods tagsets.excelxp
file=...
style=...
options(doc="all" sheet_interval="Proc") /* <--- your magic --- */
;
The DOC="ALL" options option will show the ExcelXP tagset documentation in the log.
answered Mar 9 at 0:07
RichardRichard
9,84221329
answered Mar 9 at 0:07
RichardRichard
9,84221329
answered Mar 9 at 0:07
RichardRichard
9,84221329
answered Mar 9 at 0:07
RichardRichard
9,84221329
9,84221329
Thanks! I wasn't aware of that option!
– doctorjay
Mar 13 at 16:24
add a comment |
Thanks! I wasn't aware of that option!
– doctorjay
Mar 13 at 16:24
Thanks! I wasn't aware of that option!
– doctorjay
Mar 13 at 16:24
Thanks! I wasn't aware of that option!
– doctorjay
Mar 13 at 16:24
add a comment |
You are not limited to two way in the TABLE statement, especially if you use the LIST option instead of CROSSLIST.
Here's a quick example using SASHELP.CARS
proc freq data=sashelp.cars;
table origin*make*cylinders / list;
run;
It creates a table like this:
This will not give you the unrepeated columns on the left most, if you do want that, PROC TABULATE gives you more control over the output or push it to a table and use PROC REPORT.
answered Mar 9 at 3:56
ReezaReeza
13.4k21227
Perfect! Thank you! That's exactly what I was looking for. Self-taught, coming from Stata, so I'm definitely still learning. Much appreciated!
– doctorjay
Mar 13 at 16:26
add a comment |
You are not limited to two way in the TABLE statement, especially if you use the LIST option instead of CROSSLIST.
Here's a quick example using SASHELP.CARS
proc freq data=sashelp.cars;
table origin*make*cylinders / list;
run;
It creates a table like this:
This will not give you the unrepeated columns on the left most, if you do want that, PROC TABULATE gives you more control over the output or push it to a table and use PROC REPORT.
answered Mar 9 at 3:56
ReezaReeza
13.4k21227
Perfect! Thank you! That's exactly what I was looking for. Self-taught, coming from Stata, so I'm definitely still learning. Much appreciated!
– doctorjay
Mar 13 at 16:26
add a comment |
You are not limited to two way in the TABLE statement, especially if you use the LIST option instead of CROSSLIST.
Here's a quick example using SASHELP.CARS
proc freq data=sashelp.cars;
table origin*make*cylinders / list;
run;
It creates a table like this:
This will not give you the unrepeated columns on the left most, if you do want that, PROC TABULATE gives you more control over the output or push it to a table and use PROC REPORT.
answered Mar 9 at 3:56
ReezaReeza
13.4k21227
You are not limited to two way in the TABLE statement, especially if you use the LIST option instead of CROSSLIST.
Here's a quick example using SASHELP.CARS
proc freq data=sashelp.cars;
table origin*make*cylinders / list;
run;
It creates a table like this:
This will not give you the unrepeated columns on the left most, if you do want that, PROC TABULATE gives you more control over the output or push it to a table and use PROC REPORT.
answered Mar 9 at 3:56
ReezaReeza
13.4k21227
answered Mar 9 at 3:56
ReezaReeza
13.4k21227
answered Mar 9 at 3:56
ReezaReeza
13.4k21227
answered Mar 9 at 3:56
ReezaReeza
13.4k21227
13.4k21227
Perfect! Thank you! That's exactly what I was looking for. Self-taught, coming from Stata, so I'm definitely still learning. Much appreciated!
– doctorjay
Mar 13 at 16:26
add a comment |
Perfect! Thank you! That's exactly what I was looking for. Self-taught, coming from Stata, so I'm definitely still learning. Much appreciated!
– doctorjay
Mar 13 at 16:26
Perfect! Thank you! That's exactly what I was looking for. Self-taught, coming from Stata, so I'm definitely still learning. Much appreciated!
– doctorjay
Mar 13 at 16:26
Perfect! Thank you! That's exactly what I was looking for. Self-taught, coming from Stata, so I'm definitely still learning. Much appreciated!
– doctorjay
Mar 13 at 16:26
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55071772%2fhow-do-i-vertically-stack-tables-in-sas-using-ods-excel%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
Are you images correct? They both look the same to me.
– Reeza
Mar 9 at 3:52
And SAS 9.3 is about 7 years old, if you have a valid license you're entitled to upgrades, I highly recommend it, since ODS EXCEL has a ton of more useful features than ODS TAGSETS.
– Reeza
Mar 9 at 3:57
Thanks! Revised! And yes, I'm supposed to get 9.4 very soon. I can't wait!
– doctorjay
Mar 13 at 16:23