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.)
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;
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.
Database Editor, The Washington Post
(202) 334-5047, firstname.lastname@example.org