Programming the statistical procedures from SAS

proc genmod with larger files

Reply
Frequent Contributor
Posts: 93

proc genmod with larger files

[ Edited ]

Attempting to run proc genmod on a dataset that's 2.0GB.  When I execute the code, it just runs indefinitely without giving an error message.  Note code works fine on 1GB file.  Procedure completes in under two minutes without any errors.  When I create a 2GB file by duplicating the 1GB file, the program runs indefinitely.

 

I'm running SAS 9.4 on a Windows 10 computer with 2 CPUs, 128GB of RAM, and a PCIe SSD.  I've adjusted the SAS config file to utilize all the resources of the machine, see below.  Also, I've tried the SGIO option but got the same result.  Any ideas of why proc genmod won't work on the larger file?  Thank you.

 

proc genmod data=zrs.large_file;
class var1 var2 var3 var4;
model glm_test=var1 var2 var3 var4
/dist=tweedie link=log offset=bios2 pscale;
weight var5;
run;
-FONTSLOC "C:\Program Files\SASHome\ReportFontsforClients\9.4"
-SET MYSASFILES "?FOLDERID_Documents\My SAS Files\9.4"
-SASUSER "?FOLDERID_Documents\My SAS Files\9.4"
-WORK "!TEMP\SAS Temporary Files"
-MEMSIZE 100G
-MEMMAXSZ 20G
-SORTSIZE 75G
-SUMSIZE 75G
-REALMEMSIZE 75G
-CPUCOUNT ACTUAL
-THREADS
-BUFNO MAX

 

 

Ask a Question
Discussion stats
  • 0 replies
  • 94 views
  • 0 likes
  • 1 in conversation