topic Re: Charachter Value under numeric variable in SAS Programming

Charachter Value under numeric variable

VaheMartirosyan — Sun, 18 Apr 2021 11:23:46 GMT

I need some explanation

Re: Charachter Value under numeric variable

Kurt_Bremser — Sun, 18 Apr 2021 11:10:31 GMT

Special missing value (assigned as .D).

Example:

data test;
num = 1;
output;
num = .d;
output;
run;

Re: Charachter Value under numeric variable

VaheMartirosyan — Sun, 18 Apr 2021 11:12:34 GMT

How I can remove it ?

Re: Charachter Value under numeric variable

SASKiwi — Sun, 18 Apr 2021 11:14:43 GMT

As requested: https://support.sas.com/kb/64/582.html

Re: Charachter Value under numeric variable

Kurt_Bremser — Sun, 18 Apr 2021 11:18:26 GMT

@VaheMartirosyan wrote:

How I can remove it ?

Such values do not magically appear out of nowhere, someone defined them, probably for a reason, so I would be very careful before replacing them with a simple missing value (.).

Re: Charachter Value under numeric variable

Kurt_Bremser — Sun, 18 Apr 2021 11:26:06 GMT

I extracted the pictures from your docx and inserted them with the "camera" button. It is much better to post pictures directly than embedding them in Office documents which are then attached. Many members here work behind firewalls that prevent the download of such potentially dangerous files.