Hi all,   I am using PROC GLM Contrast statement to see if my data displays any trend like linear or quadratic. Somehow when I use two CONTRAST statements at the same time, the CONTRAST output does not come out.   Below is my code: PROC GLM DATA=mydata; CLASS RESP_TIME; MODEL score= RESP_TIME ; CONTRAST 'Linear' RESP_TIME -2 -1 0 1 2; CONTRAST 'Quadratic' RESP_TIME 2 -1 -2 -1 2; run;   Another question is: is it possible to do the trend plot along with CONTRAST statement?   Thanks a lot! Lizi ... View more

Hi all,   Thank you for your attention first of all!   I am running PROC ANOVA with MEANS statement to get group means as below: proc anova data=indat; class classvar; model cost = classvar; means classvar /tukey; run;   The Tukey test generates the table of difference between means along with 95% CI. However, I need to have specific p-values per difference between means.   Is there a way to list out the specific p-values?   Thanks a lot! Lizi ... View more

Hi everyone,   I need to calculate the percentage of multiple rows out of one row (this row is the total of other rows). Can anyone help with some simple code?   The data I have is Account cnt_201701 cnt_201702 cnt_201703 cnt_201704 cnt_201705 cnt_201706 A 296 370 375 395 365 319 B 4549 7157 8759 9705 9355 9697 C 1687 2356 2803 3060 3281 3497 Total 6532 9883 11937 13160 13001 13513   The target data is Account cnt_201701 cnt_201702 cnt_201703 cnt_201704 cnt_201705 cnt_201706 A 4.5% 3.7% 3.1% 3.0% 2.8% 2.4% B 69.6% 72.4% 73.4% 73.7% 72.0% 71.8% C 25.8% 23.8% 23.5% 23.3% 25.2% 25.9% Total 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%   ... View more

Hi,   I have two date fields in the original excel file, both are in the format of MM/DD/YYYY. However, when the data was imported, one was imported with the datetime format and the other was imported as a character field with the number values like 18482 for 8/7/1950.   Does anyone can help explain why the date fields were imported differently? How can I get the right format for them, especially the one imported as character?   Thanks a lot! Lizi ... View more

Hi all,   I came across this question when trying to pull multiple datasets from the same data source. The question is how I can delimit the macro variables when the parameters are defined with multiple numeric values. Below is the example I have. When I tried to plug in the parameters with multiple values like idlist1 and idlist3, the macro cannot take it as the parameters have the same delimiter comma as that between the macro variables "datasetid" and "idlist".   %let idlist1=1111, 3333; %let idlist2=2222; %let idlist3=5555,6666,7777;   %macro pull_iddat(datsetid,idlist);   proc sql; create table want_&datsetid. as   select * from libdat.datset_a a inner join libdat.datset_b b on a.joinid = b.joinid and b.idvar in (&idlist.)   ;quit; %mend; %pull_iddat(11,&idlist1.); %pull_iddat(22,&idlist2.); %pull_iddat(33,&idlist3.);   Can anyone help?   Thanks a lot! Lizi ... View more

Hi All,   This came to my attention while checking my data. I tried to see if there is any significant difference from time 1 to time 2 for a group of individuals after an intervention occurred between time1 and time2. So I checked the means of the variables of interest and also did paired t-test.   I thought that the difference in groups means (PROC MEANS first per time period, and then take difference between the two means) would be the same as the means of difference given by the paired t-tests, but it was not the case for all the variables. My understanding is that the means of difference given by the paired t-tests were calculated as the means of difference between two time periods.   I tried to do manual calculation and got the same results (some with the same values in difference in group means and means of difference, and some with different values in them). I was wondering if it is related to some random missing data or other reasons.   Could anyone see why?   Thanks a lot! Lizi     ... View more