Date:         Tue, 4 Dec 2001 16:33:00 -0500
Reply-To:     mcallasterd@LEE.ARMY.MIL
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "McAllaster, Douglas L. LTC" <mcallasterd@LEE.ARMY.MIL>
Subject:      consecutive delimiters
Comments: To: SAS-L@UGA.CC.UGA.EDU
Content-Type: multipart/alternative;

Folks,

This must have been solved...

Is there an easy way to tell SAS that consecutive delimiters means that the
value is missing?

I thought about pre-processing the file with translate,
but translate doesn't seem to allow insertion.

code & data follow (the 5th line "bolt, shear" causes the problem)

data  amdf1;
  infile  file1 dlm='|' missover;
  input
    fsc
    niin
    uprice
    sos     $
    ui      $
    nomen   $; run;

===file1====
7210|000547910|41.60|GSA|DZ|PILLOWCASE|
5360|000548367|.64|S9I|EA|SPRING,HELICAL,COMPRESSION|
2510|000548372|2.46|S9C|EA|BLOCK,MOUNTING|
5340|000548390|7.30|S9I|EA|BRACKET,MOUNTING|
5306|000548513||||BOLT,SHEAR|
1680|000548689|54.52|S9G|EA|CUSHION,SEAT AIRCRAFT|
3110|000548823|61.15|S9G|EA|BEARING,BALL,ANNULAR|
5305|000549240|.22|S9I|EA|SCREW,MACHINE|
5305|000549241|19.36|S9I|HD|SCREW,MACHINE|
5305|000549243|1.28|S9I|EA|SCREW,MACHINE|


LTC Doug McAllaster
McAllasterD@Lee.Army.Mil


[text/html]