topic Re: Concatenating multiple datasets vertically into the same dataset using ODS output. in ODS and Base Reporting

Concatenating multiple datasets vertically into the same dataset using ODS output.

pambardar — Mon, 11 Apr 2016 05:12:37 GMT

I am trying to create one dataset(pos) from 2 datsets (abc , def) like below

member variable num

---------- ---------- ------

abc avar1 1

abc avar2 2

def dvar1 1

def dvar2 2

using ods statement

ods output position=pos (keep=member variable num where=(num<=2));
proc contents data=abc varnum;
run;
ods output close;

ods output position=pos (keep=member variable num where=(num<=2));
proc contents data=def varnum;
run;
ods output close;

My problem is when I run the second ods output staement for 'def' , it overwrites the 'pos' dataset that was created for 'abc' dataset.

i want to concatenate the outputs of 2 ods statements vertically into one dataset.

Kurt_Bremser — Mon, 11 Apr 2016 05:41:07 GMT

ODS OUTPUT creates a new dataset, therefore the old dataset is overwritten.

Use two different dataset names in the ODS OUTPUT statements and concatenate them later with a data step, or do not close/reopen the ODS destination.

LinusH — Mon, 11 Apr 2016 06:56:15 GMT

Using ODS to output data is a great possibility. Which I use only when I can't get the data I want any "regular way".

What I can see from your desired output, this information is available directly in SASHELP.VCOLUMN and DICTIONARY.COLUMNS.

RW9 — Mon, 11 Apr 2016 08:20:01 GMT

There is nothing to concatenate:

data want;
  set sashelp.vcolumn;
  where libname="WORK" and memname in ("ABC","DEF");
run;

pambardar — Mon, 11 Apr 2016 13:59:45 GMT

Thanks. Tried with dictionary.columns and it worked.