topic Re: report from different variables in diff data sets in ODS and Base Reporting

report from different variables in diff data sets

mona4u — Tue, 13 Mar 2018 20:07:27 GMT

I want to produce a report which looks like this table I eliminate part of the table to make the explanations easier

Readable time point= sum of varaiable2(which is in data set 2)- sum of variable1 (which is in data set 1)

time point read= sum of variable1 (which is in data set 1)

I want to create the report and I want to know if I can create new data set that contains macros of the computation

then create proc report step to output it

Please suggest to me the best way to do it


Readable Time Points:	8

Time Points Read	29

Re: report from different variables in diff data sets [how to improve your question]

Community_Guide — Tue, 13 Mar 2018 20:12:49 GMT

Hello @mona4u,

Your question requires more details before experts can help. Can you revise your question to include more information?

Review this checklist:

Specify a meaningful subject line for your topic. Avoid generic subjects like "need help," "SAS query," or "urgent."
When appropriate, provide sample data in text or DATA step format. See this article for one method you can use.
If you're encountering an error in SAS, include the SAS log or a screenshot of the error condition. Use the Photos button to include the image in your message.
It also helps to include an example (table or picture) of the result that you're trying to achieve.

To edit your original message, select the "blue gear" icon at the top of the message and select Edit Message. From there you can adjust the title and add more details to the body of the message. Or, simply reply to this message with any additional information you can supply.

SAS experts are eager to help -- help them by providing as much detail as you can.

This prewritten response was triggered for you by fellow SAS Support Communities member @Reeza

Re: report from different variables in diff data sets

ballardw — Tue, 13 Mar 2018 20:21:30 GMT

Why do you think you need macros? Macro of what computation?

Likely it is easier to create a DATASET combining the two existing data sets, doing some computation there and then using proc report for the output (though your example looks like TABULATE might be cleaner that Report).

Actual example INPUT data sets and desired output would help.

Re: report from different variables in diff data sets

mona4u — Tue, 13 Mar 2018 20:24:29 GMT

combining the data sets is hard to me bc there is no matching to combine them

Re: report from different variables in diff data sets

PGStats — Tue, 13 Mar 2018 20:50:16 GMT

Here is one of many ways to combine summary data from unrelated datasets

proc sql;

create view tallBoy as
select 
    name,
    height
from sashelp.class
where sex = "M"
having height = max(height);

create view bigCar as
select 
    make,
    model,
    weight
from sashelp.cars
where type = "Sedan"
having weight = max(weight);

quit;

data reportData;
merge tallBoy bigCar;
run;

proc print data=reportData; run;

         Obs     Name     Height       Make            Model         Weight

          1     Philip      72      Volkswagen    Phaeton W12 4dr     5399

Re: report from different variables in diff data sets

mona4u — Thu, 15 Mar 2018 15:23:58 GMT

This is really helpful even though I'm still learning proc sql