Yes, I should specify units on the cellwidth. (The doc suggests the default is 1/150 inch). The '00'x labels are to remove the labels for these variables. This does seem odd, but I haven't found a better way to do it.
... View more
Removing "/row = float" and replacing with "/nocellmerge" fixed the problem. (I didn't really need the row titles to float, but did want the cells in the xlsx output to be not merged). Incidentally, row=float was not a problem for my smaller tables - it just seemed to produce problems for large tables.
... View more
Thanks for the LibreOffice tip. It does open in LO, but the table is nonetheless messed up. See below.The years should be in the second column (which they are for the other family types not shown). However, it does look like I was on the wrong track thinking about the RTF output. My program also writes xlsx and html, and it is messed up there too. So is this a proc tabulate problem? An excerpt of my code is: options ls=max ps=max;
options papersize=A4 orientation=portrait;
ods _all_ close;
ods graphics on /reset=index height=11.5in ;
ods rtf style=bbfp file="&Output\Trends.rtf" image_dpi=300 bodytitle;
ods html style=bbfp path="&SASImages" gpath="&SASImages" image_dpi=300;
ods Excel file="&Output\Trends.xlsx" style=BBfp options(sheet_interval='NONE' embedded_titles='yes') ;
ods escapechar="~"; /* used to insert special formatting commands, like {NEWLINE} */
[cut]
proc tabulate data=dat1 style=[cellwidth=75];
weight w1;
class surveyyear hhstruct21 H_IS;
label surveyyear=;
label hhstruct21='00'x;
label H_IS='00'x;
var Y one;
table hhstruct21*surveyyear='' ,
(H_IS all="All people")*
(p10 p20 median mean)*f=comma6.0*
y=""
/ row=float
;
run;
... View more
I'm finding that some of my RTF files are being reported by Word as having corrupt tables. There is no error message in the log file of the SAS program that created them. I'm not using any special formatting commands other than {NEWLINE} statements in tables. The tables are quite large however. Any solution to this?
... View more
Any suggestions on how to create this type of plot? (Not too fussed about the text colours, but being able to attach legends at the right of crowded graphs would be great).
... View more
From memory, I've experienced it on machines with both Win 7 and Win 10. Yes, it is associated with using the Help feature. I haven't encountered it recently - so I think upgrading SAS to 9.4 TS1M5 fixed it.
... View more
I'm trying to read the data back into SAS using input (_all_)( : ); (After first defining the variable list and informats using attrib statements). So, to use your work around I have to add missing M; prior to the input statement. This works, though the missings are now read in as .M rather than generic missing (.). I then need to follow up with array loop to recode them to my preferred generic missing. Thanks PS I've sent this on to tech support.
... View more
Why doesn't the following code work? When I run it, I get 20 commas in the log (followed by the value of i, 101 on the next line), but I am expecting five rows of 20 commas. If I change it to v(i)=1, it works as expected, with multiple rows of 1 followed by a comma. [This is abstracted from a large program where missing values seem to messing up my output] data _null_;
array v(*) v1-v100;
do i=1 to dim(v);
v(i)=.;
end;
file log dsd ls=20 dlm="," ;
put (_all_) (:);
run;
... View more
I'm having the same problem - but worse! That is, sometimes when I save a file, then quit SAS I find my .sas file has disappeared. All I'm left with is a SASxxxx.tmp file. Sometimes I can't open this until I logoff and back on because another process has locked it. When I do manage to open it, it does contain my missing SAS code. Maybe it is relevant that on my system these files are on a network share and I have 'always available offline' ticked (though I am online). I've contacted SAS tech support - but they have just suggested that this is file server problem. Should I disable 'safe save'?
... View more
Sorry, that's what I meant: ODS Excel (not ODS tagsets=excel). This has fixed the problem (and does a better job than tagsets=excelxp). Thanks all.
... View more
I think I've worked out where they're coming from. I also have ods markup tagset=ExcelXP Even though I couldn't see in graphs in the Excel file created, it was (trying) to link to them. I'll see if tagset=Excel works better. Thanks all for your suggestions.
... View more
