problem while exporting in excel

[Aman4SAS]

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

[LinusH]

Why do you have 7' variables? Sounds like a bad design.

[RW9]

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.

[Aman4SAS]

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.

Please suggest

[RW9]

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.

[ravi_paradkar]

Try using sas addin in micorsoft excel and pull the data from sas using its objects.

[terryfearn]

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.