Date:         Sat, 24 Nov 2007 10:03:48 -0500
Reply-To:     Ken Borowiak <EvilPettingZoo97@AOL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ken Borowiak <EvilPettingZoo97@AOL.COM>
Subject:      Re: retrieving code used to create view

On Sat, 24 Nov 2007 07:55:52 -0600, data _null_, <datanull@GMAIL.COM> wrote:

>For data step view.
>
>data work.testV / view=work.testV;
>   set sashelp.class;
>   x = 2;
>   run;
>data view=work.testV;
>   describe;
>   run;


... and also use DESCRIBE for an SQL view:
* Example ;
proc sql ;
  describe view Sashelp.VColumn ;
  quit ;

NOTE: SQL view SASHELP.VCOLUMN is defined as:

        select *
          from DICTIONARY.COLUMNS;

5      quit ;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.64 seconds
      cpu time            0.17 seconds


HTH,
Ken


>On Nov 23, 2007 9:22 PM,  <toby989@hotpop.com> wrote:
>> I have a view sitting in front of me, but I dont have the sas script anymore
>> used to create that view. Isnt the sas script (a data step or a proc sql)
stored
>> also together with the view? if so, how can I look at it (modify it)?
>>
>> Thanks Toby
>>