Hi, I have a dataset that looks like this:    Visit_date_1 Visit_date_2 Visit_date_3 Visit_date_4 .... Visit_date_n I would like to calculate the number of months between Visit_date_2 and Visit_date_1, and Visit_date_3 and Visit_date_2, etc...  So essentially I am calculating Visit_date_n - Visit_date_(n-1). I have written the following SAS code but it doesn't seem to work.  It says that "WARNING: Apparent symbolic reference I not resolved." and "ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: &i.-1" Note, I am trying a new UNTIL loop which doesn't seem to like character values.   Any advice?   TIA     data testing; set testdate ; do i = 2 to 100 until Visit_date_&i. = "" ; %let j=%eval(&i.-1); diff_month_i=intck('MONTH', Visit_date&i., Visit_date&j.); end; run;     ... View more

Hi, SAS PROC CORR does not allow WEIGHT when calculating SPEARMAN correlations.  I get an error in my log stating non-parametric methods cannot be used when weighting. Two questions:   1. Why does SAS not allow it?  I read that STATA doesn't allow it either, but no explanation why.  R allows it (package 'WCorr').  Is there a statistical rationale?  I have a hard time thinking that it's computational. 2. If it's using weights for spearman is statistically sound, is there a SAS workaround? I found this old post but the link is no longer valid https://communities.sas.com/t5/Statistical-Procedures/Spearman-correlation-with-complex-survey-data/td-p/120589   Thanks in advance.   Sharon ... View more

Hi, I have data set A that has a variable formatted in CHAR32. I have dataset B that has the same variable formatted in BEST19. I'm trying to merge both datasets into one, but SAS will not let me because the formats are different. I've tried converting dataset B variable from numeric to character using:   try1: format var2 32..; var2=var1;   doesn't work.  It truncates the variable, despite the variable only having 19 digits.   try2: var2=put(var1, 32.);   doesn't work.  It truncates the variable, despite the variable only having 19 digits.   Then I tried to to convert dataset A from character to numeric:   try3: var2=var1; format var1 best19.;   doesn't work because SAS doesn't recognize the format best19. NOTE:484-185.     try4: var=input(var, 19.);   Again, it truncates the variable.   Can anyone help me?   Thanks.       ... View more

Hi, I'm using PROC FREQ to calculate an odds ratio. I'm able to get a 95% CI but how can I get the p-value? I understand that if i look at the CI and if it includes 1, it's not significant, but I'd like to include the actual p-value. Thanks.   proc freq data = test ; tables var1*var2 / relrisk alpha=0.05; run; ... View more

  Hi, I'm having a tough time selecting my data year. I want to include only those years that are greater than 2014.   My original_date variable is of this format: 2014-06-26 14:31:24.0000000   This is my code:  data new; set old; original_date_sas= input(original_date,anydtdte10.); format original_date_sas mmddyy10.; fiscal_year = intnx('YEAR.04',original_date_sas,0); /*fiscal year starts april 1 (month 4) */ format fiscal_year year.; if fiscal_year GE 2014; /*anything starting from 2014 */ run;   The problem is "if fiscal_year GE 2014; " doesn't work!  It still keeps records that are earlyer than 2014. I have tried COMPRESS and  LEFT when creating original_date_sas,  and I put "2014"d., when specify the year but doesn't work. Any suggestions? ... View more