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).
Recommended Google advanced search argument, this topic/post:
view sas table site:sas.com
Message was edited by: sbb
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).