I have an automated process that runs proc means on 24 million observations and 10 class variables in SAS Grid environment.    I looked at the real time on the log and couldn't understand what it say.    real time 1:25:43:10.19 cpu time 10:20:23 How would you read the real time: Is it [day],[hours], [min], [secound], [microsecound] ? ... View more

I’m creating a title page. Here is how I started. I enter all the information into a sas dataset and then read in the dataset using proc reports and apply style format using call define statement. Somehow it’s not giving me the style format I specified. Does anyone know what I’m doing wrong? Here is what I want: 1st line:  font_size 16, Calibri, Bold, background= Blue ,color=white 2 nd line:  font_size 12, Calibri, Blue ,color=white 3 rd line:  font_size 12, Calibri, Blue ,color=white 4 th line:  font_size 12, Calibri, Blue ,color=white 5 th – 9 th line: font_size 12, Calibri, light Blue ,color=Darkblue Here is what I have. Can you please help? ods listing close;   ods escapechar="^";   ods tagsets.ExcelXP       file="&path./&file_name."       style=festival       options(orientation='portrait'               skip_space = '2,0,0,0,0'); %let run_date = %sysfunc(today(),mmddyy10.); data cover_page;         length line $200. ;         do i= 1 to 28;             if i = 1  then line="Daily report " ;             if i = 2  then line="Version: DM0203: ";             if i = 3  then line="Report Run on:&run_date.";             if i = 4  then line="                        ";             if i = 5  then line="List of Views:";             if i = 6  then line=">> Report1  ";             if i = 7  then line=">> Report2 ";             if i = 8  then line=">> Detail1  ";             if i = 9  then line=">> Detail2  ";    output; drop I; end; run; ods tagsets.excelXP        options(sheet_name='Cover Page'                width_fudge='.0625'                width_points='12'                absolute_column_width='600'                Fittopage='Yes'                skip_space ='2,0,0,0,0'                Pages_FitWidth = '1'                pages_Fitheight = '1'                embedded_titles='Yes'                center_vertical='Yes'                center_horizontal='Yes'                autofit_height='Yes'); title; proc report noheader nowd data=kdev.cover_page;   column line;    define line /display ' ';    compute line;     rownum= obsno + 1;       if rownum =1 then do;          Call Define(_row_,'STYLE','STYLE={color=white font_face=calibri font_wight=Bold fontfontsize=16 background=#366092}');       end;       if rownum =2 then do;          Call Define(_row_,'STYLE','STYLE={color=white font_face=calibri fontsize=12 background=#366092}');       end;       if rownum =3 then do;          Call Define(_row_,'STYLE','STYLE={color=white font_face=calibri fontsize=12 background=#366092}');       end;       if rownum =4 then do;          Call Define(_row_,'STYLE','STYLE={color=#366092 font_face=calibri fontsize=12 background=#366092}');       end;       if rownum =5 then do;          Call Define(_row_,'STYLE','STYLE={color=#366092 font_face=calibri forntsize=12 background=#DCE6F1}');       end;       if rownum =6 then do;          Call Define(_row_,'STYLE','STYLE={color=#366092 font_face=calibri forntsize=12 background=#DCE6F1}');       End;          if rownum =7 then do;          Call Define(_row_,'STYLE','STYLE={color=#366092 font_face=calibri forntsize=12 background=#DCE6F1}');       end;       if rownum =8 then do;          Call Define(_row_,'STYLE','STYLE={color=#366092 font_face=calibri forntsize=12 background=#DCE6F1}');       end;       if rownum =9 then do;          Call Define(_row_,'STYLE','STYLE={color=#366092 font_face=calibri forntsize=12 background=#DCE6F1}');       end; endcomp; run; ods tagsets.ExcelXP; ods listing; ... View more

First of all thanks for reading my question. Here is what I want to do: I want to know the number of observation changed between two identical datasets for each variable. I want to create an excel report showing the variable name and the number of differences. Here is what I’m doing: I used proc compare to get the number of differences (Ndif). I created a sas datasets using ODS and extract the numbers from the dataset using data step. Here is the problem: Proc compare is generating scientific notation for  Number of differences (Ndif) ?  How can I have proc compare to display the full number. NOTE: Both datasets have 8 million observation and 500 variables.  I tried to use merge statement but it wasn’t efficient. Here is a sample code: Example:  ods listing close ; ods output compsum=outputsum; proc compare base=work.dsn1 compare=work.dsn2                                 maxprint=(100,500) novalues  listequalvar;    id loan_key; run; ods output close ; ods listing ; data outdir.summary;   set indir.outputsum;    length Field_Name $40;    batch=left(compbl(batch));    if (index(batch, 'NUM') gt 0 or index(batch, 'CHAR') gt 0) and type ne 'h' then    do;          if countw(batch, ' ') = 3 or countw(batch, ' ') = 4 then &curr_count. = 0;          if scan(batch, 2) eq 'NUM'  and countw(batch, ' ') = 7 then &curr_count. = scanq(batch, 5) ;          if scan(batch, 2) eq 'NUM'  and countw(batch, ' ') = 6 then &curr_count. = scanq(batch, 4);          if scan(batch, 2) eq 'CHAR' and countw(batch, ' ') = 6 then &curr_count. = scanq(batch, 5);          if scan(batch, 2) eq 'CHAR' and countw(batch, ' ') = 5 then &curr_count. = scanq(batch, 4);    output;    end; keep Field_Name &curr_count.; run; Thanks in advance ... View more

