topic Re: how to assign blanks for numeric variable in SAS Programming

how to assign blanks for numeric variable

mona4u — Tue, 24 Apr 2018 20:27:04 GMT

I have this sample of the variable which is the result of merging datasets

I need to know how I can assign blanks for the value of 0 and . if the variables are numeric without mentioning the variables names

I have too many variables and I don't want to do it by if statement for each variable individually

do you have suggestions?

this is my sample

ESCGI	Open_GI	TOTAL_PACs_GI	hptotal_cases1	hp_pendingreview
.	.	.	.	.
.	.	.	.	.
.	.	.	.	.
.	.	.	.	.
0	0	53	0	0
.	.	.	.	.
.	.	.	.	.
.	.	.	.	.
.	.	.	.	.
.	.	.	.	.
0	0	1	.	.
.	.	.	.	.
.	.	.	.	.
.	.	.	.	.
.	.	.	.	.
0	0	1	.	.
.	.	.	.	.
.	.	.	.	.
0	0	25	0	0
.	.	.	.	.
0	0	1	.	.
0	0	1	.	.
0	0	1	.	.
.	.	.	.	.
.	.	.	.	.
0	0	1	.	.
.	.	.	.	.
0	0	2	.	.
.	.	.	.	.
0	0	4	0	0
0	0	6	0	0
0	0	2	0	0
0	0	2	0	0
.	.	.	.	.
0	0	2	0	0
0	0	2	0	0
0	0	1	0	0
.	.	.	.	.
0	0	2	0	0
.	.	.	.	.
0	0	1	.	.
.	.	.	.	.
.	.	.	.	.
.	.	.	.	.
2	1	24	0	0
.	.	.	.	.
0	0	10	0	0
.	.	.	.	.
.	.	.	.	.
.	.	.	.	.
.	.	.	.	.
0	0	1	0	0
0	0	1	0	1
.	.	.	.	.
.	.	.	.	.
.	.	.	.	.
.	.	.	.	.
.	.	.	.	.
.	.	.	.	.

Re: how to assign blanks for numeric variable

SuryaKiran — Tue, 24 Apr 2018 20:36:32 GMT

data want;
set have;
array change_num _numeric_;
do over change_num;
if change_num=. then change_num=0;
end;
run;

Check this, will change all numeric with missing values to 0

Re: how to assign blanks for numeric variable

LinusH — Tue, 24 Apr 2018 20:47:48 GMT

You can't assign a blank to a numerical column.
You can however chose to display missing values as a blank using the MISSING system option.

Re: how to assign blanks for numeric variable

Astounding — Tue, 24 Apr 2018 20:48:49 GMT

There is no such thing. It is not possible for numeric variables to take on a value of blank. The best you can do is this:

options missing=" ";

That causes missing values for numeric variables to be displayed as a blank when reporting. But the value that is stored, and the value that you would refer to in your programming statements is still a dot not a blank.

If you wish, you can convert zero to a missing value:

if var = 0 then var = .;

After that, the missing= option would apply. First, you have to decide whether changing zero to missing is actually destroying some of your information.

Re: how to assign blanks for numeric variable

Reeza — Tue, 24 Apr 2018 20:49:16 GMT

Use a format.

proc format;
value my_cust_fmt
0, . =' '
other = [best8.];
run;

data have;
set sashelp.class;
if age in (12, 10) then call missing(age, height);

format _numeric_ my_cust_fmt.;
run;

Re: how to assign blanks for numeric variable

mona4u — Wed, 25 Apr 2018 13:33:46 GMT

Thanks so much this is so efficient

Re: how to assign blanks for numeric variable

mona4u — Wed, 25 Apr 2018 13:35:17 GMT

This is a good soln but I have to call each variable if var = 0 then var = .; which will consume time