[RBASE-L] - SV: updating many columns in a table

[Claes-Robert Julander]

Hallo Bo
Nice to hear that there is more than one rbase user in the Stockholm area.
Rbase 2.11 - those were the days...
All the best
Claes- Robert

Från: rbase-l@googlegroups.com  för Bo Franzén 

Skickat: den 5 april 2018 10:06:37
Till: rbase-l@googlegroups.com
Ämne: [RBASE-L] - SV: updating many columns in a table


Glad to hear Claes-Robert that there are more professionals than me in 
Stockholm that has been using R:BASE in research since the days of Microrim 
(remember R:BASE 2.11 Swedish version!).


Y s

Bo Franzén

Department of Economic History

Stockholm University


Från: rbase-l@googlegroups.com  för Claes-Robert 
Julander 
Skickat: den 5 april 2018 08:50
Till: rbase-l@googlegroups.com
Ämne: [RBASE-L] - SV: updating many columns in a table

Hallo,
Apparently I was not considered as a safe sender to this group. Could the 
administrator please explain. I have been a customer of rbase for many years, I 
am a professor emeritus of the Stockholm School of Economics etc. Now I
Wonder what the problem is.
Sincerely
Claes-Robert Julander

Från: rbase-l@googlegroups.com  för Claes-Robert 
Julander 
Skickat: den 3 april 2018 12:25:38
Till: rbase-l@googlegroups.com
Ämne: [RBASE-L] - updating many columns in a table


Den här avsändaren har underkänts i bedrägerikontrollen och kanske egentligen 
är någon annan. Läs mer om förfalskning<http://aka.ms/LearnAboutSpoofing>
Feedback<http://aka.ms/SafetyTipsFeedback>

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<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

--
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<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

--
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<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

-- 
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.

[RBASE-L] - SV: updating many columns in a table

[Bo Franzén]

Glad to hear Claes-Robert that there are more professionals than me in 
Stockholm that has been using R:BASE in research since the days of Microrim 
(remember R:BASE 2.11 Swedish version!).


Y s

Bo Franzén

Department of Economic History

Stockholm University


Från: rbase-l@googlegroups.com  för Claes-Robert 
Julander 
Skickat: den 5 april 2018 08:50
Till: rbase-l@googlegroups.com
Ämne: [RBASE-L] - SV: updating many columns in a table

Hallo,
Apparently I was not considered as a safe sender to this group. Could the 
administrator please explain. I have been a customer of rbase for many years, I 
am a professor emeritus of the Stockholm School of Economics etc. Now I
Wonder what the problem is.
Sincerely
Claes-Robert Julander

Från: rbase-l@googlegroups.com  för Claes-Robert 
Julander 
Skickat: den 3 april 2018 12:25:38
Till: rbase-l@googlegroups.com
Ämne: [RBASE-L] - updating many columns in a table


Den här avsändaren har underkänts i bedrägerikontrollen och kanske egentligen 
är någon annan. Läs mer om förfalskning<http://aka.ms/LearnAboutSpoofing>
Feedback<http://aka.ms/SafetyTipsFeedback>

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<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

--
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<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

-- 
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.

[RBASE-L] - SV: updating many columns in a table

[Claes-Robert Julander]

Hallo,
Apparently I was not considered as a safe sender to this group. Could the 
administrator please explain. I have been a customer of rbase for many years, I 
am a professor emeritus of the Stockholm School of Economics etc. Now I
Wonder what the problem is.
Sincerely
Claes-Robert Julander

Från: rbase-l@googlegroups.com  för Claes-Robert 
Julander 
Skickat: den 3 april 2018 12:25:38
Till: rbase-l@googlegroups.com
Ämne: [RBASE-L] - updating many columns in a table


Den här avsändaren har underkänts i bedrägerikontrollen och kanske egentligen 
är någon annan. Läs mer om förfalskning
Feedback

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.

-- 
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.