okay, I described the view with proc sql. and I got   how can I turn it so that I can use it as a data set so that I can follow the original code used in the book? ... View more

yep the bug still exist. It should be a sas studio bug because the same issue does not happen when I type in the same code in SAS EG on work computer.     ... View more

btw, how did you capture gif and upload it? ... View more

thanks, the issue has been there a couple of weeks old now at least.   ... View more

@Ksharp wrote: proc sql number; select * from sashelp.fish where species="Pike"; quit;   oh wow, that was efficient! ... View more

@Tom wrote: Did you try clearing the Chrome cache?  This types of in browser apps are notorious for getting confused if you have an old version cached. thanks! that fixed the issue. I thought SAS studio is run on the cloud and everything is displayed real time independent of cache.   anyways, chrome performance is much smoother/faster than firefox. Good to get back. ... View more

chrome Version 109.0.5414.120 (Official Build) (64-bit).   Just restarted chrome, still same issue.   I want to clarify to everyone that double clicking either sas7dbat file or sas library file will NOT show preview, not just only the sas7dbat file. ... View more

@tom_grant wrote: Still works for me - which browser are you using?? Hey, I just tried with Firefox, worked fine. But won't work on Chrome. ... View more

@ChrisHemedinger wrote: I'm not sure how this worked before, but viewing a data set in SAS requires that you have a library assigned to that folder. Perhaps there was a shortcut that assigned a temp libname to the folder that contained the data you clicked on...I was not aware of this behavior in SAS Studio.   Best practice would be to assign a libname to your ../cert folder and then open the data that way, especially if you intend to write code against it. This would ensure a consistent libname in your process. In SAS studio, double clicking either .sas7dbat in a folder or a SAS table in library will open up preview of the table. ... View more

Hi Mark, I don't how much changes there are between SAS 9 and 9.4, I am pretty confident I'll will pass the advance programming exam with the 2014 prep guide as I don't think the impact will affect advance programming. I will finish this 2014 prep guide plus other sas books on proc sql and macro that can be found on the internet and then take practice exam before deciding if it is necessary to spend money on getting the 2019 copy. ... View more

Yes I know. Unless I can get or buy a DRM free PDF version of the 2019 prep guide, I am sticking to the 2014 edition. Reason being that SAS prep guide will contain many errors, with DRM free PDF, I can quickly edit out mistakes on the fly, crop out margins, easily attach images, and most importantly, linking URLs to questions I ask on this forum. ... View more