philihp.com

If you stick a file named autoexec.sas in the directory where SAS is installed, it will run automatically when SAS starts up. By default, this place is C:\Program Files\SASHome\SASFoundation\9.3. This has worked since at least SAS 8.2, probably before. I like to use my Windows desktop as a temporary staging area, so I have my [...]

New to SAS 9.3 is the ability of Proc SQL’s ability to reuse the database connection from a LIBNAME statement in a direct pass-through query. Ability to Reuse the LIBNAME Statement Database Connection The database connection that is established with the LIBNAME statement can be reused in the CONNECT statement. The keyword USING has been [...]