Problem with proc report multilayered heading
I am trying to create a report that looks like:
The first row is in the column named MPM_Description.
The second row is the Release date of those movies and the third row is the box office collection. The column to the left is the accounts name. The table is filled with the POS(point of sale) value for each movie titles.
The input data is like this:
I tried using proc report but could not succeed. I even saw some papers dicussing about the columns in Proc report but I am not sure which column to in order to get the desired output.
I am really looking for the answer.
Thank you,
Shankar
sas proc-report
asked Nov 16 '18 at 16:39
shankar
286
add a comment |
I am trying to create a report that looks like:
The first row is in the column named MPM_Description.
The second row is the Release date of those movies and the third row is the box office collection. The column to the left is the accounts name. The table is filled with the POS(point of sale) value for each movie titles.
The input data is like this:
I tried using proc report but could not succeed. I even saw some papers dicussing about the columns in Proc report but I am not sure which column to in order to get the desired output.
I am really looking for the answer.
Thank you,
Shankar
sas proc-report
asked Nov 16 '18 at 16:39
shankar
286
There are ways. I'm going to assume your question is not 'is this possible' because the answer is yes, but 'how do I create a report like this'. If that's correct please post sample data that reflects what you've shown and any attempt you've tried so far per SO rules How to Ask. Otherwise, if your question is this possible, then it's answered.
– Reeza
Nov 16 '18 at 23:58
I tried to add the data there but I could not. So, I edited the post with the output and the input data. The only thing I am not getting is how to put the Original_Street_Date and new_box lined under the MPM_Description creating one column for each title.-Shankar
– shankar
Nov 20 '18 at 20:35
Instructions on adding data is here, but you do have to show an attempt as well. You can try communities.sas.com but the first request will be for sample data as well. stackoverflow.com/questions/53125348/…
– Reeza
Nov 20 '18 at 23:53
add a comment |
I am trying to create a report that looks like:
The first row is in the column named MPM_Description.
The second row is the Release date of those movies and the third row is the box office collection. The column to the left is the accounts name. The table is filled with the POS(point of sale) value for each movie titles.
The input data is like this:
I tried using proc report but could not succeed. I even saw some papers dicussing about the columns in Proc report but I am not sure which column to in order to get the desired output.
I am really looking for the answer.
Thank you,
Shankar
sas proc-report
asked Nov 16 '18 at 16:39
shankar
286
I am trying to create a report that looks like:
The first row is in the column named MPM_Description.
The second row is the Release date of those movies and the third row is the box office collection. The column to the left is the accounts name. The table is filled with the POS(point of sale) value for each movie titles.
The input data is like this:
I tried using proc report but could not succeed. I even saw some papers dicussing about the columns in Proc report but I am not sure which column to in order to get the desired output.
I am really looking for the answer.
Thank you,
Shankar
sas proc-report
sas proc-report
asked Nov 16 '18 at 16:39
shankar
286
asked Nov 16 '18 at 16:39
shankar
286
edited Nov 20 '18 at 20:15
asked Nov 16 '18 at 16:39
shankar
286
asked Nov 16 '18 at 16:39
shankar
286
asked Nov 16 '18 at 16:39
shankar
286
286
There are ways. I'm going to assume your question is not 'is this possible' because the answer is yes, but 'how do I create a report like this'. If that's correct please post sample data that reflects what you've shown and any attempt you've tried so far per SO rules How to Ask. Otherwise, if your question is this possible, then it's answered.
– Reeza
Nov 16 '18 at 23:58
I tried to add the data there but I could not. So, I edited the post with the output and the input data. The only thing I am not getting is how to put the Original_Street_Date and new_box lined under the MPM_Description creating one column for each title.-Shankar
– shankar
Nov 20 '18 at 20:35
Instructions on adding data is here, but you do have to show an attempt as well. You can try communities.sas.com but the first request will be for sample data as well. stackoverflow.com/questions/53125348/…
– Reeza
Nov 20 '18 at 23:53
add a comment |
There are ways. I'm going to assume your question is not 'is this possible' because the answer is yes, but 'how do I create a report like this'. If that's correct please post sample data that reflects what you've shown and any attempt you've tried so far per SO rules How to Ask. Otherwise, if your question is this possible, then it's answered.
– Reeza
Nov 16 '18 at 23:58
I tried to add the data there but I could not. So, I edited the post with the output and the input data. The only thing I am not getting is how to put the Original_Street_Date and new_box lined under the MPM_Description creating one column for each title.-Shankar
– shankar
Nov 20 '18 at 20:35
Instructions on adding data is here, but you do have to show an attempt as well. You can try communities.sas.com but the first request will be for sample data as well. stackoverflow.com/questions/53125348/…
– Reeza
Nov 20 '18 at 23:53
There are ways. I'm going to assume your question is not 'is this possible' because the answer is yes, but 'how do I create a report like this'. If that's correct please post sample data that reflects what you've shown and any attempt you've tried so far per SO rules How to Ask. Otherwise, if your question is this possible, then it's answered.
– Reeza
Nov 16 '18 at 23:58
There are ways. I'm going to assume your question is not 'is this possible' because the answer is yes, but 'how do I create a report like this'. If that's correct please post sample data that reflects what you've shown and any attempt you've tried so far per SO rules How to Ask. Otherwise, if your question is this possible, then it's answered.
– Reeza
Nov 16 '18 at 23:58
I tried to add the data there but I could not. So, I edited the post with the output and the input data. The only thing I am not getting is how to put the Original_Street_Date and new_box lined under the MPM_Description creating one column for each title.-Shankar
– shankar
Nov 20 '18 at 20:35
I tried to add the data there but I could not. So, I edited the post with the output and the input data. The only thing I am not getting is how to put the Original_Street_Date and new_box lined under the MPM_Description creating one column for each title.-Shankar
– shankar
Nov 20 '18 at 20:35
Instructions on adding data is here, but you do have to show an attempt as well. You can try communities.sas.com but the first request will be for sample data as well. stackoverflow.com/questions/53125348/…
– Reeza
Nov 20 '18 at 23:53
Instructions on adding data is here, but you do have to show an attempt as well. You can try communities.sas.com but the first request will be for sample data as well. stackoverflow.com/questions/53125348/…
– Reeza
Nov 20 '18 at 23:53
add a comment |
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',
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%2f53342028%2fproblem-with-proc-report-multilayered-heading%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53342028%2fproblem-with-proc-report-multilayered-heading%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
There are ways. I'm going to assume your question is not 'is this possible' because the answer is yes, but 'how do I create a report like this'. If that's correct please post sample data that reflects what you've shown and any attempt you've tried so far per SO rules How to Ask. Otherwise, if your question is this possible, then it's answered.
– Reeza
Nov 16 '18 at 23:58
I tried to add the data there but I could not. So, I edited the post with the output and the input data. The only thing I am not getting is how to put the Original_Street_Date and new_box lined under the MPM_Description creating one column for each title.-Shankar
– shankar
Nov 20 '18 at 20:35
Instructions on adding data is here, but you do have to show an attempt as well. You can try communities.sas.com but the first request will be for sample data as well. stackoverflow.com/questions/53125348/…
– Reeza
Nov 20 '18 at 23:53