Consolidate datasets

[Citrine10]

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. 

[Citrine10]

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. 

[ballardw]

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.

[Patrick]

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;

[RacheLGomez123]

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