________________________________ Från: Claes-Robert Julander Skickat: den 3 april 2018 12:25:38 Till: rbase-l@googlegroups.com Ämne: updating many columns in a table
Hallo, I used rbase since it was called Microrim, but with long intervals between each usage occasion (all depending on what type of research I was conducting). In my current research I work with several tables and use rbase for organizing my data and SPSS for statistical analysis. The tables are fairly large, one table has 39000 rows and 150 columns. This table I have in SPSS and I export it to Rbase. (I use Rbase extreme). When doing this missing data in SPSS, a., become 0, and not null. So, I need to change all the zeroes to null for 150 variables. This can of course be done with the update command, but it becomes rather tedious to write this command for all 150 columns. Is there any possibility to write a shorter command that will change all the zeroes to null for all variable and rows? Looking forward to your thoughts on this, Sincerely Claes-Robert Julander -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.