Missing Values in SAS

Posted on Mar 28, 2015 in Computer Science • Tagged with programming, SAS, missing values, null, white space

Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives.

  1. SAS uses a dot (.) to stand for a numeric missing value and any number (can be 0 which correspond to the blank string "") of white spaces (e …


Continue reading

Write User-defined Functions in SAS

Posted on Sep 28, 2014 in Computer Science • Tagged with programming, SAS, user-defined function, `FCMP`

Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives.

** Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives. **

FCMP Procedure

  1. The maximum …


Continue reading

The Confusing String in SAS

Posted on Sep 28, 2014 in Computer Science • Tagged with programming, SAS, String, data type

Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives.

** Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives. **

  1. the min function also …


Continue reading

Macro in SAS

Posted on Nov 28, 2009 in Computer Science • Tagged with dot, SAS, macro, branch, programming

Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives.

** Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives. **

Here are some examples …


Continue reading

The Trap of Duplicated Columns in the SQL Procedure of SAS

Posted on Aug 28, 2015 in Computer Science • Tagged with programming, SAS, SQL

Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives.

** Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives. **

If 2 columns with …


Continue reading

SAS SQL Tips

Posted on Jun 28, 2014 in Computer Science • Tagged with programming, SAS, tips, SQL

Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives.

** Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives. **

  1. A const column does …

Continue reading