Date: Thu, 12 Feb 2004 15:02:48 -0600
Reply-To: "Morris, Joyce B." <JoyceMo@HEALTH.STATE.OK.US>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Morris, Joyce B." <JoyceMo@HEALTH.STATE.OK.US>
Content-Type: text/html; charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE></TITLE>
</HEAD>
<BODY>
<BR>
<BR>
<P><FONT SIZE=2>NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.</FONT>
<BR><FONT SIZE=2>NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)</FONT>
<BR><FONT SIZE=2> Licensed to OK DEPARTMENT OF HEALTH, Site 0008898002.</FONT>
<BR><FONT SIZE=2>NOTE: This session is executing on the WIN_PRO platform.</FONT>
</P>
<P><FONT SIZE=2>My data analyst is trying to run a dataset but it wants a password. He does not have the problem except when he issues a command such as Proc Sort which changes the dataset. Below is the log that includes his commands and the responses. Can someone help? TIA</FONT></P>
<P><FONT SIZE=2>Joyce Morris, PhD, CHES</FONT>
<BR><FONT SIZE=2>Program Evaluation Coordinator</FONT>
<BR><FONT SIZE=2>Tobacco Use Prevention Service</FONT>
<BR><FONT SIZE=2>Oklahoma State Department of Health</FONT>
<BR><FONT SIZE=2>1000 NE 10th St</FONT>
<BR><FONT SIZE=2>Oklahoma City OK 73117-1299</FONT>
<BR><FONT SIZE=2>(405) 271-3619</FONT>
</P>
<BR>
<P><FONT SIZE=2>NOTE: SAS initialization used:</FONT>
<BR><FONT SIZE=2> real time 0.75 seconds</FONT>
<BR><FONT SIZE=2> cpu time 0.40 seconds</FONT>
</P>
<P><FONT SIZE=2>1 libname amir 'a:';</FONT>
<BR><FONT SIZE=2>NOTE: Libref AMIR was successfully assigned as follows:</FONT>
<BR><FONT SIZE=2> Engine: V8</FONT>
<BR><FONT SIZE=2> Physical Name: A:\</FONT>
<BR><FONT SIZE=2>2 run;</FONT>
<BR><FONT SIZE=2>3</FONT>
<BR><FONT SIZE=2>4 proc sort data=amir.Okhpb_comanche_02;</FONT>
<BR><FONT SIZE=2>5 by cr1;</FONT>
<BR><FONT SIZE=2>6 run;</FONT>
</P>
<P><FONT SIZE=2>ERROR: Invalid or missing ALTER password on member AMIR.OKHPB_COMANCHE_02.DATA.</FONT>
<BR><FONT SIZE=2>NOTE: The SAS System stopped processing this step because of errors.</FONT>
<BR><FONT SIZE=2>NOTE: PROCEDURE SORT used:</FONT>
<BR><FONT SIZE=2> real time 9.69 seconds</FONT>
<BR><FONT SIZE=2> cpu time 0.00 seconds</FONT>
</P>
</BODY>
</HTML>
