merge - SAS how groupformat works -


i found on sas official website.

use groupformat option in statement ensure 1. formatted values used group observations when format statement , statement used in data step 2. first.variable , last.variable assigned formatted values of variable

and example uses illustrate usage of groupformat 

proc format;    value range       low -55 = 'under 55'       55-60   = '55 60'       60-65   = '60 65'       65-70   = '65 70'       other   = 'over 70'; run;  proc sort data=class out=sorted_class;    height; run;  data _null_;    format height range.;    set sorted_class;       height groupformat;    if first.height       put 'shortest in ' height 'measures ' height:best12.; run;

but don't understand how example shows groupformat "ensures" formatted values used group observations when format statement , statement used in data step.

look @ results , without groupformat statement:

4805 4806   data _null_; 4807      format height range.; 4808      set sorted_class; 4809         height groupformat; 4810      if first.height 4811         put 'shortest in ' height 'measures ' height:best12.; 4812   run;  shortest in under 55 measures 51.3 shortest in 55 60 measures 56.3 shortest in 60 65 measures 62.5 shortest in 65 70 measures 65.3 shortest in on 70 measures 72 note: there 19 observations read data set work.sorted_class. note: data statement used (total process time):       real time           0.05 seconds       cpu time            0.01 seconds   4813 4814   data _null_; 4815      format height range.; 4816      set sorted_class; 4817         height ; 4818      if first.height 4819         put 'shortest in ' height 'measures ' height:best12.; 4820   run;  shortest in under 55 measures 51.3 shortest in 55 60 measures 56.3 shortest in 55 60 measures 56.5 shortest in 55 60 measures 57.3 shortest in 55 60 measures 57.5 shortest in 55 60 measures 59 shortest in 55 60 measures 59.8 shortest in 60 65 measures 62.5 shortest in 60 65 measures 62.8 shortest in 60 65 measures 63.5 shortest in 60 65 measures 64.3 shortest in 60 65 measures 64.8 shortest in 65 70 measures 65.3 shortest in 65 70 measures 66.5 shortest in 65 70 measures 67 shortest in 65 70 measures 69 shortest in on 70 measures 72 note: there 19 observations read data set work.sorted_class. note: data statement used (total process time):       real time           0.01 seconds       cpu time            0.01 seconds

from there obvious groupformat makes groups based on formatted value. without it, using raw value in height.


Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

inno setup - TLabel or TNewStaticText - change .Font.Style on Focus like Cursor changes with .Cursor -

is possible change .font.style on focus tlabel or tnewstatictext happens cursor when use .cursor ? there no built-in support track mouse hovering in inno setup @ time. however, intercepting window procedure of controls can track yourself. following example need innocallback library: [setup] appname=my program appversion=1.5 defaultdirname={pf}\my program outputdir=userdocs:inno setup examples output [files] source: "innocallback.dll"; destdir: "{tmp}"; flags: dontcopy [code] #ifdef unicode #define aw "w" #else #define aw "a" #endif const gwl_wndproc = -4; wm_mousemove = $0200; type wparam = uint_ptr; lparam = longint; lresult = longint; twindowproc = function(hwnd: hwnd; umsg: uint; wparam: wparam; lparam: lparam): lresult; function setcapture(hwnd: hwnd): hwnd; external 'setcapture@user32.dll stdcall'; function releasecapture: bool; external 'releasecapture@user32.dll stdcall'; func...
Read more