This is one of those situations where I would scrap the proc contents and
append and go directly to the table which proc contents uses to generate its
Proc SQL ;
Select Quote( UpCase( FileName ) ) Into : FNames Separated by ' '
From Data.Files ;
Create Table AllMyContents AS
Where Libname = 'WORK'
And MemName in ( &Fnames ) ;
The obscure we see eventually. The completely obvious, it seems, takes
longer. ~Edward R. Murrow
Think like a man of action, act like a man of thought. ~Henri Louis Bergson
Alice came to a fork in the road. "Which road do I take?" she asked.
"Where do you want to go?" responded the Cheshire cat.
"I don't know," Alice answered.
"Then," said the cat, "it doesn't matter."
~Lewis Carroll, Alice in Wonderland
From: BitByte <lieuwe.de.haan@GMAIL.COM>
Reply-To: BitByte <lieuwe.de.haan@GMAIL.COM>
Subject: Re: Saving proc contents for more datasets in one file
Date: Thu, 26 Oct 2006 00:41:31 -0700
Thanks for the help (Jim and Richard).
With your help I was able to solve my problem. Following did the trick:
length bestand $9;
CALL EXECUTE ('PROC Contents DATA=data.' || COMPRESS(Bestand) || '
out=data.' || COMPRESS(Bestand) ||'_pc;RUN;');
CALL EXECUTE ('PROC Append DATA=data.' || COMPRESS(Bestand) ||'_pc
And again... many thank you's for helping me out!
> Dear all,
> I have a wish but have no idea how to work things out. I have the
> data data.files;
> length file $8;
> input file;
> data data.files (drop=total);
> set data.files;
> total + 1;
> call symputx('last',total);
> Now the problem starts....
> How do I create a do loop that creates a proc contents and appends this
> output for all of these datasets in one file...
> I hope someone has brighter ideas than me at this point
> Greetings Lieuwe
Get today's hot entertainment gossip