Help using Base SAS procedures

Viewing tables

Reply
Contributor spg
Contributor
Posts: 61

Viewing tables

I am using proc sql to create tables but can't view them. Any ideas?

Thanks.
Super Contributor
Super Contributor
Posts: 3,174

Re: Viewing tables

What OS? What SAS version? Is SAS installed locally or on a remote server? How would you like to "view" the tables? How about PROC PRINT or interactive SAS session VIEWTABLE? Also, each SAS-supported OS platform has a "companion guide" which provides some OS-unique characteristics you may want to consider reviewing, beyond the SAS Base product's facilities (for all environments).

Scott Barry
SBBWorks, Inc.

Recommended Google advanced search argument, this topic/post:

view sas table site:sas.com Message was edited by: sbb
Contributor spg
Contributor
Posts: 61

Re: Viewing tables

Windows/9.2/installed locally. I was hoping to see the new tables with the variable transformations that I run using proc sql.

thanks!
Super Contributor
Super Contributor
Posts: 3,174

Re: Viewing tables

How about PROCs like DATASETS, CONTENTS for file/variables and PROC PRINT for variable values?

Consider using SAS Explorer window, drill down to the desired file to get the VIEWTABLE perspective. How about starting with LIBRARIES, SASHELP and look at the file CLASS.

Scott Barry
SBBWorks, Inc.

Recommended Google advanced search argument, this topic/post:

sas introduction explorer window site:sas.com

Also, consider:

http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a002255451.htm
Respected Advisor
Posts: 3,892

Re: Viewing tables

Are you using SAS EG 4.2?

As much as I know when running a SQL create table statement the new data set doesn't open automatically (which is something I like).

If it's EG 4.2: There are some EG options around which allow you to alter the behaviour for newly created tables.

The table should also be added to the library where you created it (you find this under the server where you run this code). It might be necessary to refresh the view for the library and I believe to see the data you have then to add the table to your project... something like this.
I'm also often clicking a bit more than necessary with the new 4.2 version as not everything is that intuitive (even though 4.2 is an improvement over 4.1).

HTH
Patrick
Contributor spg
Contributor
Posts: 61

Re: Viewing tables

I'm using EG 4.2 and I did think that the tables get saved in the library I create. But apparently they don't. I refreshed it too, but no luck.

Thanks!
Contributor spg
Contributor
Posts: 61

Re: Viewing tables

I'm using EG 4.2 and I did think that the tables get saved in the library I create. But apparently they don't. I refreshed it too, but no luck.

Thanks!
Contributor spg
Contributor
Posts: 61

Re: Viewing tables

I'm using EG 4.2 and I did think that the tables get saved in the library I create. But apparently they don't. I refreshed it too, but no luck.

Thanks!
Ask a Question
Discussion stats
  • 7 replies
  • 139 views
  • 0 likes
  • 3 in conversation