Could not Read the below data into the SAS Data Set

Chikku — Fri, 11 Apr 2014 04:30:24 GMT

182-04-7814ASPDEN530

302-57-5023ATWOOD480

123-89-8470BROSNAN560

152-64-0014BROSSO780

813-63-7456CUTCHINS790

186-79-3143HOLERBACH670

Thank you:)

Re: Could not Read the below data into the SAS Data Set

SKK — Fri, 11 Apr 2014 06:48:45 GMT

Hi,

Do you want the entire value in single variable ???

Re: Could not Read the below data into the SAS Data Set

RW9 — Fri, 11 Apr 2014 08:22:12 GMT

That's straightforward:

data want;

attrib var1 format=$200.;

infile datalines;

input var1 $;

datalines;

182-04-7814ASPDEN530

302-57-5023ATWOOD480

123-89-8470BROSNAN560

152-64-0014BROSSO780

813-63-7456CUTCHINS790

186-79-3143HOLERBACH670

;

run;

Though I presume you mean you want to read it in as separate variables? If so post process it, here is a quick example, you just need to do substrings and chop it up (or use perl regular expressions).

data want;

set want;

attrib first_string second_string format=$20. lastnum format=best.;

first_string=substr(var1,1,10);

lastnum=input(reverse(substr(reverse(strip(var1)),1,3)),best.);

second_string=substr(var1,11,length(strip(var1))-3);

run;

topic Re: Could not Read the below data into the SAS Data Set in SAS Programming

Could not Read the below data into the SAS Data Set

Re: Could not Read the below data into the SAS Data Set

Re: Could not Read the below data into the SAS Data Set