PROC GLM DATA = fa_1; CLASS treatment ; MODEL CFB = treatment base/ SOLUTION; LSMEANS treatment / STDERR PDIFF=control("R") CL alpha=0.05 out=LSM; CONTRAST 'T VS R' treatment -1 1 ; /** T = TEST , R = Reference **/ ESTIMATE 'TEST - REF' treatment -1 1 ; ods output estimates=estimates1 LSMeanDiffCL = LSMeanDiffCL1 ; run;   data lsm1; set lsm; run;     Can any one help me out understanding the above statements regarding PROC GLM, and  One more query I have is that,when ever I submit the program then the program runs with out any error but there is no output file created(the program say it still running even after submitting the run statement). But when I write a program below with set statement only then i can find the data file and the program running message is seen no more  ... View more

filename PDfile DDE "Excel|N:\statistics\Pr 113-10\Safety Analysis\Data\External\[113-10_Updated_Master PD tracker_18 Jan 18.xlsx]Sheet1!R2C1:R139C15" notab; data PD; infile PDfile dlm='09'x dsd missover LRECL=150006; input Sr_No:$3. ScreeningNo:$20. Subject_No:$6. Treatment:$5. Visit:$100. DateDeviation:$100. TimeDev:$20. ProtocolSection:$20. Description:$800. TypeDev:$20. ProtocolDev:$50. Reason:$500. Impact:$300. Corrective:$600. Preventive:$600.; run;     Am trying to read this file the path in correct, no flaw in that but yet while running it say :-      ERROR: Physical file does not exist, Excel|[N:\statistics\Pr 113-10\Safety Analysis\Data\External\113-10_Updated_Master PD tracker_18 Jan 18.xlsx]Sheet1!R2C1:R139C15.       What am i doing wrong  ... View more

I have three columns were the data should be in 2 or three figures but the should not start with a 0, but i have a few values where the figure is of 2 digits but with a zero for example : DIBP 82 86 85 084 85 86 083 How do i remove the zero's ... View more