search for: vilno

In clinical trial data preparation and many other data situations, the statistical programmer needs to merge and re-merge multiple input files countless times. A syntax for merging files that is clear and concise is very important for the statistical programmer's productivity. Here is how Vilno does it: inlist dataset1 dataset2 dataset3 ; joinby variable1 variable2 where ( var3<=var4 ) ; Each column in a dataset has a variable name ( variable1, variable2, var3, var4 ). You are merging three input datafiles: dataset1, dataset2, and dataset3. The joinby statement asks for a many-to-ma...

...rsion number might not give a good idea of how mature the data transformation features are, it reflects the fact that he has only started doing the statistical tests. The founder: Ben Pfaff, either a grad student or professor at Stanford CS dept. Also at : directory.fsf.org/math/stats (GNU GPL) 3. Vilno This uses a programming language similar to SPSS and SAS, but quite unlike S. Essentially, it's a substitute for the SAS datastep, and also transposes data and calculates averages and such. (No t-tests or regressions in this version). I created this, during the years 2001-2006 mainly. It's...

In response to those who asked for a better explanation of what the Vilno software does, here's a simple example that gives some idea of what it does. LABRESULTS is a dataset with multiple rows per patient , with lab sodium measurements. It has columns: PATIENT_ID, VISIT_NUM, and SODIUM. DEMO is a dataset with one row per patient, with demographic data. It has colu...

...ere is the requested information. Most of it was on the original post for the "Tools For Preparing Data For Analysis" thread from last week, but it got overlooked. They are all given under an open source license. Check 'em out! ******************************************************* Vilno: data transformation software, that reads in input datasets (rows and columns), crunches through the data, and writes out output datasets. It's an open source application that can replace the SAS datastep ( and also replaces proc transpose and proc means ). Find it at: http://code.google.com/p...

...e reading this, Christophe Pallier & Martin Stevens, I will respond to your request for examples shortly, once I figure this posting how-to out. My examples will come from data preparation problems in clinical trial data ( I worked for 8 years on clinical trial analysis before beginning work on Vilno ). I'll probably use lab data as an example because lab data can be messy and difficult to work with.