Date:         Wed, 2 Mar 2011 12:26:44 +0000
Reply-To:     "Fehd, Ronald J. (CDC/OCOO/ITSO)" <rjf2@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Fehd, Ronald J. (CDC/OCOO/ITSO)" <rjf2@CDC.GOV>
Subject:      Re: proc contents
In-Reply-To:  <017FB41275AE7A46988755E60E32F4010537A68884@UTHCMS3.uthouston.edu>
Content-Type: text/plain; charset="us-ascii"

see also:

%Let In_Lib  = Library;
%Let In_Data = MySPSS_daymare;

%Let In_Lib  = SAShelp;
%Let In_Data = Class;

PROC SQL; describe table &In_Lib.. &In_Data.;
          select name
          from Dictionary.Columns
          where Libname eq "%upcase(&In_Lib.)"
            and MemName eq "%upcase(&In_Data.)"
          order by Name;*etc.;
          quit;

Ron Fehd the dictionary maven

> -----Original Message-----
> From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-
> l@listserv.uga.edu] On Behalf Of Swank, Paul R
> Sent: Tuesday, March 01, 2011 5:35 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: proc contents
>
> Someone who shall remain nameless has sent me an SPSS data set of over
> 12000 variables. After finally getting it converted to a .por file and
> bringing it into SAS I want to get a short list of the variable names
> so I can cut and paste them in my program. None of the filenames make
> any sense and are not ordered to make it easy to specify ranges of
> variables. I usually do this with "proc contents short;" However, while
> "proc contents;" will list the entire set of variable names with labels
> etc to the output window, "proc contents short;" will not. It truncates
> the list of variables. Does anyone have a clue how I can get around
> this problem. I'm trying not to have to type hundreds of variable names
> in my program nor copy and paste them one at a time.
>
> Dr. Paul R. Swank,
> Professor and Director of Research
> Children's Learning Institute
> University of Texas Health Science Center-Houston