|Date: ||Mon, 27 Oct 2008 17:28:42 -0600|
|Reply-To: ||Ken Barz <Ken.Barz@CPCMED.ORG>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Ken Barz <Ken.Barz@CPCMED.ORG>|
|Subject: ||Re: Dataset from Dictionary?|
|Content-Type: ||text/plain; charset="us-ascii"|
Well, yeah, I was just using airports and dictionary.columns as an
example of a similar dictionary. In the CDISC implementation guide,
they give the tables, variables, labels, , type, formats, ... in a data
dictionary format. So, I don't have an actual dataset that I can use
Since there's a whole slew of these things that need creating (and
across many different studies), I was hoping to pull the dictionary in
using Excel and have some way to use that metadata to create the actual
From: Arthur Tabachneck [mailto:art297@NETSCAPE.NET]
Sent: Monday, October 27, 2008 5:17 PM
To: SAS-L@LISTSERV.UGA.EDU; Ken Barz
Subject: Re: Dataset from Dictionary?
I'm a bit confused. Wouldn't something as simple as:
proc sql noprint;
create table airportdictionary
do what you are trying to accomplish?
On Mon, 27 Oct 2008 16:59:49 -0600, Ken Barz <Ken.Barz@CPCMED.ORG>
>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
> create table airportdictionary as
> select *
> from dictionary.columns
> where libname='SASUSER'
> and memname='AIRPORTS';
>and create an empty dataset 'airport' using the variable names,
>types, ... already contained in the dictionary. I know I can data
>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?