DATA Step, Macro, Functions and more

sas PROC MEANS ERROR sas proc summary error

Reply
New Contributor
Posts: 2

sas PROC MEANS ERROR sas proc summary error

[ Edited ]

windows 7 32bit x86 professional with 4 gigs but windows 7 32 bit only recognizes 3.5 gb of ram.

 

running sas 9.0

 

i did some light reading, and you need to pax eax or something make the ssd and os hard coded to x36 bit so windows can use the full 4gb of ram and recognize the 4 gb. but that is an endless fail. when i run proc means i get this error, (i think i read somewhere that sas is telling us it tried to use 4 gigs of memory or more to complete this process(proc means) but failed because of this error, ...... maybe says i dont have enough memory/ram ) is that true? i hope it isnt... because then sas 9.0 32bit wouldnt be made for a 32bit os when 32 os can have up to 4 gigs but usuable by any 32 bit os would be more like 3.5gb windows 7 or 2.5 windows vista...

 

oh im only dealing with 20 subjects x 18 visitnum * 3 variables(qsstresn chgbl pctbl) its not even that much compared to other data sets i have worked with..... but then again that proc means univariate and summary sure DOOO alot of work!

 

error with proc means

1621 proc means data=qc04 noprint;
1622 by usubjid;
1623 /* where cnt<=7;*/
1624 var qsstresn chgbl pctbl;
1625 output out=qc05 n=n1 n2 n3 mean=mean1 mean2 mean3 std=std1 std2 std3
1626 median=median1 median2 median3 min=min1 min2 min3 max=max1 max2 max3;
1627 run;

ERROR: Read Access Violation In Task ( MEANS )
Exception occurred at (66FE70BC)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
66FE70BC 06DAF664 0001:000260BC sassfm01.dll
66FD97A2 06DAF6A4 0001:000187A2 sassfm01.dll
66FD83A5 06DAF71C 0001:000173A5 sassfm01.dll
66FCBDC6 06DAF7BC 0001:0000ADC6 sassfm01.dll
66FC386E 06DAF7E0 0001:0000286E sassfm01.dll
67008769 06DAFEC8 0001:00007769 sasmeans.dll
67E223EE 06DAFEE4 0001:000113EE sashost.dll
67E26DE0 06DAFEF8 0001:00015DE0 sashost.dll
011449C7 02E5EA68 0001:000139C7 os_exe.exe
67E26DA8 05543D90 0001:00015DA8 sashost.dll

NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 226 observations read from the data set WORK.QC04.
WARNING: The data set WORK.QC05 may be incomplete. When this step was stopped there
were 16 observations and 21 variables.
WARNING: Data set WORK.QC05 was not replaced because this step was stopped.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.17 seconds
cpu time 0.09 seconds

 

 

to fix this use proc univariate

 

proc univariate data=qc04 noprint;
by usubjid;
/* where cnt<=7;*/
var qsstresn chgbl pctbl;
output out=qc05 n=n1 n2 n3 mean=mean1 mean2 mean3 std=std1 std2 std3
median=median1 median2 median3 min=min1 min2 min3 max=max1 max2 max3;
run;

 

but how am i supose to with ease use the function to check the work? i mean i can do 1 transpose and 6 proc means + 3 arrays *3 array variables....  but that is not very efficient...

 

 

same erro with proc summary....

1632 proc summary data=qc04 noprint;
1633 by usubjid;
1634 /* where cnt<=7;*/
1635 var qsstresn chgbl pctbl;
1636 output out=qc05 n=n1 n2 n3 mean=mean1 mean2 mean3 std=std1 std2 std3
1637 median=median1 median2 median3 min=min1 min2 min3 max=max1 max2 max3;
1638 run;

ERROR: Read Access Violation In Task ( SUMMARY )
Exception occurred at (66FE70BC)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
66FE70BC 06DAF664 0001:000260BC sassfm01.dll
66FD97A2 06DAF6A4 0001:000187A2 sassfm01.dll
66FD83A5 06DAF71C 0001:000173A5 sassfm01.dll
66FCBDC6 06DAF7BC 0001:0000ADC6 sassfm01.dll
66FC386E 06DAF7E0 0001:0000286E sassfm01.dll
67008769 06DAFEC8 0001:00007769 sasmeans.dll
67E223EE 06DAFEE4 0001:000113EE sashost.dll
67E26DE0 06DAFEF8 0001:00015DE0 sashost.dll
011449C7 02E5E918 0001:000139C7 os_exe.exe
67E26DA8 0553D400 0001:00015DA8 sashost.dll

NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 226 observations read from the data set WORK.QC04.
WARNING: The data set WORK.QC05 may be incomplete. When this step was stopped there
were 16 observations and 21 variables.
WARNING: Data set WORK.QC05 was not replaced because this step was stopped.
NOTE: PROCEDURE SUMMARY used (Total process time):
real time 0.23 seconds
cpu time 0.10 seconds

Super User
Posts: 19,775

Re: sas PROC MEANS ERROR sas proc summary error

Posted in reply to AJSchwab7

You mean you're running SAS 9.04 AKA SAS 9.4?

If you're truly running SAS 9.0 I'm amazed it's running on Windows 7. 

What does the following return:

 

%put SAS Long Version: &sysvlong4;
%put SAS Version: &sysver;

 

These errors are unexpected and you should contact SAS tech support for help. 

 

Your data size is trivial and shouldn't be an issue, something else is causing this issue. 

 

 

New Contributor
Posts: 2

Re: sas PROC MEANS ERROR sas proc summary error

[ Edited ]

i have been dealing with that bug for a long time now...

 

well i guess it is possibly time to consider upgrading

 

unless someone can point me in the right direction for that bug

Super User
Posts: 19,775

Re: sas PROC MEANS ERROR sas proc summary error

Posted in reply to AJSchwab7

Can you even upgrade to Window 7 anymore? 

 

Good luck, SAS 9.4 is pretty good IMO. One significant difference is median function in SQL and ODS Excel. 

Ask a Question
Discussion stats
  • 3 replies
  • 242 views
  • 0 likes
  • 2 in conversation