reading part of file into sas

[sap1958]

I have the following code
data skipped2;
infile 'c:\6411skipped.txt';
input field $ @;
if field = 'CoreID:' then delete;
input field $8-20;
run;

the actual data looks like this
"CoreID:0000202691"
"CoreID:0000221661"
"CoreID:0000198253"
"CoreID:0000202159"

I only want to read the ID number (ie 0000202691)
I named the variable field with the intention of skipping the CoreID: and beginning with the ID.
How can I do this

 

[klaz2002]

Is there always a ':' between the words CoreID: and your ID? If the answer is yes I would read the whole line and extract it from the string using a string function. Using your data as an example here is how I would code it.

data skipped2;
  infile 'c:\6411skipped.txt';
  length mystr $100 MyID $10;
  input mystr &;
  myID = scan(mystr,2,':');
  *** IF YOU WANT TO DROP THE MYSTR VAR FROM YOUR OUTPUT ***;
  DROP mystr;
run;

I hope this helps you.

 

[Asender]

Here is another option to consider:

data skipped;                        
  length MyID $ 10;                    
  infile 'c:\6411skipped.txt' scanover missover;
  input @ ':' MyID $10.; 
run;

A.