06-11-2015 06:13 AM
i have a data set with 7000+ variable , when i m exporting this dataset to excel , i m getting missing variable name in excel after 2000 variable.
please suggest me how can i resolve this issue.
Thanks in advance
06-11-2015 07:00 AM
There is a limit to the number of columns that Excel can handle, you are probably exceeding that. Totally agree with Linus Hjorth, 7000 columns is unworkable in any situation. What are you trying to do, if its a report then you need better design, summarise the data for instance. If you are doing data transfer then CSV, or just dataset.
06-11-2015 08:41 AM
I have 7000+ orgnaization with 24 month data i need to create a mmm model. To see the pattern and effects i need to create it. I just looking a solution if is it possible to export or m i doing any mistake to export.
06-11-2015 08:57 AM
Sorry, I am not understanding you. Is this a model you are doing in SAS? If so why the need to export anything to Excel?
If you are doing something in Excel, then you need to be aware of the limitations of Excel.
06-12-2015 08:11 AM
I think that you should make the organization a variable and create one dataset with all the organizations. Then you can make the organization variable part of the analysis.