Tuesday, December 14, 2010

Producing a Row Number using Proc SQL

This is an undocumented feature of SAS, where in we can achieve a feature similiar to the _N_ of the Data step using the Proc SQL

PROC SQL;
SELECT MONOTONIC() AS Row_Number FORMAT=COMMA6.,
ITEM,
UNITS,
UNITCOST FROM PURCHASES;
QUIT;

/* 2.3.4.11 Code Example: Producing a Row Number with the NUMBER Option */
PROC SQL NUMBER;
SELECT ITEM,
UNITS,
UNITCOST
FROM PURCHASES;
QUIT;

Wednesday, December 1, 2010

5 Ways to Secure your Passwords in SAS

I always wondered if there is a better way to secure a password in a SAS Program other than the Proc Pwencode procedure which Encrtyps the password in the program, However any user though not knowing your password can actually run your program and obtain the results, all that the Proc Pwencode does is to protect your password from others looking over your shoulder.

Off late I came across a SAS Blog that gives us 5 ways to secure/eliminate the password(Including the Pwencode), Quiet Interesting Ain't it??

http://blogs.sas.com/sasdummy/index.php?/archives/222-Five-strategies-to-eliminate-passwords-from-your-SAS-programs.html