News

PROC SQL Pass-Through Views A Version 6 PROC SQL Pass-Through view does not need to be updated to be used in Version 7 or Version 8. The conversion of PROC SQL Pass-Through views is automatic and does ...
You can either create a PROC SQL view on a DICTIONARY table or you can use the SASHELP views, as described in Accessing DICTIONARY Tables with SASHELP Views. You can then use the view in a DATA or ...
Running on SQL Server 2008 (so views support parameters I believe). Looking for the best way to manage giving out controlled and restricted access to our data based on logins. Basic example. A ...
Twice in the past couple of months I’ve gotten tripped up by the same data issue when using LINQ to Entities in the .NET framework. I create a simple view in my database which performs some ...