topic Re: Combine multiple datasets into one previous month dataset in SAS Programming

Combine multiple datasets into one previous month dataset

Q1983 — Mon, 28 Mar 2016 14:18:19 GMT

%macro combine;

data lm_all;

set

%do i=1 %to 24;

lossmit.loss_mit_settlements_&last_month.*/ (keep=loan_number type actual_completion_date)

%end;

;

run;

%mend;

%combine;

This code at one time pulled a dataset that already compiled loss_mit settlements into one dataset for the previous month

(ie loss_mit_settlements_20160201

loss_mit_settlements_20160202

loss_mit_settlements_20160203

was automatically compiled into one previous month dataset called loss_mit_settlements_201602

The data no longer offers this. It separates each data set individually. Is there a way to use the same macro to compile all daily datasets into one previous month file to essentially mirror what I used to have when the dataset was combine already.

Re: Combine multiple datasets into one previous month dataset

Astounding — Mon, 28 Mar 2016 14:42:27 GMT

If either of these would be appropriate, they are available:

data im_all;

set lossmit.loss_mit_settlements_2016: (keep=loan_number type actual_completion_date);

run;

data im_all;

set lossmit.loss_mit_settlements_201602: (keep=loan_number type actual_completion_date);

run;

Re: Combine multiple datasets into one previous month dataset

ballardw — Mon, 28 Mar 2016 14:48:38 GMT

You would have to provide more details about the names of the data sets involved.

If this is part of an input proceess you might describe the incoming original datasets and how you read them.

The way your current example macro is displayed you would read a single dataset 24 times as you are not changing the name at all.

Note that if you have similar dataset names you can use a list modifier : to get all of the data sets that start with the same characters. For example if your datasets are loss_mit_settlements_Feb_01 loss_mit_settlements_Feb_02 loss_mit_settlements_Feb_03

then you could use

Set loss_mit_settlements_Feb_: ;

To read all of the sets that start with loss_mit_settlements_Feb_