Date:         Mon, 27 Oct 2008 19:35:49 -0500
Reply-To:     Lou <lpogoda@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Lou <lpogoda@HOTMAIL.COM>
Organization: Aioe.org NNTP Server
Subject:      Re: Dataset from Dictionary?
Comments: To: sas-l@uga.edu

"Arthur Tabachneck" <art297@NETSCAPE.NET> wrote in message
news:200810272316.m9RKxsTJ015427@malibu.cc.uga.edu...
> Ken,
>
> I'm a bit confused.  Wouldn't something as simple as:
>
> proc sql noprint;
>   create table airportdictionary
>    like SASUSER.AIRPORTS
> ;
> quit;
>
> do what you are trying to accomplish?
>

or

data airportdictionary;
   set sasuser.airports;
   stop;
run;

???


> Art
> ---------
> On Mon, 27 Oct 2008 16:59:49 -0600, Ken Barz <Ken.Barz@CPCMED.ORG> wrote:
>
> >I'm doing some work aiming towards CDISC compliance and I was wondering
> >if there's an easy way to go from a data dictionary type of dataset
> >(e.g.)
> >
> >
> >
> >proc sql;
> >
> >  create table airportdictionary as
> >
> >  select *
> >
> >  from dictionary.columns
> >
> >  where libname='SASUSER'
> >
> >    and memname='AIRPORTS';
> >
> >quit;
> >
> >
> >
> >and create an empty dataset 'airport' using the variable names, lengths,
> >types, ... already contained in the dictionary.  I know I can data step,
> >or proc sql, a solution, but I was wondering if there's already some
> >form of proc or a macro out there that already does this?
> >
> >Thanks,
> >
> >Ken