topic SAS consolidate datasets in SAS Data Management

Consolidate datasets

Citrine10 — Fri, 09 Sep 2022 14:18:23 GMT

Hi there

I would like to consolidate datasets from a library where all the datasets are stacked. I would only like to select certain columns from the dataset to be consolidated.

SAS consolidate datasets

Citrine10 — Fri, 09 Sep 2022 14:32:24 GMT

Hi there I would like to consolidate datasets from a library where all the datasets are stacked. I would only like to select certain columns from the dataset to be consolidated.

Re: SAS consolidate datasets

ballardw — Fri, 09 Sep 2022 15:00:24 GMT

Note: duplicate posts combined.

You may have to provide an example of what you mean by "consolidate" and "stacked" in this context.

I would typically think "stacked" meant two or more data sets had already by appended or "consolidated" into a single set.

You may be better off leaving your data as needed and just use a WHERE statement or clause to select the variables for use at any given time than to make subsets of data.

Re: Consolidate datasets

Patrick — Sun, 11 Sep 2022 03:34:25 GMT

If the tables in your source library follow a naming convention like have_1, have_2, have_3, .... then you can use the column modifier as a wildcard to address them all.

data want;
  set have_:(keep=col1 col2);
run;

Re: Consolidate datasets

RacheLGomez123 — Mon, 21 Nov 2022 07:43:55 GMT

Steps for data consolidation
Data consolidation usually involves four layers of technology: data sources, an ETL (extract, transform and load) data pipeline, a data warehouse destination, and business intelligence (BI) tools.

Regards,
Rachel Gomez