Data Manipulation Tools in R

Posted on Jan 11, 2016 in Programming • Tagged with programming, CRAN, data manipulation, data.table, plyr, sets, 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. **

RJDBC

data.table do …


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

Manipulate Data in SAS

Posted on Jul 02, 2012 in Computer Science • Tagged with programming, SAS, SQL, data step, data manipulation

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

Data Manipulation

  1. Create a user library if you want your SAS data sets to persist. For example, the following code creates a library named lib which points …


Continue reading

Add Sequential ID for Observations in SAS

Posted on Jun 20, 2015 in Computer Science • Tagged with programming, SAS, SQL, sequential, ID, observation

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. **

data s1; set s …


Continue reading