topic Re: Viewing tables in SAS Procedures

Viewing tables

spg — Fri, 05 Mar 2010 15:13:39 GMT

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

Thanks.

Re: Viewing tables

sbb — Fri, 05 Mar 2010 16:10:07 GMT

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

Re: Viewing tables

spg — Fri, 05 Mar 2010 20:53:02 GMT

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

thanks!

Re: Viewing tables

sbb — Fri, 05 Mar 2010 21:21:16 GMT

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

Re: Viewing tables

Patrick — Sun, 07 Mar 2010 04:44:34 GMT

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

Re: Viewing tables

spg — Mon, 08 Mar 2010 14:39:34 GMT

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!

Re: Viewing tables

spg — Mon, 08 Mar 2010 14:39:38 GMT

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!

Re: Viewing tables

spg — Mon, 08 Mar 2010 14:39:55 GMT

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!