02-22-2012 02:35 PM
Anyone know why and how to fix when I'm exporting from SAS a large file into a .csv (or .txt) and try to pivot it in Excel it loses the ability to Sum up the data. It is still numeric data.
02-22-2012 02:59 PM
If I understand you correctly, this is what I have done.
input val stat $ add $;
2002.04 SINGLE Province1
1852.04 MARRIED Province2
PROC EXPORT DATA = test
OUTFILE= "C:\Documents and Settings\TEST.XLS"
Then opened the excel to creat a pivot table.
|Sum of val|
which is working fine
02-22-2012 03:03 PM
Yes, with 1 million records.. when I export into .csv.. then pivot works but not the SUM. In my sample I left a ' ' where the actual number eg 345345 would be and another ' ' where 245345 would be, but in my case I have alot of spaces.. Which I think are the culprit.