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
Why do you have 7' variables? Sounds like a bad design.
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.
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
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.
Try using sas addin in micorsoft excel and pull the data from sas using its objects.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.