http://support.sas.com/forums/message.jspa?messageID=55818 ... View more

data sample_data; infile datalines; input original_variable $48.; datalines; 20110503 09:58:47.65 ; run; data modified_data; set sample_data; *** separate date from original string ***; date=input(scan(original_variable,1,' '), yymmdd8.); *** separate time from original string ***; time=scan(original_variable,-1,' '); *** separate out hours minutes and seconds ***; hour=input(scan(time,1,':'),2.); minute=input(scan(time,2,':'),2.); second=input(scan(time,3,':'),2.); *** create datetime variable ***; datetime=dhms(date,hour,minute,second); *** check work ***; datetime2=put(datetime,datetime.); run; ... View more

Can you try something like this? data one; input School $ Month $ StudentName $ Subject $ Test1 Test2 Test3 Test4 Total; datalines; ABC July-10 John Math 90 79 86 99 354 ABC July-10 John Science 92 89 99 91 371 ABC July-10 John History 78 69 82 79 308 ABC July-10 John English 81 79 83 82 325 ABC July-10 Becky Math 92 77 76 88 333 ABC July-10 Becky Science 67 76 65 83 291 ABC July-10 Becky History 78 69 76 79 302 ABC July-10 Becky English 90 79 80 81 330 ABC Dec-10 John Math 97 93 89 99 378 ABC Dec-10 John Science 80 89 92 91 352 ABC Dec-10 John History 70 77 76 80 303 ABC Dec-10 John English 80 69 78 81 308 ABC Dec-10 Becky Math 80 70 67 82 299 ABC Dec-10 Becky Science 78 73 66 76 293 ABC Dec-10 Becky History 87 77 79 74 317 ABC Dec-10 Becky English 79 72 84 81 316 ; run; proc tabulate data=one; class studentname subject month; var test1; table subject, studentname, month*test1; keylabel sum=' '; run; ... View more

data sample_data; infile datalines; input year state $ rate; datalines; 2009 MA 150 2009 NH 80 2009 ME 55 2010 MA 155 2010 NH 87 2010 ME 60 ; run; data modify; set sample_data; select(state); when ('MA') do; if year=2009 then rate=rate*2; else if year=2010 then rate=rate*1.5; end; when ('NH') do; if year=2009 then rate=rate*3; else if year=2010 then rate=rate*2; end; when ('ME') do; if year=2009 then rate=rate*3; else if year=2010 then rate=rate*2.5; end; otherwise; end; run; ... View more

You could try adjusting the bottommargin option. ... View more

proc format; value tgt_pct_mask 0-.09999='Less than 10%' .1-1=[percent7.1]; run; data sample_data; do i=1 to 100; tot_comp=ranuni(1); output; end; run; proc report data=sample_data nowd; column i tot_comp; define i/display; define tot_comp/analysis format=tgt_pct_mask.; run; ... View more

Can you try a nested format? proc format; value tgt_pct_mask 0-<.1='Less than 10%' .1-1=[percent7.1]; run; data sample_data; do i=1 to 100; tot_comp=ranuni(1); output; end; run; proc report data=sample_data nowd; column i tot_comp; define i/display; define tot_comp/analysis format=tgt_pct_mask.; run; ... View more

options missing=' '; Add this code before the proc report statement. ... View more

In this case, I believe the "ALL" statement will not give you what you need. You could bring the x variable into a proc report and use a compute block. Or you could calculate the totals before displaying the data with proc tabulate. Here's a sample way to the second approach. proc format; value $period_group (multilabel) '01'='01' '02'='02' '03'='03' '04'='04' '05'='05' '06'='06' '07'='07' '08'='08' '09'='09' '10'='10' '11'='11' '12'='12' '01'-'12'='Total'; run; **** Create Sample Data *****; data sample_data; do i=1 to 12; do j=1 to 20; month=i; a= int(100*rand('uniform')); x= int(100*rand('uniform')); *** make the denominator bigger than the numerator ***; if x > a then output; end; end; keep month a x; run; proc sort data=sample_data; by month; run; ***** Limit sample data to one row per period *****; data limit_data; length period $2; set sample_data; by month; if first.month; *** create period variable ***; if 1 le month le 9 then period='0'||left(month); else if 10-12 then period=month; run; proc summary data=limit_data; class period /mlf; format period $period_group.; var a x; types period ; output out=group_periods (drop=_type_ _freq_)sum=; run; data abc; set group_periods; *** b calculation ***; b=(a/x); run; proc tabulate data=abc; class period ; format period ; var a b; table a*f=comma9.0 b*f=percent9.2, period=' '*sum=' ' ; keylabel sum=' '; run; ... View more

Did you try changing your preferences? Go to Tools then Options then Preferences. Click the Results Tab and uncheck the "Create listing" box. Your "View results as they are generated" may be checked too. You could try unchecking that too. Hope this helps. ... View more

http://support.sas.com/kb/24/655.html ... View more