topic Re: stacking datasets horizontally in SAS Programming

stacking datasets horizontally

manya92 — Tue, 05 Jun 2018 16:49:10 GMT

How to stack mroe than 2 datasets horizontally ? using sas or PROC SQL .

Re: stacking datasets horizontally

PaigeMiller — Tue, 05 Jun 2018 16:55:32 GMT

In a SAS data set, the MERGE statement allows you to do this.

Re: stacking datasets horizontally

ballardw — Tue, 05 Jun 2018 16:55:48 GMT

Example data and desired output for the example data would help.

If the data is to match on some variable(s) it is important to know if the values of the match variables are unique (only one record per data set) or duplicated and if duplicated in which data set(s).

When a one-to-one combining often the SAS data step merge is easiest but does require sorting both data sets by the matching variables first.

Re: stacking datasets horizontally

manya92 — Tue, 05 Jun 2018 17:08:56 GMT

The individual datasets look like in the word file.. and the excel table is what it should look like :

I was thinknig of using MACROS and merge datastep .. but dont know how to use macros.

%macro main(drug, where) ;

%mend main ;
%main(oni, new_linename EQ 'Onivyde');
%main(fol, new_linename EQ 'FOLFOX');
%main(folnox, new_linename EQ 'FOLFIRINOX');
%main(folfri, new_linename EQ 'FOLFIRI');
%main(gem, new_linename EQ 'Gemcitabine,Paclitaxel Protein-Bound');
%main(all, new_linename in ('Onivyde','FOLFOX','FOLFIRI','FOLFIRINOX','Gemcitabine,Paclitaxel Protein-Bound')

datastep :-

data _03_stack ;
merge _03_oni _03_fol _03_folnox _03_folfri _03_gem _03_all ;
by a col ;
run ;

Re: stacking datasets horizontally

Reeza — Tue, 05 Jun 2018 17:14:06 GMT

That's a report. If you want the table at the top, look at PROC REPORT or PROC TABULATE for starters. You can find a paper called 'Creating Complex Reports' by Cynthia Zender, it has a lot of good examples and code that illustrate how to get the reports you've shown.

@manya92 wrote:

The individual datasets look like in the word file.. and the excel table is what it should look like :

I was thinknig of using MACROS and merge datastep .. but dont know how to use macros.

%macro main(drug, where) ;

%mend main ;
%main(oni, new_linename EQ 'Onivyde');
%main(fol, new_linename EQ 'FOLFOX');
%main(folnox, new_linename EQ 'FOLFIRINOX');
%main(folfri, new_linename EQ 'FOLFIRI');
%main(gem, new_linename EQ 'Gemcitabine,Paclitaxel Protein-Bound');
%main(all, new_linename in ('Onivyde','FOLFOX','FOLFIRI','FOLFIRINOX','Gemcitabine,Paclitaxel Protein-Bound')

datastep :-

data _03_stack ;
merge _03_oni _03_fol _03_folnox _03_folfri _03_gem _03_all ;
by a col ;
run ;

Re: stacking datasets horizontally

ballardw — Tue, 05 Jun 2018 17:17:36 GMT

Your word document shows reports, not data sets. You might be much better off finding the data sets used to create the report tables, combine those and make a new report from the combined data.

Especially since the two tables you show in your document do not look alike.

Or show what your actual datasets look like as that document may be very misleading.

Re: stacking datasets horizontally

PaigeMiller — Tue, 05 Jun 2018 17:19:07 GMT

I don't see any compelling reason to use a macro here. But if it is already written ...