I want to modify existing SAS style template. The template is choose to modify is festival. These are what I want to add into the existing template. 1.      1. Change margins 2.      2. Create borders 3.      3.Change the color of header (background =light blue and font color = dark blue) 4.      4.Change title background and font color and increate the height of the cell 5.      5.Change the font and font size throughout the report to be Calibri 6.      6.Shade every other row in the report. With a lot of help from SAS documentation, I was able to implement most of the changes except these. Can someone please help me do these things? 1.      1.Set margins to (top=0.7 bottom=0.7 left=.75 right=.75) 2.      2.Shade every other row 3.      3.Increate title cell height and title font color Can you please tell me if I’m doing something wrong? here is a copy of my code: libname here "."; ODS PATH here.ismreport_store(w) sasuser.templat(read) sashelp.tmplmst(read); *ods path sasuser.ismreport(U); proc template; define Style styles.ismreport;    class SystemTitle /      cellspacing = 3 in      font_face = 'calibri';    class SystemFooter /      font_face = 'calibri'      foreground=cxe0e0e0      backgroundcolor = #366092 ;    class Header /      fontfamily = 'calibri'      fontweight = bold      foreground= #4377B6      backgroundcolor = #DCE6F1      bordertopcolor = #C8B2CC      borderbottomcolor = #C8B2CC      borderrightcolor = #C8B2CC      borderleftcolor = #C8B2CC      fontsize = 12pt;    class titlesandfooters /      fontfamily = 'calibri'      fontsize = 12pt;    class procTitle /      fontfamily = 'calibri'      fontsize = 12pt;    style Table /       bordertopwidth = .75in       borderrightstyle = solid       bordertopcolor = #560467       cellspacing = 1       cellpadding = 7       frame = box       borderbottomcolor = #560467       backgroundcolor = white       borderbottomwidth = .75in       borderbottomstyle = solid       fontweight = bold       borderrightwidth = .70in       verticalalign = middle       fontfamily = 'calibri'       borderleftstyle = solid       borderrightcolor = #560467       borderleftwidth = .70in       borderleftcolor = #560467       fontsize = 10pt       color = black       bordertopstyle = solid;    style Note /       bordertopwidth = .75in       borderrightstyle = solid       bordertopcolor = #560467       padding = 3       borderbottomcolor = #560467       backgroundcolor = white       borderbottomwidth = .75in borderbottomstyle = solid       fontweight = bold       borderrightwidth = .70in       verticalalign = middle       fontfamily = 'calibri'       borderleftstyle = solid       borderrightcolor = #560467       borderleftwidth = .70in       borderleftcolor = #560467       verticalalign = middle       textalign = center       fontsize = 10pt       color = cx000000       bordertopstyle = solid;    style Data  /       bordertopwidth = .75in       borderrightstyle = solid       bordertopcolor = #C8B2CC       padding = 3       borderbottomcolor = #C8B2CC       borderbottomwidth = .75in       borderbottomstyle = solid       fontweight = medium       borderrightwidth = .70in       verticalalign = _undef_       fontfamily = 'calibri'       borderleftstyle = solid       borderrightcolor = #C8B2CC       borderleftcolor = #C8B2CC       textalign = _undef_       fontsize = 10pt       borderleftwidth = .70in       bordertopstyle = solid;    style BodyText /       fontsize = 10pt       fontfamily = 'calibri'       color = black;    style Body /       bottommargin = .75in       topmargin = .75in       rightmargin = .70in       leftmargin = .70in;    style systemtitle /       font_face = 'calibri'       cellspacing = 3 in       cellpadding = 7       frame = box       bordertopcolor = #C8B2CC       borderbottomcolor = #C8B2CC       borderrightcolor = #C8B2CC       borderleftcolor = #C8B2CC;    style fonts /       'fixed' = 'calibri';    style Header /       foreground = #326099       background = #DCE6F1       fontfamily = fonts('fixed');    style contentfolder;    style startupfunction;    style shutdownfunction;    style footer from header;    style footerempty from footer;    style footerfixed from footer /       fontfamily = fonts('fixed');    style footeremphasis from footer /       fontstyle = italic;    style footeremphasisfixed from footerfixed /       fontstyle = italic;    style footerstrong from footer /       fontweight = bold;    style footerstrongfixed from footerfixed /       fontweight = bold;    style rowheader from header /       textalign = left;    style rowheaderempty from rowheader;    style rowheaderfixed from rowheader /       fontfamily = fonts('fixed');    style rowheaderemphasis from rowheader /       fontstyle = italic;    style rowheaderemphasisfixed from rowheaderfixed /       fontstyle = italic;    style rowheaderstrong from rowheader /       fontweight = bold;    style rowheaderstrongfixed from rowheaderfixed /       fontweight = bold;    style rowfooter from rowheader;    style rowfooterempty from rowfooter;    style rowfooterfixed from rowfooter /       fontfamily = fonts('fixed');    style rowfooteremphasis from rowfooter /       fontstyle = italic;    style rowfooteremphasisfixed from rowfooterfixed /       fontstyle = italic;    style rowfooterstrong from rowfooter /       fontweight = bold;    style rowfooterstrongfixed from rowfooterfixed /       fontweight = bold; end;    define table table.ismreport;     column _all_;     cellstyle MOD(_row_, 2) as {foreground=black backgroundcolor=#F2F2F2}; end; run; ... View more

I have a .lst file that contain information similar to what’s below. I want to keep  the number next to the word LABEL. For example: Varname len1 len2 l      abel   ndif    maxdif Aaaa        1        1      LABEL   4       .01 BBBB       2        2      LABEL   5       0.2 I want to keep only  AAAA 4 BBBB  5 I should I do this in SAS? ... View more