Realigning to the right after altering type to numeric

[Staffan Lindberg]

Dear list!

 

Jon Peck instructed me on converting a string variable into numeric by means of ALTER TYPE. This works fine but the data values still remains left-aligned. I didn’t know this was possible. I thought all numeric variables were automatically right-aligned. How do I syntactically change these left-aligned numeric variables into right-aligned?

 

best

 

Staffan Lindberg

Sweden

[Bruce Weaver]

Hi Staffan.  See the VARIABLE ALIGNMENT command.  Here is an example from the FM:

VARIABLE ALIGNMENT sales95 sales96 (LEFT) / id gender (RIGHT).

Staffan Lindberg wrote

Dear list!



Jon Peck instructed me on converting a string variable into numeric by means
of ALTER TYPE. This works fine but the data values still remains
left-aligned. I didn't know this was possible. I thought all numeric
variables were automatically right-aligned. How do I syntactically change
these left-aligned numeric variables into right-aligned?



best



Staffan Lindberg

Sweden

[Albert-Jan Roskam]

Hi,

I ran into the same thing a couple of months ago:

begin program.
import spss, spssaux
vnames = [v.VariableName for v in spssaux.VariableDict(variableType="numeric")]
spss.Submit("variable alignment %s (right)." % " ".join(vnames))
end program.

Regards,

Albert-Jan



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

All right, but apart from the sanitation, the medicine, education, wine, public order, irrigation, roads, a

fresh water system, and public health, what have the Romans ever done for us?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--------------------------------------------
On Tue, 1/14/14, Staffan Lindberg <[hidden email]> wrote:

 Subject: [SPSSX-L] Realigning to the right after altering type to numeric
 To: [hidden email]
 Date: Tuesday, January 14, 2014, 12:29 PM

 Dear list! � Jon Peck
 instructed me on converting a string variable into numeric
 by means of ALTER TYPE. This works fine but the data values
 still remains left-aligned. I didn’t know this was
 possible. I thought all numeric variables were automatically
 right-aligned. How do I syntactically change these
 left-aligned numeric variables into right-aligned?
  � best
 � Staffan LindbergSweden

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Jon K Peck]

VARIABLE ALIGNMENT varlist (RIGHT).

We have, by the way, fixed ALTER TYPE so that it automatically adjusts the alignment appropriately.  That will appear in the next Statistics release or perhaps in a fixpack.


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        Staffan Lindberg <[hidden email]>
To:        [hidden email],
Date:        01/14/2014 04:30 AM
Subject:        [SPSSX-L] Realigning to the right after altering type to numeric
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Dear list!
 
Jon Peck instructed me on converting a string variable into numeric by means of ALTER TYPE. This works fine but the data values still remains left-aligned. I didn’t know this was possible. I thought all numeric variables were automatically right-aligned. How do I syntactically change these left-aligned numeric variables into right-aligned?
 
best
 
Staffan Lindberg
Sweden

[Staffan Lindberg]

Thanks Bruce!

You learn something new every day! Didn't know that command existed.

best

Staffan

-----Ursprungligt meddelande-----
Från: SPSSX(r) Discussion [mailto:[hidden email]] För Bruce Weaver
Skickat: den 14 januari 2014 13:24
Till: [hidden email]
Ämne: Re: Realigning to the right after altering type to numeric

Hi Staffan.  See the VARIABLE ALIGNMENT command.  Here is an example from
the
FM:

VARIABLE ALIGNMENT sales95 sales96 (LEFT) / id gender (RIGHT).




Staffan Lindberg wrote

> Dear list!
>
>
>
> Jon Peck instructed me on converting a string variable into numeric by
> means of ALTER TYPE. This works fine but the data values still remains
> left-aligned. I didn't know this was possible. I thought all numeric
> variables were automatically right-aligned. How do I syntactically
> change these left-aligned numeric variables into right-aligned?
>
>
>
> best
>
>
>
> Staffan Lindberg
>
> Sweden

