topic Re: SAS MANIPULATING MISSING DATA in SAS Studio

SAS MANIPULATING MISSING DATA

fabdi — Fri, 17 Feb 2017 06:10:05 GMT

Hello!

I am trying to manipulate the dataset in SAS. I'd like to change my numerical values such as 5 to a . (period) to represent the missing data so it won't count.

I am not sure how to go about it. Please help!

I'm new to SAS.

Re: SAS MANIPULATING MISSING DATA

Miracle — Fri, 17 Feb 2017 07:43:37 GMT

Hi, there are many ways to do this.
Such as using if/else statement, proc format or ifn.
HTH.

Re: SAS MANIPULATING MISSING DATA

ankit___gupta — Fri, 17 Feb 2017 07:45:20 GMT

data more_vars_and_people;
input x y z;
cards;
12 5 9
1 5 30
7 5 20
8 2 3
;
run;


DATA more_vars_and_people;
modify more_vars_and_people;
if y=5 then y=.;
run;

This is an example..

Hope it helps

Re: SAS MANIPULATING MISSING DATA

fabdi — Sun, 19 Feb 2017 00:27:24 GMT

Hello!

Thank you for the response!

Hm, I tried creating a new data set (new2) and coding that way. I'm not sure what I am doing wrong.

here is my code.... I am trying to recode all the -99 into . so that it does not count as my data and SAS will consitute it as missing.

q1a = variable

data new2; set new;

if q1a<0 THEN q1a=.; run;

~ SASbeginner

Re: SAS MANIPULATING MISSING DATA

Miracle — Sun, 19 Feb 2017 03:32:47 GMT

Hi, did you want to recode q1a=. when q1a=5 and q1a=-99?
if so, the if statement should be: if q1a in (-99,5) then q1a=.;

Re: SAS MANIPULATING MISSING DATA

fabdi — Sun, 19 Feb 2017 04:09:38 GMT

Thank you for the response!

I want to recode just -99 to .

This what I am inputting:

data new2; set new;

if q1a=-99 THEN q1a=.; run;

I'm still seeing -99 counted in my data. I'm not sure what the problem is.

Re: SAS MANIPULATING MISSING DATA

Miracle — Sun, 19 Feb 2017 04:53:52 GMT

Hi, what does the log say?

The sample code below correctly recoded either numeric or character variables to missing from -99.

data test; 
	numeric=-99; 
	char='-99'; 
	if numeric=-99 then numeric=.; 
	if char='-99' then char=''; 
run;
proc print noobs; run;

Re: SAS MANIPULATING MISSING DATA

ankit___gupta — Mon, 20 Feb 2017 13:10:49 GMT

Hi fabdi,

There is nothing worng with the code as such. The only concern i have is the part where u mention.

"q1a = variable ". Can you elaborate on this part.

else everthing is correct.

Thank You.