topic Re: update overwritten sashelp vtable in SAS Programming

update overwritten sashelp vtable

sivastat08 — Thu, 07 Mar 2019 13:15:39 GMT

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

Thanks,

Siva

Re: update overwritten sashelp vtable

RW9 — Thu, 07 Mar 2019 13:20:56 GMT

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?

Re: update overwritten sashelp vtable

Kurt_Bremser — Thu, 07 Mar 2019 13:33:38 GMT

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.

Re: update overwritten sashelp vtable

sivastat08 — Thu, 07 Mar 2019 13:33:59 GMT

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

Re: update overwritten sashelp vtable

sivastat08 — Thu, 07 Mar 2019 13:40:26 GMT

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.

Re: update overwritten sashelp vtable

Kurt_Bremser — Thu, 07 Mar 2019 13:47:04 GMT

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.

Re: update overwritten sashelp vtable

Tom — Thu, 07 Mar 2019 15:35:52 GMT

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;