-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Realigning-to-the-right-after-
altering-type-to-numeric-tp5723906p5723907.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command SIGNOFF SPSSX-L For a list of
commands to manage subscriptions, send the command INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[John F Hall]

In the Data Editor in Variable View go to the Align column, click on the cell for a variable and change the alignment on t6he pop up sub-menu.

 

John F Hall (Mr)

[Retired academic survey researcher]

 

Email:   [hidden email] 

Website: www.surveyresearch.weebly.com

SPSS start page:  : :  www.surveyresearch.weebly.com/1-survey-analysis-workshop

 

 

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Staffan Lindberg
Sent: 14 January 2014 12:30
To: [hidden email]
Subject: Realigning to the right after altering type to numeric

 

Dear list!

 

Jon Peck instructed me on converting a string variable into numeric by means of ALTER TYPE. This works fine but the data values still remains left-aligned. I didn’t know this was possible. I thought all numeric variables were automatically right-aligned. How do I syntactically change these left-aligned numeric variables into right-aligned?

 

best

 

Staffan Lindberg

Sweden

[Art Kendall]

no audit trail.
On 1/14/2014 12:25 PM, John F Hall [via SPSSX Discussion] wrote:

In the Data Editor in Variable View go to the Align column, click on the cell for a variable and change the alignment on t6he pop up sub-menu.

 

John F Hall (Mr)

[Retired academic survey researcher]

 

Email:   [hidden email] 

Website: www.surveyresearch.weebly.com

SPSS start page:  : :  www.surveyresearch.weebly.com/1-survey-analysis-workshop

 

 

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Staffan Lindberg
Sent: 14 January 2014 12:30
To: [hidden email]
Subject: Realigning to the right after altering type to numeric

 

Dear list!

 

Jon Peck instructed me on converting a string variable into numeric by means of ALTER TYPE. This works fine but the data values still remains left-aligned. I didn’t know this was possible. I thought all numeric variables were automatically right-aligned. How do I syntactically change these left-aligned numeric variables into right-aligned?

 

best

 

Staffan Lindberg

Sweden

---

If you reply to this email, your message will be added to the discussion below:

http://spssx-discussion.1045642.n5.nabble.com/Realigning-to-the-right-after-altering-type-to-numeric-tp5723906p5723913.html

To start a new topic under SPSSX Discussion, email [hidden email]
To unsubscribe from SPSSX Discussion, click here.
NAML

[John F Hall]

. .unless you use Alt+PrintScreen or Snip to capture windows or partial screenshots and copy them to the narrative in your chronological log/diary in Word to help you and others to follow what you did, and why.

 

 

John F Hall (Mr)

[Retired academic survey researcher]

 

Email:   [hidden email] 

Website: www.surveyresearch.weebly.com

SPSS start page:  www.surveyresearch.weebly.com/1-survey-analysis-workshop

 

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Art Kendall
Sent: 14 January 2014 20:09
To: [hidden email]
Subject: Re: Realigning to the right after altering type to numeric

 

no audit trail.

Art Kendall

Social Research Consultants

On 1/14/2014 12:25 PM, John F Hall [via SPSSX Discussion] wrote:

In the Data Editor in Variable View go to the Align column, click on the cell for a variable and change the alignment on t6he pop up sub-menu.

 

John F Hall (Mr)

[Retired academic survey researcher]

 

Email:   [hidden email] 

Website: www.surveyresearch.weebly.com

SPSS start page:  : :  www.surveyresearch.weebly.com/1-survey-analysis-workshop

 

 

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Staffan Lindberg
Sent: 14 January 2014 12:30
To: [hidden email]
Subject: Realigning to the right after altering type to numeric

 

Dear list!

 

Jon Peck instructed me on converting a string variable into numeric by means of ALTER TYPE. This works fine but the data values still remains left-aligned. I didn’t know this was possible. I thought all numeric variables were automatically right-aligned. How do I syntactically change these left-aligned numeric variables into right-aligned?

 

