topic problem while exporting in excel in SAS Procedures

problem while exporting in excel

Aman4SAS — Thu, 11 Jun 2015 10:13:52 GMT

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

Re: problem while exporting in excel

LinusH — Thu, 11 Jun 2015 10:22:37 GMT

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

Re: problem while exporting in excel

RW9 — Thu, 11 Jun 2015 11:00:54 GMT

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.

Re: problem while exporting in excel

Aman4SAS — Thu, 11 Jun 2015 12:41:10 GMT

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

Re: problem while exporting in excel

RW9 — Thu, 11 Jun 2015 12:57:52 GMT

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.

Re: problem while exporting in excel

ravi_paradkar — Thu, 11 Jun 2015 15:14:26 GMT

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

Re: problem while exporting in excel

terryfearn — Fri, 12 Jun 2015 12:11:10 GMT

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.