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 (March 2011, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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:  <>
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: [mailto:owner-sas- >] 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

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