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?
"Arthur Tabachneck" <art297@NETSCAPE.NET> wrote in message
> I'm a bit confused. Wouldn't something as simple as:
> proc sql noprint;
> create table airportdictionary
> like SASUSER.AIRPORTS
> do what you are trying to accomplish?
> 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
> >proc sql;
> > create table airportdictionary as
> > select *
> > from dictionary.columns
> > where libname='SASUSER'
> > and memname='AIRPORTS';
> >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?