topic Re: Replacing values with text but got just 2 characters in SAS Programming

Replacing values with text but got just 2 characters

Idi — Thu, 18 Jul 2024 09:11:30 GMT

Hello ,

I have data with multiples columns : A -- Q
Inside the column i have 3 valies : N/A , Yes , No
I want to replace Yes with a text like :
If A = Yes then A = "L'utilisateur marche bien "
But i got only : L'u

And i want to replace all the N/A and No with blank : " " just blank.

Can you help please ?

Thanks so much

Re: Replacing values with text but got just 2 characters

PaigeMiller — Thu, 18 Jul 2024 09:49:32 GMT

Easier would be to use custom format

proc format;
     value $fmt 'Yes'="L'utilisateur marche bien" 'No','N/A'=' ';
run;
data want;   
    set have;
    format a--q $fmt.;
run;

The reason your code won't work without modification is that A--Q has a length of 3 characters, this doesn't change when assigning the value L'utilisateur marche bien, you only get the first 3 characters. You would need use a LENGTH statement to change this.

length a--q $ 25;

because the text you want is 25 characters. But really, use the easier approach which is PROC FORMAT above.

Re: Replacing values with text but got just 2 characters

PaigeMiller — Thu, 18 Jul 2024 10:19:28 GMT

@Idi Please don't write followup questions in the field for tags. Please write your followup question by clicking on "Reply".

Re: Replacing values with text but got just 2 characters

Idi — Thu, 18 Jul 2024 10:35:49 GMT

Thank you so much

Re: Replacing values with text but got just 2 characters

Idi — Thu, 18 Jul 2024 10:39:42 GMT

Thank you so much its works very well. Just another question : if the string value IS différent for B C ... Q . I Have différent text value for each columns. For A= "l'utilisateur marche bien". I have another text for B etc -- Q

Re: Replacing values with text but got just 2 characters

PaigeMiller — Thu, 18 Jul 2024 11:49:37 GMT

Then you will need different formats for each variable.