LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2008, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page