sas - Proc report is exporting file size larger than expected -


this code generating file size greater 5mb, though have 3200 records. suggestions ? appreciated. have been struggling past 2 days.

it giving me insufficient memory error. have other codes similar 1 , able run code without errors.

%macro report(date);  %let a= %eval(%sysfunc(today()); %let year= %sysfunc(putn(&a,year4.)); %let mon= %sysfunc(putn(&a,month2.)); %let day= %sysfunc(putn(&a,day2.));   proc sql;  create table vdata.report select country, province, city, code, link, activity, first_name, last_name,  is_coordinator, is_host, email, phone, business_group, managers_email, transportation v_data.raw_plus_&date;  quit;   proc sort data=vdata.pm_report; country province activity last_name; run;   ods listing close; ods tagsets.excelxp file="/path/ report - &date..xml"; ods tagsets.excelxp options (sheet_name="report");  proc report data=vdata.report nowd  style(header)=[font_weight=bold background=cxdce6f1 font_size=1.2 ] ; column ("registration of &year-&mon-&day" ("report" country province city code link activity first_name last_name  is_coordinator is_host email phone business_group managers_email  transportation));  define  country / display format= $char100. style(column)=[width=75 font_size=1] style(header)=[background = cxc2d69a]   spacing=2   left "country" ; define  province / display format= $char100. style(column)=[width=60 font_size=1] style(header)=[background = cxc2d69a]  spacing=2   left "province"; define  city / display format= $char100. style(column)=[width=80 font_size=1]  style(header)=[background = cxc2d69a]   spacing=2   left "city" ; define  code / display format= $char100. style(column)=[width=170 font_size=1]  style(header)=[background = cxc2d69a]  spacing=2   left "project id#" ; define  link / display format= $char100. style(column)=[width=200 font_size=1] style(header)=[background = cxc2d69a]    spacing=2   left "region" ; define  activity / display format= $char100. style(column)=[width=500 font_size=1]  style(header)=[background = cxc2d69a]  spacing=2   left "select activity" ; define  first_name / display format= $char100. style(column)=[width=90 font_size=1]  style(header)=[background = cxc2d69a]  spacing=2   left "first name" ; define  last_name / display format= $char100. style(column)=[width=220 font_size=1] style(header)=[background = cxc2d69a]   spacing=2   left "last name" ; define  is_coordinator / display format= $char100. style(column)=[width=120 font_size=1] style(header)=[background = cxc2d69a]   spacing=2   left "activity coordinator" ; define  is_host / display format= $char100. style(column)=[width=80 font_size=1]  style(header)=[background = cxc2d69a]  spacing=2   left "host" ; define  email / display format= $char100. style(column)=[width=250 font_size=1]  style(header)=[background = cxc2d69a]  spacing=2   left "e-mail" ; define  phone / display format= $char100. style(column)=[width=100 font_size=1]  style(header)=[background = cxc2d69a]  spacing=2   left "phone #" ; define  business_group / display format= $char100. style(column)=[width=270 font_size=1]  style(header)=[background = cxc2d69a]  spacing=2   left "business group" ; define  managers_email / display format= $char100. style(column)=[width=220 font_size=1]  style(header)=[background = cxc2d69a]  spacing=2   left "reporting managers email" ; define  transportation / display format= $char100. style(column)=[width=220 font_size=1] style(header)=[background = cxc2d69a]   spacing=2   left "transportaion needed?" ;  compute country; if country = "canada"      call define(_row_, 'style', 'style = {background=#ffffff font_size=1}' ); else if country = "united states"     call define(_row_, 'style', 'style = {background=#ffffff font_size=1}' ); endcomp;   run;   ods ods tagsets.excelxp close;  %mend;

thanks in advance.

i haven't tested i'll hazard guess width of fields exporting.

check width of of variables being exported excel. they're wide. combined have width of 2500 bytes. 

width*rows = ~2500*3200 = 8,000,000 bytes = 8 megabytes

i'm not sure if excel compression on consecutive space characters, if not, explain size.

for variables excessively wide, assign them appropriate width length statement. i'm pretty sure don't need width of 100 phone number (for example).


Comments

Post a Comment

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

i have following sample code used pre-decrement void function(int c) { if(c == 0) { return; } else { cout << "dp" << c << endl; function(--c); cout << c << endl; return; } } this function give output input 4 : dp3 dp2 dp1 dp0 0 1 2 3 but when use post decrement void function(int c) { if(c == 0) { return; } else { cout << "dp" << c << endl; function(c--); cout << c << endl; return; } } output goes in infinite loop dp4 can explain me in detail why happens ? this happens because function(c--) called same value of c , when finishes c decremented. recursively called, hence called same value no chance of return , hit stack overflow error. assume this, int x = 1, y = 0; y = x++ result y == 1 , x == 2. if y = ++x , bot x , y 2.
Read more

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

i added new project. made mistake in projectname.conf file in sites-available apache2, led me reinstalling apache2. after reinstalling , re-enabling projects on every page of every project .. <body> run(); </body> .. i've run composer update, restarted service, restarted pc, checked config files, tried disabling new project. there nothing in error log, , access.log: 127.0.0.1 - - [15/may/2015:01:40:47 +0200] "get / http/1.1" 304 181 "-" "mozilla/5.0 (x11; ubuntu; linux x86_64; rv:38.0) gecko/20100101 firefox/38.0" maybe i'm forgetting apache2 reinstall? don't think did different last time installed it. looks haven't setup php correctly. take @ this great guide , maybe you're forgetting link php config apache2.
Read more

php - How can I echo out this array? -

i don't know how go grabbing data in variable , put foreach loop. class tree{ private $info = array( array('name'=>'jim','state'=>'nu','company'=>'nu','phone'=>array('cell'=>'5615111111','office'=>'5611111111'),'email'=>array('primary'=>'exs@example.com','ex@there.com')), array('name'=>'joe smith','city'=>'phoenix','phone'=>'4805551111','email'=>'jsmith@some_email.com'), array('name'=>'john doe','city'=>'chandler','company'=>'doe co.','email'=>array('jdoe@gmail.com','personal'=>'email@email.com'),'phone'=>'6025550002') ); } if you're inside of class, can access private variable using $this->variablename . example, i...
Read more