update overwritten sashelp vtable

[sivastat08]

I have mistakenly overwritten  sashelp.vtable  now the table is empty.Could you please help on recreating  sashelp.vtable.

Thanks,

Siva

[RW9 · Accepted solution]

Restart SAS.  Also depends on what software you are using (i.e. EG, Univerisity Edition etc.).  How did you manage it, isn't sashelp read only?

[sivastat08]

 Thanks for  reply,I am using EG 7.1 with server space , also have a read and write access.

[Kurt_Bremser]

The sashelp.v... "tables" are in fact SQL views that point to the dynamically created SQL dictionary tables. These tables are virtual themselves.

The SASHELP library cannot be overwritten by any user other than a superuser or the SAS install user. Why do you think you "overwrote" SASHELP.VTABLE?

On a UNIX system, the view file can be found in SASROOT/SASFoundation/9.4/sashelp as vtable.sas7bvew.

[sivastat08]

yes sir i do have a sas Installation access.In SAS EG 7.1  - SASHELP Vtable is doesn't have any data.Also i have read and write access for my sas server.  

[Kurt_Bremser]

If you are actually using a userID that has write access to the SAS installation to work with SAS from Enterprise Guide, then you had it coming to you. That's shaking cocktails with nitro glycerine.

If that was the case and you managed to trash your SAS installation, re-install SAS from scratch and let it be a lesson to you. Never use an install user to work with SAS.

SAS technical support might be able to help you in a way that doesn't need a re-install.

[Tom]

The definition of that view is very simple.

4     proc sql ;
5     describe view sashelp.vtable;
NOTE: SQL view SASHELP.VTABLE is defined as:

        select *
          from DICTIONARY.TABLES;

6     quit;

So to re-create it just point a libref at the folder where the original view was and re-create it.

libname fix '.....';
proc sql;
create view fix.vtable as
select * from DICTIONARY.TABLES
;
quit;