Hello,
I am writing Proc report to make a Stored Process, but when the records exceeds over 10,000 then my excel worksheet is not opening though excel limit is 10lacs.
Does anyone has a solution?
Regards,
Harsh Patel.
Hello,
What i am doing is that firstly i am fetching from teradata post to this i am doing some calculations in proc sql and then i am writing ods excel to generate report in .xlsx format.
I feel there is an issue with the way we are using PROC REPORT in our Stored Process. What is happening is that we are getting a lot of columns from teradata. Post that we are using PROC REPORT to create final report which is outputted to an excel sheet(.xls file)
In our PROC REPORT, not only are we applying a format to multiple columns, we are additionally, using compute to calculate values for multiple columns(percentage of total,division etc), This is creating a massive object which takes a lot of time to process(we tried running same code in SAS EG and it is taking a lot of time there as well).
Are there some limitation in PROC REPORT vis-a-vis the amount of data we can process in one go?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.