Hello,     ... View more

Hello, I'd like to create a "top" variable that is equal to 1 when A=/= B and 0 otherwise. As you can see in the attached dataset, for line 10 and 11, A=B (="XXX") but because the length is different , the "top" ( TPRGLTRM) doesn't work. Here is how i constructed the TP :  TPRGLTRM = (COQREGLETRM ne REGLETRM)   Any idea to sort it out for when A and B are both equal to "XXX" ? ... View more

Hi, i would like to merge two tables by two variables A1 and A2, but keep the observations that only have A1 in common in the defenitive table. It would look like this :    Table 1      A1 A2 Y1 A 1 X A 2 X A 3 X A 4 X B 1 X C 1 X C 2 X D 1 X D 2 X   Table 2     A1 A2 Y2 A 1 Y A 5 Y B 2 Y C 1 Y C 2 Y D 1 Y D 3 Y E 3 Y E 4 Y F 2 Y F 1 Y G 2 Y G 3 Y     The definitive table would looke like it : Have        A1 A2 Y1 Y2 A 1 X Y A 2 X . A 3 X . A 4 X . A 5 . Y B 1 X     B 2 . Y C 1 X Y C 2 X Y D 1 X   D 2 X   D 3 . Y   Thank you for your help 😄   ... View more

Hello,  I would like to create a box plot for 4 continous variables, but that are not linked with any categorical variable.  Actually, i'd like to plot the output of the proc univariate with the means and quantiles. Here is an excerpt of what the Proc univariate gives me for one of my 4 variables :  Quantile Estimate 100% Max 6.24719 99% 5.68653 95% 5.43895 90% 5.24901 75% Q3 4.82637 50% Median 4.32900 25% Q1 4.02401 10% 3.62096 5% 3.45388 1% 3.23710 0% Min 2.77457   Now, I would like to plot thoses pieces of information in the style of a boxplot, for my 4 variables.    Also, I work on SAS 9.1...    Any idea ?    Thank you very much by advance for your help 🙂     ... View more

Hi, I have to add a numeric variable to an existing dataset. I then used this code :   data WANT; set HAVE; put INDIC_2009 8.; format INDIC_2009 comma8.2; datalines; 38,64 . . . -18,36 0,36 0,36 -88,96 0,12 -88,96 -53,66 0,2 -21,344 2 3 -88,96 -88,96 -18,36 -88,96 0,12 -53,66 0,12 0,12 0,36 0,36 0,36 -107,32 0,6 -106,72 ; run;   But it does not work. I only get "."       Any idea ?   Thank you ! ... View more

Hi, I have a numeric variable taking the values 0,1 and "." . When using the function compress or cats for this variable, the "." is tranformed into a 0. Is there any way to avoid this aside from transforming the numeric variable into a character variable taking the value "0" , "1" and ".".   Thank you 😉 ... View more