best

 

Staffan Lindberg

Sweden

 

---

If you reply to this email, your message will be added to the discussion below:

http://spssx-discussion.1045642.n5.nabble.com/Realigning-to-the-right-after-altering-type-to-numeric-tp5723906p5723913.html

To start a new topic under SPSSX Discussion, email [hidden email]
To unsubscribe from SPSSX Discussion, click here.
NAML

 

Art Kendall
Social Research Consultants

 

---

View this message in context: Re: Realigning to the right after altering type to numeric
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

[David Marso]

And that is likely to happen?
Nice try John!
OTOH: IMNSHO: Variable alignment is an aesthetic thing and really doesn't matter squat WRT results.
--
---

John F Hall wrote

. .unless you use Alt+PrintScreen or Snip to capture windows or partial
screenshots and copy them to the narrative in your chronological log/diary
in Word to help you and others to follow what you did, and why.


John F Hall (Mr)
[Retired academic survey researcher]

Email:    <mailto:[hidden email]> [hidden email]
Website:  <http://www.surveyresearch.weebly.com/>
www.surveyresearch.weebly.com
SPSS start page:
<http://surveyresearch.weebly.com/1-survey-analysis-workshop.html>
www.surveyresearch.weebly.com/1-survey-analysis-workshop


From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Art
Kendall
Sent: 14 January 2014 20:09
To: [hidden email]
Subject: Re: Realigning to the right after altering type to numeric

no audit trail.


Art Kendall
Social Research Consultants
On 1/14/2014 12:25 PM, John F Hall [via SPSSX Discussion] wrote:
In the Data Editor in Variable View go to the Align column, click on the
cell for a variable and change the alignment on t6he pop up sub-menu.

John F Hall (Mr)
[Retired academic survey researcher]

Email:   [hidden email]
Website:  <http://www.surveyresearch.weebly.com/>
www.surveyresearch.weebly.com
SPSS start page:  : :
<http://surveyresearch.weebly.com/1-survey-analysis-workshop.html>
www.surveyresearch.weebly.com/1-survey-analysis-workshop



From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Staffan
Lindberg
Sent: 14 January 2014 12:30
To: [hidden email]
Subject: Realigning to the right after altering type to numeric

Dear list!

Jon Peck instructed me on converting a string variable into numeric by means
of ALTER TYPE. This works fine but the data values still remains
left-aligned. I didn't know this was possible. I thought all numeric
variables were automatically right-aligned. How do I syntactically change
these left-aligned numeric variables into right-aligned?

best

Staffan Lindberg
Sweden


  _____

If you reply to this email, your message will be added to the discussion
below:
http://spssx-discussion.1045642.n5.nabble.com/Realigning-to-the-right-after-
altering-type-to-numeric-tp5723906p5723913.html
To start a new topic under SPSSX Discussion, email [hidden email]
To unsubscribe from SPSSX Discussion, click here.

<http://spssx-discussion.1045642.n5.nabble.com/template/NamlServlet.jtp?macr
o=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namesp
aces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web
.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml
-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.na
ml> NAML

Art Kendall
Social Research Consultants

  _____

View this message in context: Re: Realigning to the right after altering
type to numeric
<http://spssx-discussion.1045642.n5.nabble.com/Realigning-to-the-right-after
-altering-type-to-numeric-tp5723906p5723914.html>
Sent from the SPSSX Discussion mailing list archive
<http://spssx-discussion.1045642.n5.nabble.com/>  at Nabble.com.

[John F Hall]

I do it all the time!  I have to, otherwise I forget what I'm supposed to be
doing, especially if there's a long delay between visits to a particular
saved file.

On aesthetics, it's much more important to persuade people to stop using
UPPER CASE labelling as if they were still in 1980.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
David Marso
Sent: 15 January 2014 10:53
To: [hidden email]
Subject: Re: Realigning to the right after altering type to numeric

