missing values

[Raj00007]

M. Grany Southern Magnolia 85 15 E green
M. Disuzaa                             86 20 D rose
M. Manglic Lily      Magnolia   22 14 D purple
M. Dharmendra      Magnolia  25 3 D pink
M. Farukha Star     Magnolia 12 3 D black

in the above data,  i have a missing value in 2nd row. i know that we can read missing values by using missover with infile. but how to read inbetween missing values  using infile statement.

[Tom · Accepted solution]

More likely you need to change the INPUT statement.

It is not clear whether your data is in fixed columns or not.  If it is in fixed columns then you don't need to do anything.  If the values are free flowing then you either need either type a period where the missing value should be or switch to using a delimited file.  If you make a delimited file then make sure to use the DSD option so that adjacent delimiters are interpreted as denoting a missing value.

PS:  Don't use MISSOVER, unless you really want SAS to ignore values at the end of lines that are too short for the informat width being used.  Use TRUNCOVER instead.

[Kurt_Bremser]

To get solid help for this, it is ABSOLUTELY necessary that you do NOT post your input data in the main posting window, but copy/paste it into a window opened with the </> button. Do not skip this.