You can try this (If Myfile's file extension is sas7bdat): %Macro check_file_exist; %if %sysfunc(exist(work.Myfile))=0 %then %do; data Myfile; set _NULL_; run; %end; %Mend;   If Myfile is an external file (such as txt), try this: filename myexfile "C:\Users\Administrator\Desktop\test.txt"; %macro check_file_exist; %if %sysfunc(fileexist(myexfile))=0 %then %do; data _null_; file myexfile; run; %end; %Mend check_file_exist; %check_file_exist; Hope this helps.   Thanks, Fred ... View more

Dear ballardw, Thank you! ... View more

You can correct it as follows: proc sql; 　select orderid, productid,orderdate,linetotal 　from Salesorders 　where orderid in (select orderid from JulySales); quit; But you should first ensure that the attributes(length, format etc) of orderID in dataset-JulySales and dataset-Salessorders are same.   Hope this helps.   Thanks, Fred ... View more

Agree with @PaigeMiller. I supply some additional information about your code. According to your think, you don't need to add a new computed column . proc report data=ds1 split='~'; column idx label (var1, stat) stat=n; define idx / noprint group; define label / '' group left; define var1 / '' across nozero order=internal format=anagrpnfmt.; define stat / '' center; define n / '' sum f=comma18.0 "ALL Combined"; run; P.S. The error you got is that you can't use "sum()", you should key "n=stat.sum".   Hope this helps.   Thanks, Fred ... View more