03-08-2018 08:10 PM - edited 03-08-2018 08:56 PM
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