Date:         Tue, 3 Oct 2006 16:22:13 -0400
Reply-To:     "Fehd, Ronald J. (CDC/CCHIS/NCPHI)" <rjf2@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Fehd, Ronald J. (CDC/CCHIS/NCPHI)" <rjf2@CDC.GOV>
Subject:      Re: long macro variable in SASHELP.VMACRO?
Content-Type: text/plain; charset="us-ascii"

noone should attempt to deconstruct file-specs from a macro variable
like this.
How did you build this macro variable in the first place?

Anyway, I have a couple of answers to processing a list of files
which I am presenting at a Hands-On-Workshop titled
How To Use Proc SQL select into for List Processing
at both
* MWSUG in Detroit,  MI, Oct 23-24
* PNWSUG in Seaside, OR, Oct 30-31

see you there!

Ron Fehd  the select into mvar maven  CDC Atlanta GA USA RJF2 at cdc dot
gov

> -----Original Message-----
> From: owner-sas-l@listserv.uga.edu
> [mailto:owner-sas-l@listserv.uga.edu] On Behalf Of data _null_;
> Sent: Tuesday, October 03, 2006 4:03 PM
> To: SAS-L@listserv.uga.edu
> Subject: long macro variable in SASHELP.VMACRO?
>
> Imagine the following data set is the value of one macro
> variable as it would look in SASHELP.VMACRO.  I have
> shortened the length of value from 200 to 60, to make it
> easier to "see" everything.
>
> data work.offset;
>    infile cards;
>    attrib offset length=8;
>    attrib value length=$60 ;
>    input offset 5. +1 value $char60.;
>    cards;
>     0 D:\Program Files\SASOnlineDocV8\sasdoc\saspdf\win\a01.pdf|D: