Hello, I'm new to use do loop with let macro.   I want to create several new variables, with if conditions on pre-existing variables.   Without using macro, the code will be this. A, B, C .. is old variable, _A, _B, _C ... is new variable.   data want; set have; by id; if first.id then _A=A; if A=1 then _A=A; else do; retain _A.; end; run; data want; set have; by id; if first.id then _B=B; if B=1 then _B=B; else do; retain _B.; end; run; ... and so on.   With searching, I found it is better to use let function and do loop. However, I'm new to this. I created the code below (only A, B, C), However, it wasn't working.   %Let var = A B C ; %Let _var = _A _B _C ; data want; set have; do i = 1 to 3; by id; if first.id then scan(&_var.,i,' ')=scan(&var.,i,' '); if scan(&var.,i,' ')=1 then scan(&_var.,i,' ')=scan(&var.,i,' ') else do; retain scan(&_var.,i,' '); end; end; run; With log statement, there was problem in scan. It can't read 'A B C'. I hope somebody help me fixing this problem. ... View more

Hi. About 1 years ago, with help of this community, I could complete my project in time. After submit my project, I'm trying to understand the code that several programmers suggested. However, in 'Hash' function, it is hard to understand.   https://communities.sas.com/t5/SAS-Programming/cumulative-sum-of-largest-value-of-each-group/m-p/498250#M132362   In this post, I asked how to do sum of largest value of each group cumulatively. Ksharp, Grand advisor of this community, suggested the usage of 'hash' function. I'm reading some posts about 'hash' function and understand the meaning of this function a little. But, there are some difficulties left. Please help the questions i asked below.   The code Ksharp suggested is this.   data want; if _n_=1 then do; if 0 then set have; declare hash h(); declare hiter hi('h'); h.definekey('clinic'); h.definedata('clinic','count','countsquare'); h.definedone(); end; set have; by id; if first.id then h.clear(); if h.find()=0 then do;count=count+1;countsquare=count**2;h.replace();end; else do;count=1;countsquare=1;h.replace();end; _clinic=clinic;_countsquare=countsquare;sum=0; do while(hi.next()=0); if _clinic ne clinic then sum+countsquare; end; sum+_countsquare ; clinic=_clinic; drop _:; run;   1) what is the meaning of '_n_'?   if _n_=1 then do; if 0 then set have;   In raw data, there was no 'n' variable. In my knowledge, _n_ may mean starting operations of 'hash' iteration. Then, what is 'if 0'? In first row, _n_ means 1, in this conditions, _n_ must remain '1' but second row, it suddenly became 0.   2) what is the meaning of 'h.find()=0'?   if h.find()=0 then do;   This is the hardest code to understand. Maybe, the 'find' function means the 'definedata' in hash object, which are 'clinic', 'count' and 'countsquare'. But there was no code to set 'definedata' to zero.   3) what is 'else do'?   else do;count=1;countsquare=1;h.replace();end;   This means 'h.find() ne 0'. So the definedata in hash object is not 0 which means the total is above zero and this may be not the first row. right? Then, why the 'count' became 1?   4) what is 'do while(hi.next()=0);'?   The hi is hiter of hash object. In my knowledge, this mean it import the previous defined hash object, which is 'h'. The 'next' function means the next value in 'definekey' and this mean that do loop until the value in next key become positive. right?   5) what is 'if _clinic ne clinic'?   In previous code, '_clinic=clinic;' Ksharp set the '_clinic' variable same with 'clinic' variable. However, in this 'if' funciton, _clinic is not equal to clinic. With previous condition, '_clinic=clinic', there must be no case that _clinic is not equal to clinic. However, this if statement worked well. What is the mechanism? ... View more

Hi, i'm using Proc mi function for multiple imputation.   I've saved my imputed results with seeds(i.e. random generator).   However, in yesterday I found that proc mi produced the different results with same seeds. My results were all gone!   I'm in panic now, however, i'm facing the truth and trying to find out what was the problem.   My code was like below. proc mi data=mywork.data nimpute=5 round=1 minimum=0 maximum=100 seed=1 out=mywork.data_1 var VAS_2 VAS_4 VAS_6 VAS_8 VAS_10 VAS_12; run;   I didn't use seed number in other proc mi function.   I think that maybe the seed number was not enough long, or other reasons.   I really appreciate if you tell me the reason why my seeds were all changed. ... View more

Hello, I'm using ANCOVA for anlayzing RCT data. I'm using Proc glm now. In ANCOVA, it seems to be common to use continous covariates, not categorical covariates.   However, in my data, the covariates are categorical variables(e.g. race, gender).   Is it right to use categorical variables as covariates in ANCOVA with proc glm function?   In proc glm, we can only use categorical variables with 'class statement'.   As I add variables in my model gradually, the results of main variables(independent variables) are changing.   It seems that the results of indepedent variables are being adjusted gradually.   However, I'm not sure about the process and outcome.   * In addition   There were some people who had similar problems with me, but the answers to them was a bit ambiguous for me, and most of them answer with SPSS syntax, not SAS.   the syntax is like below... for simplicity, I assume that there is no interaction between variables. proc glm data=DATA plot=meanplot(cl); class trt race gender; model outcome = trt race gender age baseline/solution; lsmeans trt/tdiff pdiff cl adjust = bon; run;   As you see, trt is treatement, which is independent variables and race and gender are categorical covariates.   the results of lsmeans is changing as I add categorical covariates gradually, but is it right procedure? ... View more

Hello. I'm trying to convert multiple character variables to numeric variables.   My data are as follows....   ID pre_stress_visit1  pre_stress_visit2 pre_stress_visit3 post_stress_visit1 post_stress_visit2 post_stress_visit3 pre_pain_visit1 A 12 10 9 10 8 7 53 ... B 13 13 6 11 11 4 57 ... C 13 12 8 10 13 7 55 ...   the pre_stress_visitnumber and post_stress_visitnumber are recognized as character. So, i want to convert them into numeric variables   Though I can convert each variables with input statement, like 'input(pre_stress_visit1, best32.)', it takes long time to do it. Is there a better way to convert them?   I would really appreciate all your help. thanks. ... View more

Hello. I have a problem with selecting multiple variable in proc sql.   My data's variables are as follows....   ID pre_stress_visit1  pre_stress_visit2 pre_stress_visit3 post_stress_visit1 post_stress_visit2 post_stress_visit3 pre_pain_visit1 A 12 10 9 10 8 7 53 ... B 13 13 6 11 11 4 57 ... C 13 12 8 10 13 7 55 ...   I want to select variables with same words, 'stress'. So, I want to select.(Maybe you can find that i want to calculate difference between pre_post stress in every visit)   "ID pre_stress_visit1 pre_stress_visit2 pre_stress_visit3 post_stress_visit1 post_stress_visit2 post_stress_visit3"   I tried to use 'array' function, but it didn't work in proc sql. Is there a better way?   I would really appreciate all your help. thanks. ... View more