Although tables in SQL databases typically contain massive amounts of data, they’re not always in a format that can be used by data analysts. The data records in these tables need to be filtered ...

DATA step views are very versatile because they can harness the power of SAS DATA step processing, including DO loops and IF-THEN-ELSE statements. DATA step views do not have write capability, that is ...

We have a need to have a view be able to reference columns in another database on another MS SQL 2000 server. Is that going to require linked servers, or is there another syntax or facility? Thanks!

I'm using bcp to dump large quantities of data into a table that has several indexed views built on top of it. It seems to work fine for a while, but on ...

A typical screen in your user interface probably combines data from several different tables. To handle that, I typically have my back-end processes generate Data Transfer Objects (DTOs) which combine ...

Note: The SQL procedure displays the variable labels as stored in the view. However, because you are referencing a view descriptor, you must use the SAS variable names in the WHERE clause, not the ...

Microsoft gave users another reason to download its free SQL Server Reporting Services add-on when it acquired small, privately held ActiveViews. Actually, “small” in this context is something of a ...