SAS help Merging Data

tagawa_sas — Thu, 10 Dec 2020 15:10:40 GMT

Hey All!

Was hoping that you could help me with this.

I am currently running a macros, in which I am creating X number of datasets (code is below).

%MACRO RunANOVA (Variable = , Number = );
ODS TRACE ON;
PROC ANOVA
DATA = Work.data
ORDER = INTERNAL;
CLASS StateCd;
MODEL &Variable = StateCd;
RUN;
QUIT;
ODS TRACE OFF;

ODS OUTPUT OverallANOVA = WORK.ANOVAResults&Number
ModelANOVA = WORK.ModelResults&Number;

PROC ANOVA
DATA = Work.data
ORDER = INTERNAL;
CLASS StateCd;
MODEL &Variable = StateCd;
RUN;
QUIT;

DATA WORK.ANOVAResults&Number;
RETAIN Variable Dependent FValue ProbF;
SET WORK.&Number;
KEEP Variable Dependent FValue ProbF;
Variable = &Number;
Run;

%MEND RunANOVA;

I can then merge all the datasets together using the following code below.

DATA work.ANOVAResults;
SET WORK.ANOVAResults:;
RUN;

My question is that is there a way manipulate the Data step from the code above to merge only every nth dataset?

For example, I have a total of 100 datasets (HypRslt.ANOVAResults1-100) and I want to merge every 10th dataset. I know that I could use the following code below to get this done.

DATA Work.ANOVAResults;
SET WORK.ANOVAResults10

WORK.ANOVAResults20

WORK.ANOVAResults30

WORK.ANOVAResults40

WORK.ANOVAResults50

WORK.ANOVAResults60

WORK.ANOVAResults70

WORK.ANOVAResults80

WORK.ANOVAResults90

WORK.ANOVAResults100;
RUN;

However, I was wondering if there was a simpler way to code this, so that if I wanted to merge very 9th dataset instead of every 10th dataset, I could easily do this without having to write out the name of each dataset.

If you could let me know if this is possible, or if you need more information, it would be greatly appreciated.

Thanks,
Alex

Re: SAS help Merging Data

ChrisNZ — Wed, 09 Dec 2020 01:44:13 GMT

Something like this?

%macro loop(skip=);
  %local i;
  %do i=1 %to 100 %by &skip.;
     WORK.ANOVARESULTS&i.
  %end;
%mend;

data RESULTS;
  set %loop(skip=9);
run;

Re: SAS help Merging Data

tagawa_sas — Thu, 10 Dec 2020 15:05:09 GMT

Yes that is exactly what I needed. Did not think to do another macro

topic Re: SAS help Merging Data in SAS Programming

SAS help Merging Data

Re: SAS help Merging Data

Re: SAS help Merging Data