BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
sivastat08
Pyrite | Level 9

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

 

Thanks,

Siva

1 ACCEPTED SOLUTION

Accepted Solutions
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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?

View solution in original post

6 REPLIES 6
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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
Pyrite | Level 9

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

Kurt_Bremser
Super User

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
Pyrite | Level 9

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
Super User

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
Super User Tom
Super User

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;

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 1928 views
  • 6 likes
  • 4 in conversation