Outlook: Trying to Connect

This is how I solved a problem of Microsoft Outlook 2010 “Trying to Connect” for several days.


Dummy coding in SAS

Here is a macro to generate binary features (also called dummy coding) from a nominal variable (also called a categorical variable, such as eye color). This is also called one-hot encoding and one-of-K encoding. The automation saves time and avoids mistakes when there are many possible values to a category or the values can change.

Easy sortable HTML tables in SAS ODS

Today Charlie Huang posted a SAS HTML table sorting demo, but without automation. Here is a fully automated implementation in SAS. The developer does not need to manually edit the HTML, and the user simply clicks any column and it sorts instantly client-side in the web browser. The feature is automatically applied to all SAS tables in the ODS HTML output.

Word could not create the work file. Check the temp environment variable

Encrypting the Microsoft Windows temporary folder causes Microsoft Outlook 2010 to not open Word file attachments because of these “cryptic” errors: Word could not create the work file. Check the temp environment variable The file (filename) cannot be opened because there are problems with the contents. Unspecified error Location: Part: /word/document.xml, Line:2, Column:0 Run this…

List of zip codes and cities affected by Hurricane Sandy

The following is a list of states, counties, cities, and zip codes affected by Hurricane Sandy. The counties were pulled from the FEMA web site on November 5 and limited to a small subset designated Individual Assistance (apparently, the areas with the most damage). Then the zip codes were added by merging with an up-to-date…

Phone number validation in SAS

In SAS it’s trivial to perform basic validation of a US phone number using a regular expression, and this SAS macro goes way behind the basic validation rules: it checks several rules, in service area codes, directory service, and special phone numbers. Simple unit testing ensures the macro works as intended.