| Date: | Tue, 17 Mar 2009 12:12:35 -0500 |
|---|
| Reply-To: | "./ ADD NAME=Data _null_;" <iebupdte@GMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | "./ ADD NAME=Data _null_;" <iebupdte@GMAIL.COM> |
|---|
| Subject: | Re: Extract word from a line in the raw data file |
|---|
|
| In-Reply-To: | <200903171421.n2HAmW37026048@malibu.cc.uga.edu> |
|---|
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
data need;
informat library $8. member $64.;
infile cards dlm='. ';
input @'FROM' library member;
cards4;
20090913:10:23:36: 00000002 FROM ABC.ADDRESS_RAWDATA AS ADDRESS_RAWDATA
20090913:10:23:36: 00000002 FROM ABCDEF.NAMES_RAWDATA AS NAMES_RAWDATA
20090913:10:23:36: 00000002 IOM LOG (73,20):111 FROM
DATAABC.WHATEVER_RAWDATA AS WHATEVER_RAWDATA
;;;;
run;
proc print;
run;
On 3/17/09, Abc Unha <abcunha@yahoo.com> wrote:
> The issue it does not start at 28 everytime. It varies almost everytime.
> Only unique value to identify line is libref i.e. abc abcdef and dataabc.
> I can get full line but need to extract only table name.
> so for e.g. from below good lines. I only need "ABC.ADDRESS_RAWDATA"
> or "DATAABC.WHATEVER_RAWDATA"
>
> 20090913:10:23:36: 00000002 FROM ABC.ADDRESS_RAWDATA AS ADDRESS_RAWDATA
> 20090913:10:23:36: 0000000002 IOM LOG (73,20):111 FROM
> DATAABC.WHATEVER_RAWDATA AS WHATEVER_RAWDATA
>
| 
