Hi, I was doing sum for total monthly amount using group by and when I tried to validate the output of the program using simple sum in proc sql there was a difference in the sum for each month usd amount from $4 to $12, I was thinking may be due to some format ,then I applied the same formats but again difference was the same. then I tried using group by and sum it again it was matching , then for more testing I used proc means to sum the same column and I was surprised to see that now it was showing only one dollar difference.so my question is that why this difference is coming up when we use proc sql to sum a column  with group by and without group by.Is there any way to fix this issue.my data is too big approx 110gb for each month. Thanks & Regards, Saurabh Diwaker  ... View more

I have to extract data from excel sheets iif I use this procedure it works fine but I have to create a mackro for this so that I can extract data from diffrent sheets and need not copy paiste all code again and again but when I execute macro it produces the same output data set with new name which I have given. plz help me with this urgently. Thanks in advance. PROC IMPORT OUT=S11515 DATAFILE="G:\sa sas BI\sd\Complete Spreadsheet 10 Asthma patients.xls" DBMS=EXCEL2000 REPLACE; SHEET="'Subject Demo$'"; GETNAMES=YES; RANGE='a2:f32'; MIXED=YES; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; options mprint mlogic symbolgen serror merror; %let ss="G:\sa sas BI\sd\Complete Spreadsheet 10 Asthma patients.xls"; %macro datain(sht,rng); PROC IMPORT OUT=h11 DATAFILE=&ss DBMS=EXCEL2000 REPLACE; SHEET="'&sht$'"; GETNAMES=YES; RANGE='&rng'; MIXED=YES; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; %mend; %datain(History,A2:O22); ... View more

my raw data is like this id ab bb cb db eb a1 b1 c1 d1 e1 a2 b2 c2 d2 e2 a3 b3 c3 d3 e3 1 11 23 43 23 43 12 34 54 23 43 11 23 45 67 65 11 23 45 67 32 2 43 54 76 87 45 67 87 54 67 89 76 54 34 67 89 09 76 45 34 56 I have to make it like this base 1wk 2wk 3wk a 11 12 11 11 b 23 34 23 23 c 43 54 45 45 d 23 23 67 67 e 43 43 65 32 Please Help me with this and guid me how to transpose that using proc transpose or array or anything else pls give me coding for that also Thanks in advance ... View more

my raw data is like this id ab bb cb db eb a1 b1 c1 d1 e1 a2 b2 c2 d2 e2 a3 b3 c3 d3 e3 1 11 23 43 23 43 12 34 54 23 43 11 23 45 67 65 11 23 45 67 32 2 43 54 76 87 45 67 87 54 67 89 76 54 34 67 89 09 76 45 34 56 I have to make it like this base 1wk 2wk 3wk a 11 12 11 11 b 23 34 23 23 c 43 54 45 45 d 23 23 67 67 e 43 43 65 32 Please Help me with this and guid me how to transpose that using proc transpose or array or anything else pls give me coding for that also Thanks in advance ... View more