Date:         Wed, 14 Jan 2004 13:59:25 -0500
Reply-To:     Dan T Keating <keatingd@WASHPOST.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Dan T Keating <keatingd@WASHPOST.COM>
Subject:      Data view input vs output
Content-type: text/plain; charset=US-ASCII

I'm creating a data view to get a subset that I want to move to SQL Server.
I regularly use views to get sets for moving to excel or the server, etc.

In this case, I'm getting the following error message:

ERROR: The requested type of view (Input or Output) cannot be determined.
NOTE: View not saved due to errors.

In short, the data step looks like:

%let keepvars =  ... long list of variable names here ....;

data togo01 / view=togo01;
length newvar $20;
set  lib.data00 (keep=&keepvars.)
        lib.data01 (keep=&keepvars.)
        lib.data02 (keep=&keepvars.)
        lib.data03 (keep=&keepvars.);
where ... blah, blah, blah;
newvar = "Most of them";
if .. blah, blah, blah, then newvar = "The Others";
drop var1;* used in 'where' but no longer needed;
run;

Because I need to get it done, I ran it just creating a temp dataset
togo01. That ran with no problems.

But due to its size I'd rather not have to do it again. And I want to know
what I was doing wrong.  I haven't found it in the docs.

Any guidance greatly appreciated.

Dan
_________________________________
Dan Keating
Database Editor, The Washington Post
(202) 334-5047, keatingd@washpost.com