The PWENCODE SAS procedure enables you to encode passwords that can be used in place of plain-text passwords in SAS programs that access relational database management systems (RDBMSs), SAS/SHARE servers, and SAS Integrated Object Model (IOM) servers (such as the SAS Metadata Server).
PROC PWENCODE IN=’password’
specifies the password to encode. password can have no more than 512 characters. password can contain letters, numerals, spaces, and special characters
Have you ever wondered, Why SAS never had functions similar to any other programming Language i.e. C, C++, Java…
LINK/ Return statement and SAS Macros to some extent served the purpose in modularizing and developing re-usable code for repeating tasks…but doesn’nt make it is easy to follow….Macros are easier to reuse; however, they are not independent from the main program, they involve non-DATA step syntax, and substantial use of macros can result in illegible code.
Interactive Processing is used for any of the interactive SAS systems (ASSIST, CALC, etc.), for SAS/GRAPH when the graphics output is to be displayed on the screen of a graphics terminal, or when wanting to see the results of a relatively small SAS program without the need for printed output.
Execute the SAS program as you are sitting in front of your terminal, and see the results of each DATA or PROCedure step as it completes. The program could be entered using ISPF before invoking SAS and then included into the interactive session, entered under the Display Manager during the interactive session, or there can be no actual programming required (as when using SAS/ASSIST).