Two problems
Gang,
I'm using PASW 18.0.1 on Mac. I just now ran a bit of
syntax and had two problems arise. I last ran this syntax in
October, and it worked just fine.
First, running the following:
GRAPH
/BAR(GROUPED)=COUNT BY week BY staff.
produced
this: Could Not Start Java
Virtual Machine. Chart will not be drawn.
Second,
running the following (edited for simplicity):
SAVE TRANSLATE
OUTFILE='/Users/Me/Filepath/Filename.xlsx'
/TYPE=XLS
/VERSION=12
/MAP
/REPLACE
/FIELDNAMES
/CELLS=VALUES
/KEEP=id var1 var2 .
did indeed
save a file but my current version of Excel (latest Mac 2011 version)
says the file format or extension is not valid. I then tried to
trick Excel by changing the file extension to .xls. It opened
the file, but there was no data in it. I then re-ran the above
syntax with /VERSION=8 to generate the older .xls format, and it
behaved just the same--it opened but was empty.
I was and am
still able to open files generated by this syntax with the Excel/Mac
2008 version just fine last October.
Is it likely that Mac OS updates are responsible for breaking the
"Java Virtual Machine"? Further, I'm stumped about the
Excel problem because I can open files generated by this very same
syntax last year. Though I suspect I opened them in the older
version of Excel, made some changes, and then saved them, which
probably cleaned up any errant stuff left behind by PASW.
Any suggestions? Will a newer version of PASW solve these
problems?
Thanks,
Dennis