Stored processes can be called via the SAS Stored Process Web Application using a URL. Though powerful and useful, the advanced usage concerning ranges requires explanation. Background Say you have a program called /path/myprogram on server sasserver, …
Tag: howto
Make SAS PROC SQL UPDATE faster with CALL EXECUTE
I have an ETL job that updates 10,000 rows in a large, remote Microsoft SQL table with 700,000 rows (1.4%). (The specific brand of remote SQL database doesn’t matter: this should work equally well for any ODBC RDMS.) This tutorial shows two ways …
Setting the HTML title tag in SAS ODS (the right way)
In our department and various places on the Intertubes, SAS programmers set the HTML title tag (which sets the title in web browsers and on search engines) in ODS using the headtext option: ods html headtext="<title>My great report</tit…