About Idi

Idi · ‎07-18-2024

Okay, thanks a lot, but its seems to be working well . Its solved the problem anyway.

Idi · ‎07-18-2024

Thank you so much @PaigeMiller , @Tom , @Ballarddw I combined your answers the two proc codes helped me to understand the length of my data and i use length full $700 and and finally everything is displayed correctly proc contents data=work.consoli; run; proc print data=work.consoli (obs=95); var A B C; run; data work.amel; set work.consoli; length A $ 200; length B $ 200; length C $ 255; length full $ 700; full=catx(';',A,B,C); run;

Idi · ‎07-18-2024

StringA B and C are in dataset , i have no values in var full with your method. Thanks for yr help

Idi · ‎07-18-2024

I Have data inside my columns

Idi · ‎07-18-2024

Hello, I want to concat 3 columns but the content are to large, in the final concat i got blank. Exemple : columns A , B, C => after concat ; var full = A;B;C But i just got Blank, if B and C are empty i get A, because not to large but if A, B, C are not empty i get Blank. because to large string inside. My code : data work.amel; set work.consoli; full = catx(";", A,B,C); run; Thank you so much

Idi · ‎07-18-2024

Hello, i'm trying to concatenate 3 columns separated by commas but the final result: full displays nothing it's totally empty because the text is too large example: varA “stringA............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................stringA ” in varB i have : "stringB............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................stringB in varC : "stringC............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................stringC after concat I must have var full = varA;varB;varC with long texts separated by commas Mycode : data work.amel; set work.consoli; full = catx(";",A,B,C); I got blank

Idi · ‎07-18-2024

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

Idi · ‎07-18-2024

Thank you so much

Idi · ‎07-18-2024

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

Idi · ‎08-22-2023

Thank you so much for your help.

Idi · ‎08-22-2023

Thank you

Idi · ‎08-22-2023

Hi , I want to change multiple column : All the columns start with : td_ha. After the . I have the Real name of the columns like : t_test Td_ha.t_test = i want only t_test I have 156 columns start with : td_ha. I just want to be After the point. Thank you.

Idi · ‎08-22-2023

TesSAS I have multiples columns starts with td_tou_ha.t_sadi , td_tou_ha.t_haba Etc.... All the columns start with td_tou_ha. I want to keep only names After the point (.) For example : t_sadi , t_haba etc. Using SAS studio. Macro or SQL any help please ? Thanks you so for your help. I try rename fonction but its to much i want to do with macro but never use or.t

Online Status	Offline
Date Last Visited	‎07-19-2024 01:56 PM

Re: Concat with catx don't works , my string value to large

Re: Concat with catx don't works , my string value to large

Re: Concat with catx don't works , my string value to large

Re: Concat with catx don't works because to large string

Concat with catx don't works , my string value to large

Concat with catx don't works because to large string

Re: Replacing values with text but got just 2 characters

Re: Replacing values with text but got just 2 characters

Replacing values with text but got just 2 characters

Re: Keep names of multiples columns After a specific caracter

Re: Concat with catx don't works , my string value to large

Re: Concat with catx don't works , my string value to large

Re: Concat with catx don't works , my string value to large

Re: Concat with catx don't works because to large string

Re: Replacing values with text but got just 2 characters

Re: Concat with catx don't works , my string value to large

Re: Concat with catx don't works , my string value to large

Re: Concat with catx don't works , my string value to large

Re: Concat with catx don't works because to large string

Concat with catx don't works , my string value to large

Concat with catx don't works because to large string

Re: Replacing values with text but got just 2 characters

Re: Replacing values with text but got just 2 characters

Replacing values with text but got just 2 characters

Re: Keep names of multiples columns After a specific caracter

Re: Keep names of multiples columns After a specific caracter

Keep names of multiples columns After a specific caracter

Rename multiples columns