Actually, it might not be permission related at all. It's more likely windows/windows server vs. the unix box.  I'm not sure if you have any directories that are accessible in both, but it would not suprise me if not based on my experience. ... View more

I think the second error is related to the first.   Can you change the path to one where you are sure you have access and see if it works? And if it does, then I think you need to talk to your IT/SAS Admin about the permission issue when you're in the Unix environment. ... View more

What do you mean by it doesn't work? Is there an error in the log? ... View more

The data are different, but maybe this helps?   proc sort data = sashelp.class out = class; by sex; run; proc tabulate data = class format = comma10.2 out = tblData; by sex; class age; var height; tables age all, height; run; filename out "....\do not want.txt"; DATA _NULL_; FILE OUT; SET tblData; PUT (_ALL_) (','); run; filename out "....\do want 1.txt"; DATA _NULL_; FILE OUT; SET tblData; PUT sex ',' age ',' height_sum; run; ods csv file = "...\do want 2.txt"; proc print data = tblData noobs; var sex age height_sum; run; ods csv close; ... View more

I think this will still leave the leading "," in the output, but maybe that's fine for the OP. ... View more

It's not clear to me what you want the output to look like, but have you looked at the data set created by proc tabulate to see which variables you are outputting with your _all_? I think what you're seeing is the _page_ and _table_ variables. Maybe use the put on the just the variables you want to output. Or maybe use ods csv with a proc print noobs and list only the variables you want to output? ... View more

You can use a user-defined format:   proc format; value myFmt 0 = 'N/A' OTHER=[8.]; <-- Or whatever format you want. run; Then just use this format for the variable you're displaying.   If it's missing and not zero, set missing to 'N/A' in the format. ... View more