Date: Wed, 9 Apr 2003 15:01:39 -0500
Reply-To: "Smith, Curtis, Mr, DCAA" <Curtis.Smith@DCAA.MIL>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Smith, Curtis, Mr, DCAA" <Curtis.Smith@DCAA.MIL>
Subject: Re: PROC COMPARE MVS to PC.
Content-Type: text/plain; charset="us-ascii"
It's been a while since my shop dropped SAS/Connect from our license.
But, if memory serves, because you are referencing library v8 within the
rsubmit block, SAS looks for library v8 on the MVS session. All the code
in the rsubmit block executes on MVS. If you want to mix PC and MVS
libraries, use the remote library services feature.
-----Original Message-----
From: James Castiola [mailto:James.Castiola@UMB.EDU]
Sent: Wednesday, April 09, 2003 11:20 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: PROC COMPARE MVS to PC.
Good afternoon,
I had a question regarding PROC COMPARE and I wonder if anyone can help:
I have used PROC DOWNLOAD to retrieve a SAS data set from the mainframe
and bring it to the PC. It works, but I would like to verify that there
are no transmission errors. I tried to use PROC COMPARE to ensure that
the mainframe data set and the PC data set are identical. The problem I
am having is that I cannot "tell" SAS PC that one data set is on the
mainframe and one is on the PC. The error message in the log keeps
saying that it cannot find the library or data set that is on the PC.
The log is pasted below. Any advice that you folks could offer would be
greatly appreciated. I am using PC SAS version 8.2 and mainframe SAS
version 6.08.
V8 is the PC libname; TEMPO2 is the mainframe libname.
77 *****************************************************************;
78 * PROGRAM NAME: PROCDOWNLOAD_DTALB2 *;
79 *****************************************************************;
84 *****************************************************************;
85 /* CONNECT TO MAINFRAME */
86 OPTIONS SET = VQDLLNAME EHLAPI32;
87 /* PROGRAM TO LINK */
88 %LET LOC = 'C:\Program Files\SAS
Institute\SAS\V8\connect\saslink\MAINBAK.SAS';
89 %LET MYNODE = MY.MAINFRAME.ADDRESS;
90 OPTIONS REMOTE=A COMAMID=EHLLAPI;
91
92 FILENAME RLINK &LOC;
93
94 SIGNON;
NOTE: Remote signon to A commencing (SAS Release 8.02.02M0P012301).
Menu List Mode Functions Utilities Help
ssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss
ssssss
ISPF Command Shell
Enter TSO or Workstation commands below:
===>
Place cursor on choice and press enter to Retrieve command
=> SAS OPTIONS('dmr,comamid=pclink,noterminal')
=> go
=> cmd
=>
=>
=>
=>
=>
=>
=>
In Native TSO -- Entering SAS
*** Remote Link Established ***
NOTE: Copyright (c) 1989-1992 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 6.08 TS430
Licensed to UNIVERSITY OF MASSACHUSETTS, Site 0003307001.
NOTE: Running on IBM Model 2003 Serial Number 6,
IBM Model 2003 Serial Number 6.
*** Welcome to the SAS System, Release 6.08. ***
This SAS process is executing at the Data Processing Center,
located at the Whitmore Administration Building on the Amherst
Campus of the University of Massachusetts. For technical support
issues, you may contact Michael Chmura at (413) 545 - 4673
between the hours of 8:30 AM to 5:00 PM, Monday through Friday.
NOTE: SAS system options specified are:
DMR,COMAMID=PCLINK,NOTERMINAL
NOTE: The initialization phase used 0.17 CPU seconds and 2229K.
NOTE: Remote signon to A complete.
95 RSUBMIT;
NOTE: Remote submit to A commencing.
1 %MACRO DOWNLOAD;
2 LIBNAME TEMPO2 'SAS.OR.COMMON.DATALIB';
3 PROC DOWNLOAD DATA = TEMPO2.LNGF84ON OUT = V8.LNGD84ON;
4 QUIT;
5 RUN;
6 %MEND DOWNLOAD;
7 * %DOWNLOAD * ASTERISK TO
COMMENT OUT;
8
9 %MACRO COMPARE;
10 LIBNAME TEMPO2 'SAS.OR.COMMON.DATALIB';
11
12 PROC COMPARE BASE = TEMPO2.LNGF84ON COMPARE = V8.LNGF84ON;
13 RUN;
14 QUIT;
15 %MEND COMPARE;
16 %COMPARE *
ASTERISK TO COMMENT
NOTE: Libref TEMPO2 was successfully assigned as follows:
Engine: V608
Physical Name: SAS.OR.COMMON.DATALIB
ERROR: Libname V8 is not assigned.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: The PROCEDURE COMPARE used 0.03 CPU seconds and 2845K.
17 OUT;
NOTE: Remote submit to A complete.
96 SIGNOFF;
NOTE: Remote signoff from A commencing.
NOTE: The SAS session used 0.27 CPU seconds and 2845K.
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
Menu List Mode Functions Utilities Help
ssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss
ssssss
ISPF Command Shell
Enter TSO or Workstation commands below:
===>
Place cursor on choice and press enter to Retrieve command
=> SAS OPTIONS('dmr,comamid=pclink,noterminal')
=> go
=> cmd
=>
=>
=>
=>
=>
=>
=>
Signoff Commencing -- Waiting for READY Prompt
Leaving Mainframe SAS
Logoff Complete
NOTE: Remote signoff from A complete.
97 QUIT;
98 RUN;
Thanks.
Jim
James Castiola
Office of Institutional Research
University of Massachusetts, Boston
james.castiola@umb.edu
