topic Re: missing values in New SAS User

missing values

Raj00007 — Thu, 13 Aug 2020 16:56:28 GMT

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.

Re: missing values

Tom — Thu, 13 Aug 2020 17:02:11 GMT

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.

Re: missing values

Kurt_Bremser — Thu, 13 Aug 2020 17:31:37 GMT

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.