Date:         Sat, 15 Aug 1998 00:12:17 -0500
Reply-To:     Gaylen Fraley <gfraley@EARTHLINK.NET>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Gaylen Fraley <gfraley@EARTHLINK.NET>
Organization: EarthLink Network, Inc.
Subject:      Re: Creating a SAS file from DB2 tables

There are several ways to accomplish this.  In this example, the ????????
can be replaced with whatever name you chose.  You also could choose to
create a table instead of a view in the ACCESS procedure.  For a definition
of the statements you should consult your ACCESS manual.
 
 
PROC ACCESS DBMS=DB2;
  CREATE WORK.????????.ACCESS;
  SSID=DB2P;
  TABLE=SHRPUSR.ISI_??;
  ASSIGN=YES;
  CREATE WORK.????????.VIEW;
  SELECT ALL;
  SUBSET WHERE ORGID='SC';
RUN;
 
DATA SASDATA;
  SET ????????;
  ...;
RUN;
 
 
Wei Zhang wrote in message <19980814212407.14200.qmail@hotmail.com>...
>Hello SAS programmers:
>
>Can someone show me a SAS sample code to create a SAS dataset from DB2
>tables using SAS/ACCESS on MVS.  Thanks.
>
>Wei
>
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com