Problem with proc report multilayered heading












0















I am trying to create a report that looks like:
enter image description here



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:
enter image description here



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










share|improve this question

























  • 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
















0















I am trying to create a report that looks like:
enter image description here



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:
enter image description here



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










share|improve this question

























  • 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














0












0








0








I am trying to create a report that looks like:
enter image description here



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:
enter image description here



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










share|improve this question
















I am trying to create a report that looks like:
enter image description here



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:
enter image description here



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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 20 '18 at 20:15







shankar

















asked Nov 16 '18 at 16:39









shankarshankar

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



















  • 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












0






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
});


}
});














draft saved

draft discarded


















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

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes
















draft saved

draft discarded




















































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.




draft saved


draft discarded














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





















































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







這個網誌中的熱門文章

Xamarin.form Move up view when keyboard appear

Post-Redirect-Get with Spring WebFlux and Thymeleaf

Anylogic : not able to use stopDelay()