topic Re: remove period in numeric format in SAS Programming

remove period in numeric format

J_hoon — Wed, 20 Mar 2019 07:24:03 GMT

Hello

When I coding, I have problem.

I load excel file in sas.

When I load excel file, the data set present period (.) in blank cell.

But I want to remove this period.

How can I remove period in numeric format??

Please, Help me. Everyone~~

Re: remove period in numeric format

Kurt_Bremser — Wed, 20 Mar 2019 07:31:07 GMT

The period is essential when working with SAS, as it is the displayed character for missing numerical values. All SAS programmers expect missing values to be displayed as a dot, if no special option is set.

That option is

options missing = ' ';

See this example code:

data have;
input x1;
cards;
1
2
.
;
run;

proc print data=have;
run;

options missing = ' ';

proc print data=have;
run;

Result:

Beob.    x1

  1       1
  2       2
  3        
            

Beob.    x1

  1       1
  2       2
  3

Re: remove period in numeric format

PeterClemmensen — Wed, 20 Mar 2019 07:31:13 GMT

Remember that the . is SASs representation of a missing numeric value. However, you can do something like this


options missing='';

data test;
var=1;output; /* Non missing value */
var=.;output; /* Missing value     */
run;

proc print data=test;
run;

Re: remove period in numeric format

ballardw — Wed, 20 Mar 2019 15:30:00 GMT

Or use a custom format to displayed desired text instead:

proc format library=work;
value m
. = 'Missing'
;
run;

data test;
var=1;output; /* Non missing value */
var=.;output; /* Missing value     */
run;

proc print data=test;
   format var m.;
run;