SAS error "insufficient memory" on remote queries with wide rows

This post was kindly contributed by Heuristic Andrew - go there to comment and to read the full post.

SAS can give the error The SAS System stopped processing this step because of insufficient memory when querying a single, wide row from a remote SQL Server. The following code fully demonstrates the problem and shows a workaround. Also, I eliminate the explanation that SAS data sets in general do not support rows this wide.

Read more »

This post was kindly contributed by Heuristic Andrew - go there to comment and to read the full post.