And that is likely to happen?
Nice try John!
OTOH: IMNSHO: Variable alignment is an aesthetic thing and really doesn't
matter squat WRT results.
--
---

John F Hall wrote
> . .unless you use Alt+PrintScreen or Snip to capture windows or
> partial screenshots and copy them to the narrative in your
> chronological log/diary in Word to help you and others to follow what you
did, and why.
>
>
> John F Hall (Mr)
> [Retired academic survey researcher]
>
> Email:    &lt;mailto:

> johnfhall@

> &gt;

> johnfhall@

> Website:  &lt;http://www.surveyresearch.weebly.com/&gt;
> www.surveyresearch.weebly.com
> SPSS start page:
> &lt;http://surveyresearch.weebly.com/1-survey-analysis-workshop.html&g
> t; www.surveyresearch.weebly.com/1-survey-analysis-workshop
>
>
> From: SPSSX(r) Discussion [mailto:

> SPSSX-L@.UGA

> ] On Behalf Of Art
> Kendall
> Sent: 14 January 2014 20:09
> To:

> SPSSX-L@.UGA

> Subject: Re: Realigning to the right after altering type to numeric
>
> no audit trail.
>
>
> Art Kendall
> Social Research Consultants
> On 1/14/2014 12:25 PM, John F Hall [via SPSSX Discussion] wrote:
> In the Data Editor in Variable View go to the Align column, click on
> the cell for a variable and change the alignment on t6he pop up sub-menu.
>
> John F Hall (Mr)
> [Retired academic survey researcher]
>
> Email:   [hidden email]
> Website:  &lt;http://www.surveyresearch.weebly.com/&gt;
> www.surveyresearch.weebly.com
> SPSS start page:  : :
> &lt;http://surveyresearch.weebly.com/1-survey-analysis-workshop.html&g
> t; www.surveyresearch.weebly.com/1-survey-analysis-workshop
>
>
>
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Staffan
> Lindberg
> Sent: 14 January 2014 12:30
> To: [hidden email]
> Subject: Realigning to the right after altering type to numeric
>
> Dear list!
>
> Jon Peck instructed me on converting a string variable into numeric by
> means of ALTER TYPE. This works fine but the data values still remains
> left-aligned. I didn't know this was possible. I thought all numeric
> variables were automatically right-aligned. How do I syntactically
> change these left-aligned numeric variables into right-aligned?
>
> best
>
> Staffan Lindberg
> Sweden
>
>
>   _____
>
> If you reply to this email, your message will be added to the
> discussion
> below:
> http://spssx-discussion.1045642.n5.nabble.com/Realigning-to-the-right-
> after- altering-type-to-numeric-tp5723906p5723913.html
> To start a new topic under SPSSX Discussion, email [hidden email] To
> unsubscribe from SPSSX Discussion, click here.
>
> &lt;http://spssx-discussion.1045642.n5.nabble.com/template/NamlServlet
> .jtp?macr
> o=macro_viewer&amp;id=instant_html%21nabble%3Aemail.naml&amp;base=nabb
> le.naml.namesp
> aces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.vi
> ew.web
> .template.NodeNamespace&amp;breadcrumbs=notify_subscribers%21nabble%3A
> email.naml
> -instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aem
> ail.na
> ml&gt; NAML
>
> Art Kendall
> Social Research Consultants
>
>   _____
>
> View this message in context: Re: Realigning to the right after
> altering type to numeric
> &lt;http://spssx-discussion.1045642.n5.nabble.com/Realigning-to-the-ri
> ght-after -altering-type-to-numeric-tp5723906p5723914.html&gt;
> Sent from the SPSSX Discussion mailing list archive
> &lt;http://spssx-discussion.1045642.n5.nabble.com/&gt;  at Nabble.com.

