Date:         Wed, 11 Jun 2003 08:47:07 -0400
Reply-To:     "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Subject:      Re: encrypt sas dataset specific column

You can use a password protected data set for you and and data view for
others. The view supplies the read password and keeps only columns you want
the use to see.

data passwd (alter=alter_pw read=read_pw);
  input user $ pass $;
cards;
foo bar
bar foo
;
run;

data users / view=users;
  set passwd (read=read_pw keep=user);
run;

proc print data=passwd; run; * needs password;
proc print data=passwd(read=read_pw); run;
proc print data=users;  run;

--
Richard A. DeVenezia, http://www.devenezia.com
"Tony" <hztangli@YAHOO.COM> wrote in message
news:200306110628.h5B6SQk07489@listserv.cc.uga.edu...
> Hi All,
> I have a sas dataset called passwd,which contains two column,USER and
> PASSWORD.I want other people also can open the dataset and see value in
> USER column,but they can only see encrypted value(not the real value) in
> PASSWORD column,but in my sas program logic I should be able to use the
> real value,for example:
>  data _null_;
>    if user='Scott' and password='tiger' then
>    ...
> In short,the dataset looks similar to passwd file on unix.
> How can I encrypt dataset's specific column?
> Thanks,
> Tony