topic Re: how to replace a value to blank in SAS Data Management

how to replace a value to blank

dustychair — Thu, 06 Sep 2018 19:44:18 GMT

Hi everyone,

I want to change value of "N" to blank in one of variables in my data. I used the code below but I did not get any results and I think that code is replacing values with "." I could not find what I'm missing.

Thanks

proc export data=model
outfile= "C:\data_reading.txt"
DBMS=tab replace; putnames=no;
run;

data reading1;
set data_reading;
if Reading_Raw_Scores=N then call missing (of Reading_Raw_Scores);
run;

*******************

my data:

5854378 1111NNNNNNNNNNNNNNN111101111001NNNNNNNNNNNN
6710686 1000001000000100000NNNNNNNNNNNNNNNNNNNNNNNN
5789905 1111NNNNNNNNNNNNNNN111111111111NNNNNNNNNNNN
6169024 1111NNNNNNNNNNNNNNN111110111111NNNNNNNNNNNN
6966627 1000100000110000010NNNNNNNNNNNNNNNNNNNNNNNN
6530308 1011NNNNNNNNNNNNNNN111101100111NNNNNNNNNNNN
6530613 1000NNNNNNNNNNNNNNN110100111010NNNNNNNNNNNN
5585170 1111NNNNNNNNNNNNNNN111111101111NNNNNNNNNNNN
6427927 1010111111100011110NNNNNNNNNNNNNNNNNNNNNNNN
5994414 0101001011000001111NNNNNNNNNNNNNNNNNNNNNNNN
6244942 1101NNNNNNNNNNNNNNN010000100001NNNNNNNNNNNN
4911740 1111NNNNNNNNNNNNNNN111101110110NNNNNNNNNNNN
5845509 1111NNNNNNNNNNNNNNN100000110100NNNNNNNNNNNN
4905478 1000011110011011010NNNNNNNNNNNNNNNNNNNNNNNN
5244869 1110NNNNNNNNNNNNNNN001100100101NNNNNNNNNNNN
5654158 1110NNNNNNNNNNNNNNN110000000101NNNNNNNNNNNN
6012869 1110NNNNNNNNNNNNNNN010111000000NNNNNNNNNNNN
4943032 1100011111111111111NNNNNNNNNNNNNNNNNNNNNNNN
5233136 1101NNNNNNNNNNNNNNN110110100001NNNNNNNNNNNN

Re: how to replace a value to blank

novinosrin — Thu, 06 Sep 2018 19:50:08 GMT

are you looking to translate?

data w;
Reading_Raw_Scores='1111NNNNNNNNNNNNNNN111101111001NNNNNNNNNNNN';
Reading_Raw_Scores=translate(Reading_Raw_Scores,' ','N');
run;

Re: how to replace a value to blank

dustychair — Thu, 06 Sep 2018 20:00:27 GMT

Yes, it worked.

Many thanks

Re: how to replace a value to blank

data_null__ — Fri, 07 Sep 2018 12:54:34 GMT

Do you want to read 43 responses into separate variables?

Another example using the MISSING statement.

data scores;
   missing n;
   input id:7. (q1-q43)(1.);
   cards;
5854378 1111NNNNNNNNNNNNNNN111101111001NNNNNNNNNNNN
6710686 1000001000000100000NNNNNNNNNNNNNNNNNNNNNNNN
5789905 1111NNNNNNNNNNNNNNN111111111111NNNNNNNNNNNN
6169024 1111NNNNNNNNNNNNNNN111110111111NNNNNNNNNNNN
6966627 1000100000110000010NNNNNNNNNNNNNNNNNNNNNNNN
6530308 1011NNNNNNNNNNNNNNN111101100111NNNNNNNNNNNN
6530613 1000NNNNNNNNNNNNNNN110100111010NNNNNNNNNNNN
5585170 1111NNNNNNNNNNNNNNN111111101111NNNNNNNNNNNN
6427927 1010111111100011110NNNNNNNNNNNNNNNNNNNNNNNN
5994414 0101001011000001111NNNNNNNNNNNNNNNNNNNNNNNN
6244942 1101NNNNNNNNNNNNNNN010000100001NNNNNNNNNNNN
4911740 1111NNNNNNNNNNNNNNN111101110110NNNNNNNNNNNN
5845509 1111NNNNNNNNNNNNNNN100000110100NNNNNNNNNNNN
4905478 1000011110011011010NNNNNNNNNNNNNNNNNNNNNNNN
5244869 1110NNNNNNNNNNNNNNN001100100101NNNNNNNNNNNN
5654158 1110NNNNNNNNNNNNNNN110000000101NNNNNNNNNNNN
6012869 1110NNNNNNNNNNNNNNN010111000000NNNNNNNNNNNN
4943032 1100011111111111111NNNNNNNNNNNNNNNNNNNNNNNN
5233136 1101NNNNNNNNNNNNNNN110110100001NNNNNNNNNNNN
;;;;
   run;
proc print;
   run;

Re: how to replace a value to blank

dustychair — Fri, 07 Sep 2018 20:51:56 GMT

Hi data_null__,

it sets each value to separate variables but still N is there.

Re: how to replace a value to blank

data_null__ — Fri, 07 Sep 2018 21:52:07 GMT

Missing N one of the 27 special missing values ._ .A-.Z