Learning SAS? Welcome to the exclusive online community for all SAS learners.

Missing Numeric Value in Proc Format

Reply
Occasional Contributor
Posts: 5

Missing Numeric Value in Proc Format

Hi All

Missing Numeric value is considered the smallest value in SAS. But when using with PROC Format, the LOW keyword doesn't recognize missing value(period) as lowest value? Instead it goes to Other. What could be the reason for thiss

Proc format ;

    value fmt low - <100='T1'

                100-<500='T2'

                500-high='T3'

                other='Inavlid';

run;

Data s1;

    input num;

    datalines;

100

200

300

.

400

;

proc print data=s1;

format num fmt.;

Super User
Super User
Posts: 6,500

Re: Missing Numeric Value in Proc Format

Because that is what the keyword LOW means in the PROC FORMAT.

If you want to make a range that includes missing values then use the missing values in the range.

proc format ;

  value x ._ = 'Lowest missing' .='Normal missing'  .a-.z='Special missing' low-high='Regular number';

run;

Ask a Question
Discussion stats
  • 1 reply
  • 234 views
  • 0 likes
  • 2 in conversation