-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email
me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos
ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in
abyssum?"
--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Realigning-to-the-right-after-
altering-type-to-numeric-tp5723906p5723916.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command SIGNOFF SPSSX-L For a list of
commands to manage subscriptions, send the command INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Art Kendall]

<soapbox on readability>
It depends on what you mean by 'results'.
Are the 'results' a few numbers on a printout?
Are 'results' the conceptions acquired by reading the printout?
Close attention to the variables view, complete labeling, numeric type, etc. facilitates relating to the meaning of what the numbers are used to represent.
<\soapbox on readability> On 1/15/2014 4:52 AM, David Marso [via SPSSX Discussion] wrote:

And that is likely to happen?
Nice try John!
OTOH: IMNSHO: Variable alignment is an aesthetic thing and really doesn't matter squat WRT results.
--
---

John F Hall wrote

. .unless you use Alt+PrintScreen or Snip to capture windows or partial
screenshots and copy them to the narrative in your chronological log/diary
in Word to help you and others to follow what you did, and why.


John F Hall (Mr)
[Retired academic survey researcher]

Email:    <mailto:[hidden email]> [hidden email]
Website:  <http://www.surveyresearch.weebly.com/>
www.surveyresearch.weebly.com
SPSS start page:
<http://surveyresearch.weebly.com/1-survey-analysis-workshop.html>
www.surveyresearch.weebly.com/1-survey-analysis-workshop


From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Art
Kendall
Sent: 14 January 2014 20:09
To: [hidden email]
Subject: Re: Realigning to the right after altering type to numeric

no audit trail.


Art Kendall
Social Research Consultants
On 1/14/2014 12:25 PM, John F Hall [via SPSSX Discussion] wrote:
In the Data Editor in Variable View go to the Align column, click on the
cell for a variable and change the alignment on t6he pop up sub-menu.

John F Hall (Mr)
[Retired academic survey researcher]

Email:   [hidden email]
Website:  <http://www.surveyresearch.weebly.com/>
www.surveyresearch.weebly.com
SPSS start page:  : :
<http://surveyresearch.weebly.com/1-survey-analysis-workshop.html>
www.surveyresearch.weebly.com/1-survey-analysis-workshop



From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Staffan
Lindberg
Sent: 14 January 2014 12:30
To: [hidden email]
Subject: Realigning to the right after altering type to numeric

Dear list!

Jon Peck instructed me on converting a string variable into numeric by means
of ALTER TYPE. This works fine but the data values still remains
left-aligned. I didn't know this was possible. I thought all numeric
variables were automatically right-aligned. How do I syntactically change
these left-aligned numeric variables into right-aligned?

best

Staffan Lindberg
Sweden


  _____

If you reply to this email, your message will be added to the discussion
below:
http://spssx-discussion.1045642.n5.nabble.com/Realigning-to-the-right-after-
altering-type-to-numeric-tp5723906p5723913.html
To start a new topic under SPSSX Discussion, email [hidden email]
To unsubscribe from SPSSX Discussion, click here.

<http://spssx-discussion.1045642.n5.nabble.com/template/NamlServlet.jtp?macr
o=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namesp
aces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web
.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml
-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.na
ml> NAML

Art Kendall
Social Research Consultants

  _____

View this message in context: Re: Realigning to the right after altering
type to numeric
<http://spssx-discussion.1045642.n5.nabble.com/Realigning-to-the-right-after
-altering-type-to-numeric-tp5723906p5723914.html>
Sent from the SPSSX Discussion mailing list archive
<http://spssx-discussion.1045642.n5.nabble.com/>  at Nabble.com.

---

If you reply to this email, your message will be added to the discussion below:

http://spssx-discussion.1045642.n5.nabble.com/Realigning-to-the-right-after-altering-type-to-numeric-tp5723906p5723916.html

To start a new topic under SPSSX Discussion, email [hidden email]
To unsubscribe from SPSSX Discussion, click here.
NAML