topic Re: ERROR on sas Tabulate and transpose in SAS Programming

ERROR on sas Tabulate and transpose

yadiacho1 — Fri, 30 Dec 2022 08:21:03 GMT

I need help to fix this, is there any solution for this. Already contacted IT to do exception on antivirus. But error still appear.

thanks...

Re: ERROR on sas Tabulate and transpose

ballardw — Fri, 30 Dec 2022 08:29:53 GMT

If you restart your SAS session do you still get this?

Re: ERROR on sas Tabulate and transpose

Kurt_Bremser — Fri, 30 Dec 2022 08:36:49 GMT

Do you run SAS on a server, or locally on your PC? Please supply information about your SAS setup.

It may simply be a problem of space.

Re: ERROR on sas Tabulate and transpose

yadiacho1 — Mon, 02 Jan 2023 02:15:01 GMT

Yup, still error after restart PC or Apps

Re: ERROR on sas Tabulate and transpose

yadiacho1 — Mon, 02 Jan 2023 02:18:12 GMT

I'm running it in Local PC. I'm using SAS Base. and version SAS 9.4 TS level 1M3.

Is there any package need to install?

Re: ERROR on sas Tabulate and transpose

Kurt_Bremser — Mon, 02 Jan 2023 07:35:26 GMT

Keep an eye on your disk state while you run the step. You may run out of space.

Re: ERROR on sas Tabulate and transpose

yadiacho1 — Mon, 02 Jan 2023 08:13:38 GMT

I'm using samsung ssd 1tb, is there problem on it?

Re: ERROR on sas Tabulate and transpose

ballardw — Mon, 02 Jan 2023 08:15:11 GMT

Run this code and show us the result:

ods select nlevels;
proc freq data=ddgrda.ksm_eom nlevels;
   tables bikole dt_time;
run;

That will show us how many row/columns you have requested in proc tabulate. If you have a very large number of row/columns requested you can have issues with memory. Which bring up exactly which ODS destination(s) do you have open?

BTW, it is much preferred that you post LOG entries as text pasted into a text box opened with the </>. That way we can copy/paste and edit code or select pieces that may need to be addressed. When we have a picture that is not possible and I am way to too lazy to retype any significant amount of code.