Hello, I would like to know how the type error given by the output of Proc GLM is computed. I initially thought  it was SQRT((p(1-p)/n)) but it's obviously not.    Thank you for your help  ... View more

Hello,   I have a list of variable. When running  %scan((&vlist.),3,","); I obtain the character string "Los Angeles" but not inside "". Now I want to delete the observations when my character variable VAR takes the value "Los Angeles".   Basically, i'm looking to run this code, but precising that the result of the %scan() function is a character string :   data Want; set Have; If VARIABLE = %scan((&vlist.),3,",") then delete; run;   For information, when running :   data Want; set Have; If VARIABLE = "Los Angeles" then delete; run;   I get the result that I want.     Thank you for your help   ... View more

I'm re-uploading this topic because the previous one was considered as solved i don't know why...   I have this dataset :   Data Table; Input ID Y VAR $; datalines; 1 -1762.05 A 2 -776.07 A 3 -670 A 4 -535 A 6 -531 A 7 -528 B 8 -294 B 9 -281 B 10 -227 B ; run;   I'm now creating variables to get the difference of values between previous and next values, for each observation :   %MACRO COMPARE(table= , var= ); Data &table.; retain id; set &table.; id=_N_; run; data &table._COMPARE; set &table.; by ID; set &table. ( firstobs = 2 keep = &var. rename = (&var. = Next_Measure) ) &table. ( obs = 1 drop = _all_ ); Label Next_Measure=Next_Measure; Prev_Measure = lag(&var.) ; Diff_prev= (&var.-lag(&var.))/lag(&var.) ; Diff_Next= (Next_Measure-&var.)/&var. ; run; %MEND;   %COMPARE(table=Table, var=Y);   data TABLE_COMPARE ; Set TABLE_COMPARE; If abs(Diff_prev) < 0.01 or abs(Diff_Next) < 0.01 then Group= 1; run;   What I'm looking to get is :   Data TABLE_COMPARE_WANT; Set TABLE_COMPARE; Input Group_WANT; datalines; 1 . . 2 2 1 . . 2 ; run;   So i'm looking to have for each variable, several groups that must contain very close observations (a difference of 0.01 with the previous OR the next observation).   So in my example i would have two group 1 and group 2 for VAR A and Group1 and group 2 for VAR B.    Thank You for your answer  ... View more

Hello ! As you can see on the picture below, we i have two variables that display for each observation the variation of a continous variable (not displayed here) with the previous one and the next one. I'd like to create several groups that contain observations with close differences between each other.     What I did is : If abs(Diff_prev) < 0.01 or abs(Diff_Next) < 0.01 then Groupe=cats(Variable,1).  But now i'd like to change the value of the "1" and increment it by 1 each time a new group i created. Also I would like that at each new variable, the counter resets to 1.    Thank you in advance for your help  ... View more

Hello, Here is a data set that I created :    data Test; input CONT ; datalines; 3 8 5 3 1 6 9 0 2 4 6 5 ; run;   I wanted to test the quantile option of the proc means on this data set.  I was expecting Q1= 3 and Q3=6 but i obtained Q1=2.5 and Q3=6.   The sorted series is 0 1 2 3 3 4 5 5 6 6 8 9. I undestand that the proc means returned 2.5 because it's (2+3/2) but i don't understand why it is so.  For me, i have 4 groups of equal size : - 1st group : 0 1 2 - 2nd group : 3 3 4 (where "3" is the minimum, so  the number i was expecting) - 3rd : 5 5 6 (where 6 is the maximum, hence the "6" i was expecting, although i think it's (6+6)/2 - 4th : 6 8 9    So, why do i get 2.5, and most importantly, how can i get the 3, which represents the minimum of the interval conaining 50% of the data in the middle of my data set.   Well, I hope i was clear 😕    Thank you 🙂 ... View more

Hello,  I 'll try to be as clear as possible, because even in my head it's not very clear. So, I performed a Proc GLM on a few categorical variables. What I'm looking to know is : For the modality X1 (so when this modality is observed), what is the the sum of squares of the error.    In other words, i'd like to have ∑ ( y – estimated(y)  ), for each time a modality is observed.  On the output of the proc glm, i have "Type Error" for each modality but i don't know what it corresponds... Any advice ?   Thank you ! ... View more

Hello ! I have a table with multiple categorical variables in input and a continuous variable in output. I ran a Proc glm on this table, which gives me coefficients for all the modalities. Now i'm trying to "apply" all those coefficients to my real observations and add a column "regression output" to my table that gives me the "predicted" output for every observation. So I can compare the real output and the predicted one.    Thank you for your help 🙂 ... View more