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;
Warning-- Geek Content
This is a blog is more or less a scrap book of my SAS Knowledge.
Tuesday, December 14, 2010
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
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
Subscribe to:
Posts (Atom)