Date:         Fri, 23 Jan 2004 14:40:32 -0500
Reply-To:     Debbie Cooper <debbie.cooper@STEVENSONCOMPANY.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Debbie Cooper <debbie.cooper@STEVENSONCOMPANY.COM>
Subject:      Dropping variables in a macro
Content-Type: text/plain; charset="iso-8859-1"

You have helped me out before so I thought I'd try again.  I have the
following code:


%include 'd:\programs\ssi\brwindoor.sas';
%include 'd:\programs\ssi\outwindoor.sas';

*** Window and Door runfirst ****;

%include 'd:\programs\ssi\2003m12\window\ssiprod221.sas';
%include 'd:\programs\ssi\2003m12\window\ssiprod224.sas';
%include 'd:\programs\ssi\2003m12\window\ssiprod223.sas';
%include 'd:\programs\ssi\2003m12\window\ssiprod226.sas';
%include 'd:\programs\ssi\2003m12\window\ssiprod225.sas';

%brconv1 (window0312a);
%brconv1 (doorpat0312a);
%brconv1 (doorent0312a);
%brconv1 (doorstrm0312a);
%brconv1 (doorgar0312a);

%outconv (window0312a);
%outconv (doorpat0312a);
%outconv (doorent0312a);
%outconv (doorstrm0312a);
%outconv (doorgar0312a);

The problem is that there are a bunch of variables in (for example)
ssiprod224 that don't belong in any of the other datasets.  But because of
the order in which things run, they get picked up by all the datasets.  Even
if I create another
%include program that drops out variables, it will drop out the variables
from all the datasets and that isn't what I want.  Short of creating a drop
program for each of the datasets, is there any way to get rid of the
variables that are getting picked up by the other datasets?

Thanks,
Debbie