Thank you for this information! I tried to install this procedure with institute IT service, but still we can't launch it successfully. I am going to send email to the author. ... View more

Thank you so much! This is very helpful! ... View more

Thank you so much, Steve! I was asked to show the achieved power by professor lol, although 335 is all I have. ... View more

Hi Steve, thank you for your reply! I have PROC POWER code. However,  I guess my question is more related to logic for calculating instead of calculation tools. For example, if the independent variables and dependent variables are continuous. Would it be appropriate if I calculate the achieved power in this way: categorizing independent variables into tertiles --> estimated effect size is 0.45 between 3rd tertile and 1st tertile for dependent variable --> get power around 90% based on sample size = 335? ... View more

Hi, thank you for your codes! However, variables were just renamed to "_12m" instead of selected based on the session. I was wondering what would be the issue. here is the code:   data one; input id age session score1 score2 score3; datalines; 1 10 1 85 90 89 1 10 2 95 100 99 2 11 1 99 98 91 2 11 2 99 98 91 3 12 1 100 100 100 3 12 2 60 70 80 4 11 1 78 89 100 4 11 2 88 99 120 ; run; %if &session = 1 %then %do; %let suff = _bl; %end; %else %if &session=2 %do; %let suff = _12m; %end; proc sql noprint; select catx("=",name,cats(name,"&suff.")) into :renames separated by " " from dictionary.columns where libname = "WORK" and memname = "ONE"; quit; proc datasets lib=work; modify one; rename &renames.; quit; Here is the log:   763 %if &session = 1 WARNING: Apparent symbolic reference SESSION not resolved. 764 %then %do; WARNING: Apparent symbolic reference SESSION not resolved. ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: &session = 1 ERROR: Skipping to next %END statement. 765 %let suff = _bl; 766 %end; 767 %else %if &session=2 %do; ERROR: Nesting of %IF statements in open code is not supported. %IF ignored. ERROR: Skipping to next %END statement. 768 %let suff = _12m; 769 %end; 770 ... View more

Hi, what I meant is not to rename everything into the same name, but to add a suffix to all variables as "_bl" or "_12m" based on session value. ... View more

Hi,  thanks for reminding me! It's a typo, I have edited the question. I meant categorical. ... View more

Hi Tom, Thank you for your reply. I use "%let...$path..." to import .csv files. The different values were directly from questionnaire records. Some people answered the only year, some people answered month and year. The question requires for month and year by the way, and it showed as MM/YYYY on the questionnaire, "JUN-01" in excel, and "JUN2001" in the SAS file; if there is a missing value, it shows as a dot; if the answer only contains the year, it shows as "2001". Below is my code for import. **import a csv file; %let path=C:\Project; options validvarname= v7; proc import datafile="&path\Project\WS.csv" out=N_bl dbms=csv replace; guessingrows=max; run;     ... View more

2 data WS.combo; 3 set WS.n_bl WS.n_6 WS.n_12; ERROR: Variable N1B has been defined as both character and numeric. ERROR: Variable N1B has been defined as both character and numeric. 4 by study_ID; 5 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WS.combo may be incomplete. When this step was stopped there were 0 observations and 112 variables. WARNING: Data set WS.combo was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.10 seconds cpu time 0.03 seconds Hi PaigeMiller, Thank you for your reply. Please see the log record above, this error happened when I tried to combine 3 datasets with the same participants' ID.  The original excel dataset includes both "2001" and "Jun-2001" since these were records directly from participants' answers in the questionnaire. The question only requires to answer month and year. I prefer to keep all answers as character variables. ... View more