SAS: Creating classdata -


i'm trying create classdata proc tabulate command. how can following less code? rather having spell out eventtime , node each of 2 groups, can add text each node, starting l, ll , lw etc?

proc sql; create table foo(prefflag num, eventtime num,node char(100)); quit; proc sql;  insert foo (prefflag, eventtime, node)                                                                                          values (0,1, "") values (0,2, "l") values (0,2, "w") values (0,3, "ll") values (0,3, "lw") values (0,3, "wl") values (0,3, "ww") values (0,4, "lll") values (0,4, "llw") values (0,4, "lwl") values (0,4, "lww") values (0,4, "wll") values (0,4, "wlw") values (0,4, "wwl") values (0,4, "www") values (0,5, "llll") values (0,5, "lllw") values (0,5, "llwl") values (0,5, "llww") values (0,5, "lwll") values (0,5, "lwlw") values (0,5, "lwwl") values (0,5, "lwww") values (0,5, "wlll") values (0,5, "wllw") values (0,5, "wlwl") values (0,5, "wlww") values (0,5, "wwll") values (0,5, "wwlw") values (0,5, "wwwl") values (0,5, "wwww") values (1,1, "") values (1,2, "l") values (1,2, "w") values (1,3, "ll") values (1,3, "lw") values (1,3, "wl") values (1,3, "ww") values (1,4, "lll") values (1,4, "llw") values (1,4, "lwl") values (1,4, "lww") values (1,4, "wll") values (1,4, "wlw") values (1,4, "wwl") values (1,4, "www") values (1,5, "llll") values (1,5, "lllw") values (1,5, "llwl") values (1,5, "llww") values (1,5, "lwll") values (1,5, "lwlw") values (1,5, "lwwl") values (1,5, "lwww") values (1,5, "wlll") values (1,5, "wllw") values (1,5, "wlwl") values (1,5, "wlww") values (1,5, "wwll") values (1,5, "wwlw") values (1,5, "wwwl") values (1,5, "wwww");                                                                                                                                                                                                          quit;

try using arrays in data step. not less code, less repetitive.

data foo;   format node $4.;   array a[2] $ ('l','w');   array b[4] $ ('ll,','lw',...);   array c[8] $ ('lll',...);   array d[16] $ ('llll',...);    i=0 1;     preflag=i;     eventtime=1; node=''; output;     eventtime=2; j=1 dim(a); node=a[j]; output; end;     eventtime=3; j=1 dim(b); node=b[j]; output; end;     eventtime=4; j=1 dim(c); node=c[j]; output; end;     eventtime=5; j=1 dim(d); node=d[j]; output; end;   end;    drop a1-a2 b1-b4 c1-c8 d1-d16;  run;

-

Comments

Post a Comment

Popular posts from this blog

android - Automated my builds -

i have multiple app , android project want automated in build , release sequence. have ant script build , create apk of app. want have 1 script or ant file start build sequence app. maybe don't konw search, can't find easy documentation on ant. the point of use jenkins ant (or maven, i'm not sure of difference between them now) automated build sequence when people commit on project. any int appreciated maven dependencies (over ant) don't need pass around jars. recommend maven on ant day. syntax , overall process easier understand, @ end of both build tools. if able to, more recommend upgrading gradle. easy create different build types , create them ./gradlew assemble here project jake wharton can see power of gradle. there release , debug build, can make lot more if like. https://github.com/jakewharton/u2020 here android docs gradle http://tools.android.com/tech-docs/new-build-system/user-guide . if can't find looking here, check out main grad...
Read more

ruby on rails - Difference between "Redmine on Heroku" and "Installing Redmine" documentation -

my intention install redmine on heroku. on redmine.org, there 2 docs came across: http://www.redmine.org/projects/redmine/wiki/redmineinstall http://www.redmine.org/projects/redmine/wiki/howto_install_redmine_on_heroku . i know second doc self-explanatory in title want know if follow first doc's instructions, able still deploy redmine heroku. or better follow second doc's instructions? a noob @ this, feedback appreciated. in advance. ============== following heroku specific instructions (step 5), tried run rake generate_secret_token using ruby's cmd 'please configure config/database.yml first'. there 2 related files in 2 different locations. c:\users\\redmine\config , c:\users\\desktop\\redmine-2.5.1\config. database.yml use? config file on second path has database.yml.example. make change there , save 'database.yml'? or make change in first location, cd first location , run rake generate_secret_token? follow heroku-specific instruc...
Read more

c# - Create a custom control in Corel Draw X6 using only VSTA -

i in process of creating plugin (or addin) coreldraw x6 using vsta (visual studio applications) because c# , .net library . have button in coreldraw toolbar, when user clicks button action happens, example, form showed. use predefined solution vstaglobal , there me when start coreldraw . unfortunately, there no official documentation (wtf!!!!!) vsta in coreldraw , instead have vba (visual basic applications) documentation , coreldraw object model . googled lot , found few links: some forum post , youtube video tutorial . problem is, both guys there create customcontrol (a buton example) , build *.dll , use vba script add customcontrol coreldraw toolbar this sub addlinewidthcontrol() call framework.commandbars("standard").controls. ' addcustomcontrol("mynamespace.mycustomcontrolclass", ' "mycustomcontrolassembly.dll") end sub so, question is: is there way using vsta ? additional info : ...
Read more