Help using Base SAS procedures

problem while exporting in excel

Reply
Super Contributor
Posts: 266

problem while exporting in excel

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

Super User
Posts: 5,424

Re: problem while exporting in excel

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

Data never sleeps
Super User
Super User
Posts: 7,942

Re: problem while exporting in excel

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.

Super Contributor
Posts: 266

Re: problem while exporting in excel

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

Super User
Super User
Posts: 7,942

Re: problem while exporting in excel

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.

New Contributor
Posts: 2

Re: problem while exporting in excel

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

New Contributor
Posts: 4

Re: problem while exporting in excel

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.

Ask a Question
Discussion stats
  • 6 replies
  • 479 views
  • 0 likes
  • 5 in conversation