About indox

indox · ‎09-23-2021

Hi, thanks for your answer. But i really want to keep gen value as rand('uniform') -> With single quotes and use compress when executing it in the %put statement. Thanks

indox · ‎09-22-2021

Hello, %let gen=(rand('uniform')); %put %sysfunc(compress(&gen,%str(%'))); This is my code above. I want the second line to execute the %put rand(uniform) and give me a number instead of returning then string "(rand(uniform))". Thanks for help.

indox · ‎02-27-2019

hello, I have this ID Marks 1 25 1 30 2 75 2 98 I want this: ID Marks 1 25, 30 2 75, 98 thanks for help

indox · ‎09-05-2018

This is beautiful ! thank you !

indox · ‎09-04-2018

Thanks for your answer. I knew about this solution is not there a simple way to do it? Because besides firstnames and lastnames, I have 2 adresses 2 birth dates etc... Thanks

indox · ‎09-04-2018

We are going to use the final table to send mails. If a person has different firstnames or lastnames, we have to send as many letters to reach the person. If the person has 2 firstnames and only one lastname there will be 2 lines etc... I don't know if i am clear sorry

indox · ‎09-04-2018

Hello, How can we go from Id LastName1 LastName2 FirstName1 FirstName2 1 Smith Garcia James Michael 2 Jack Tom Oliver to Id LastName FirstName 1 Smith James 1 Smith Michael 1 Garcia James 1 Garcia Michael 2 Jack Tom 2 Jack Oliver Thank you for help ! Regards,

indox · ‎03-02-2018

awesome! thank you. could you please explain this: if NOT(c{i}=word or c{i}='') then result='diff'; thanks

indox · ‎03-02-2018

c1--c2--c3--c4--result a--a--a--a--same a--a--{empty}--a--same a--b--a--a--not same a--b--{empty}--a--not same This is what I want. Thanks

indox · ‎03-02-2018

data want(drop=count i); set have; array _v{*} c1 c2 c3 c4; count=0; do i=1 to dim(_v); count+(_v{1}=_v{i}); end; flag=ifc(count=dim(_v),'Same','Diff'); run; This is what i tried so far.

indox · ‎03-02-2018

Hello, I would like to compare multiple character variable values let say c1,c2,c3 and c4 the result should be 1 if all the values are not equal. The result should'nt be 1 if one of the variable is empty. Thanks for the help!

indox · ‎08-08-2017

Hello, I have four variables A, B, C and D. For each row these variables have integer values. I would like to know how to get the value of the highest variable between the 4. FOr example: A B C D 12 11 18 7 The result should be 18. I want to do this with proc sql. Thanks for help.

indox · ‎04-12-2017

Hello, For those who are in the same situation, here is the solution: filename xlappli dde "excel|system"; data _null_; file xlappli; PUT "[SELECT(""R1C1:R1C1"")]" ; PUT "[FORMAT.NUMBER(""@"")]" ; run; This will format the cell A1 in text format. Indox.

indox · ‎04-10-2017

Hello, How to text format a cell using dde? Thank you.

indox · ‎03-30-2017

Yes, this is what i want. Thanks.

Online Status	Offline
Date Last Visited	‎10-05-2021 01:36 PM

Re: nested %sysfunc

nested %sysfunc

Get all values separated by comma in one row by id

Re: Data combination by id

Re: Data combination by id

Re: Data combination by id

Data combination by id

Re: Compare multiple character variables

Re: Compare multiple character variables

Re: Compare multiple character variables

Re: Macro variable for opening Excel file with DDE

Re: nested %sysfunc

nested %sysfunc

Get all values separated by comma in one row by id

Re: Data combination by id

Re: Data combination by id

Re: Data combination by id

Data combination by id

Re: Compare multiple character variables

Re: Compare multiple character variables

Re: Compare multiple character variables

Compare multiple character variables

Highest value between 4 variables

Re: text formating Excel cell with dde

text formating Excel cell with dde

Re: Selecting rows from a dataset to another one with condition