hello people,   i've a dataset like bellow. x       y 1      0 1      23 1      56 1      0 1      0 1      0   i want to replace the zero with '.' but there is one thing that i'm worried with. last three observations in y are zeros. replace last two zeros with '.' , last but two and first values should stay zeros. ie output will look like x       y 1      0 1      23 1      56 1      0 1      . 1      .   Thanks in advance. ... View more

Hi,   while running scores data in proc glm, i got zero value for the sum of squares (variable - site, levels L and R ). is it obvious? i've tried searching internet and found nothing.   i think here there is no problem with the code i've used.   proc glm data=one(where=(hour ne 0)); class subject hour Site; model score = subject site hour/ ss3; lsmeans hour /stderr pdiff; run;   any statistical explanations?   Thanks in advance.   ... View more

Hi,   i got an error message while using method=type3 in proc mixed, saying that 'Error: Type 3 estimation is not available with this model.'. i don't know what is the reason behind this error. well here i'm using Area under effective curve data and model was   proc mixed data=study.detectors7 method=type3; classes sub trt; model data= trt/ ddfm=sat; random trt/type=FA0(2) sub=sub g; repeated/group=trt sub=sub; estimate 'T vs R' trt -1 1/cl alpha=0.1; run;   version: SAS Enterprise guide 6.1 ... View more

Hi all,   i ran proc mixed today, and got this     Type 3 Tests of Fixed Effects Effect Num DF Den DF F Value Pr > F TRT 1 51.1 8.64 0.0049     Estimates Label Estimate Standard Error DF t Value Pr > |t| Alpha Lower Upper T Vs R -3.3302 1.1331 51.1 -2.94 0.0049 0.1 -5.2285 -1.4320      is it obvious that DF comes in decimals? can you guys explain?   code:  PROC MIXED Data=pk_data;            CLASSES Sub Trt;            MODEL data= Trt/ DDFM=SAT;            RANDOM Trt/TYPE=FA0(2) SUB=Sub G;            REPEATED/Group=Trt Sub=Sub;            ESTIMATE 'T Vs R' trt -1 1/CL ALPHA=0.1;            ODS OUTPUT G=Gmatrix;            ODS OUTPUT ESTIMATES=EST;            Run;   info: Total Subjects:52, Treatments:2, DF_method: Satterthwaite. SAS version: SAS 9.4 Enterprise guide   Thanks, Satish.   ... View more

Dear all,   today i came up with a question.   well, there are two datasets x & y, dataset x had values derived from some procedures and dataset y had random values, all i need is arrange dataset x variables according to values availed in dataset y. i'll give you three tables to understand better.   Dataset X Subject hour S1 S2 S3 1 -1 6 8 5 1 0 10 9 7 1 2 9 9 6 2 -1 5 7 10 2 0 9 6 8 2 2 8 9 8     Dataset Y Subject R1 R2 R3 1 3 1 2 2 1 3 2   now my expected output is   Output Dataset Subject hour _1 _2 _3 1 -1 5 6 8 1 0 7 10 9 1 2 6 9 9 2 -1 5 10 7 2 0 9 8 6 2 2 8 8 9   dataset x variables are arranged using the values of dataset y and remember this arrangment varies from subject to subject. in the output dataset for subject 1, _1 variable values are taken from S3, _2 variable values are taken from S1, _3 variable values are taken from S2, belongs to dataset X, arranged with reference to values of dataset Y.   plz help me out.   thanks in advance. Satish. ... View more