https://communities.sas.com/t5/SAS-Programming/several-data-sets-in-one-report/m-p/372528#M89077 <P>Hello.</P><P>&nbsp;</P><P>Dears, I should create a report which must consist of several data sets.For instance I should extract some figures from the first dataset, make some culculations in the second dataset, compare the results and so on. Can I create some connections between the datasets, or maybe should merge them.</P><P>&nbsp;</P><P>&nbsp;</P><P>How to handle in such cases, when have data stored in several datasets?&nbsp;</P><P>&nbsp;</P><P>thanks beforehand.</P> Sun, 02 Jul 2017 12:12:12 GMT Garik 2017-07-02T12:12:12Z https://communities.sas.com/t5/SAS-Programming/several-data-sets-in-one-report/m-p/372528#M89077 <P>Hello.</P><P>&nbsp;</P><P>Dears, I should create a report which must consist of several data sets.For instance I should extract some figures from the first dataset, make some culculations in the second dataset, compare the results and so on. Can I create some connections between the datasets, or maybe should merge them.</P><P>&nbsp;</P><P>&nbsp;</P><P>How to handle in such cases, when have data stored in several datasets?&nbsp;</P><P>&nbsp;</P><P>thanks beforehand.</P> Sun, 02 Jul 2017 12:12:12 GMT https://communities.sas.com/t5/SAS-Programming/several-data-sets-in-one-report/m-p/372528#M89077 Garik 2017-07-02T12:12:12Z https://communities.sas.com/t5/SAS-Programming/several-data-sets-in-one-report/m-p/372560#M89100 I could suggest you to create one final dataset with all the derivations and variables you want to display in the report. Use that dataset in proc report. Sun, 02 Jul 2017 15:08:42 GMT https://communities.sas.com/t5/SAS-Programming/several-data-sets-in-one-report/m-p/372560#M89100 Jagadishkatam 2017-07-02T15:08:42Z