topic Re: Proc format for negative numbers in SAS Procedures

Proc format for negative numbers

starz4ever2007 — Tue, 09 Aug 2016 19:16:46 GMT

Dataset:

subj score

1 -5.3

2 -3.4

3 1.6

4 0.4

5 -6.4

6 0

How would I make a new variable (score 2) where all negative values are now missing (.)?

Re: Proc format for negative numbers

paulkaefer — Tue, 09 Aug 2016 19:20:51 GMT

How's this?

data testSet;
   input subj score;
   datalines;
1 -5.3
2 -3.4
3 1.6
4 0.4
5 -6.4
6 0
;

proc format;
    value formatName low-<0 = .
          other = [7.2];
run;

proc sql;
    select subj
          ,score format formatName.
    from testSet;
quit;

Re: Proc format for negative numbers

starz4ever2007 — Tue, 09 Aug 2016 19:33:53 GMT

how would i make the data into a new variable in my data set?

Re: Proc format for negative numbers

Reeza — Tue, 09 Aug 2016 19:43:27 GMT

If you want to recode it, use an IF condition instead.

IF score<0 then score=.;