I am brand new to this SAS thing. I have a question about making Formats. I have tried make a Format from a explaining, but in this Format I also like to have a "Other=" entry to mark all values outside the defined range, but I do not know how to do. This is the code; but all values go to "???" and not just the number 3 as I expected.
input key name $;
data t2 (drop=key name);
proc format cntlin=t2;
value fmt other='???';
a=3; b=2; c=1;
put a a fmt.;
put b b fmt.;
put c c fmt.;
any help? or are there another post desribing how to do?
DataNull was simply putting in the conditions to include an extra format record in case any of your values fall outside of the defined formats.
You'll notice that both of those statements are only run after all of the records have been read (i.e., at the end of the file).
call missing(Start) simply set the value of start to missing and hlo='O' sets the value of hlo to 'O' or 'other'
> Hi Data_NULL_
> Thanks. Now it is Working.
> However it is a little cryptic code for me,
> I am not Quite sure what the function of "call
> missing(Start); hlo='O' is.
> but thanks,
> Peter Schwennesen