Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Recode Varialbe Values
Hi All:
I am wondering if it is possible to change the variable values. Suppose I have a variable Term which has value labels like, 1-Sep-99, 1-Feb-00, 1-Sep-00, 1-Feb-01, etc. Is there is any way I can recode recode 1-Sep-99 to Fall-99, 1-Feb-00 to Spr-00, etc. Suppose I don't want to do copy and paste to change these value labels and want to have some arguments to change the value labels for this variable Term. Thanks. Charles |
#2
|
|||
|
|||
No
really sure what you mean with 'recode'. What labels do you mean? -- Regards Frank Kabel Frankfurt, Germany "Charles" schrieb im Newsbeitrag ... Hi All: I am wondering if it is possible to change the variable values. Suppose I have a variable Term which has value labels like, 1-Sep-99, 1-Feb-00, 1-Sep-00, 1-Feb-01, etc. Is there is any way I can recode recode 1-Sep-99 to Fall-99, 1-Feb-00 to Spr-00, etc. Suppose I don't want to do copy and paste to change these value labels and want to have some arguments to change the value labels for this variable Term. Thanks. Charles |
#3
|
|||
|
|||
Hi Frank:
Thanks for your reply. I mean if we can change 1-Sep-00 to Fall-00 using some arguments rather than manually change it. Charles "Frank Kabel" wrote: No really sure what you mean with 'recode'. What labels do you mean? -- Regards Frank Kabel Frankfurt, Germany "Charles" schrieb im Newsbeitrag ... Hi All: I am wondering if it is possible to change the variable values. Suppose I have a variable Term which has value labels like, 1-Sep-99, 1-Feb-00, 1-Sep-00, 1-Feb-01, etc. Is there is any way I can recode recode 1-Sep-99 to Fall-99, 1-Feb-00 to Spr-00, etc. Suppose I don't want to do copy and paste to change these value labels and want to have some arguments to change the value labels for this variable Term. Thanks. Charles |
#4
|
|||
|
|||
Hi
you have to explain WHERe you use this. What you're trying to achieve. Do youn want a VBA solution?. If yes, post your current code -- Regards Frank Kabel Frankfurt, Germany "Charles" schrieb im Newsbeitrag ... Hi Frank: Thanks for your reply. I mean if we can change 1-Sep-00 to Fall-00 using some arguments rather than manually change it. Charles "Frank Kabel" wrote: No really sure what you mean with 'recode'. What labels do you mean? -- Regards Frank Kabel Frankfurt, Germany "Charles" schrieb im Newsbeitrag ... Hi All: I am wondering if it is possible to change the variable values. Suppose I have a variable Term which has value labels like, 1-Sep-99, 1-Feb-00, 1-Sep-00, 1-Feb-01, etc. Is there is any way I can recode recode 1-Sep-99 to Fall-99, 1-Feb-00 to Spr-00, etc. Suppose I don't want to do copy and paste to change these value labels and want to have some arguments to change the value labels for this variable Term. Thanks. Charles |
#5
|
|||
|
|||
How about using a helper cell with a formula like:
=CHOOSE(1+INT(B1/3)-4*(MONTH(A1)=12),"Winter","Spring","Summer","Fall" ) &"-"&TEXT(A1,"yy") (all one cell) But Dec-04, Jan-05, Feb-05 will look like: Winter-04, Winter-05, Winter-05 Is that ok? If Dec-04 should show as Winter-2005, then try this: =CHOOSE(1+INT(B12/3)-4*(MONTH(A12)=12),"Winter","Spring","Summer","Fall ") &"-"&TEXT(DATE(YEAR(A12)+(MONTH(A12)=12),1,1),"yy ") (still all one cell) Charles wrote: Hi Frank: Thanks for your reply. I mean if we can change 1-Sep-00 to Fall-00 using some arguments rather than manually change it. Charles "Frank Kabel" wrote: No really sure what you mean with 'recode'. What labels do you mean? -- Regards Frank Kabel Frankfurt, Germany "Charles" schrieb im Newsbeitrag ... Hi All: I am wondering if it is possible to change the variable values. Suppose I have a variable Term which has value labels like, 1-Sep-99, 1-Feb-00, 1-Sep-00, 1-Feb-01, etc. Is there is any way I can recode recode 1-Sep-99 to Fall-99, 1-Feb-00 to Spr-00, etc. Suppose I don't want to do copy and paste to change these value labels and want to have some arguments to change the value labels for this variable Term. Thanks. Charles -- Dave Peterson |
#6
|
|||
|
|||
Thank you very much, Frank and Dave. I will check this method later. I have
been very busy with another project and will get back to you. Charles "Charles" wrote: Hi All: I am wondering if it is possible to change the variable values. Suppose I have a variable Term which has value labels like, 1-Sep-99, 1-Feb-00, 1-Sep-00, 1-Feb-01, etc. Is there is any way I can recode recode 1-Sep-99 to Fall-99, 1-Feb-00 to Spr-00, etc. Suppose I don't want to do copy and paste to change these value labels and want to have some arguments to change the value labels for this variable Term. Thanks. Charles |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
Multiple X-Axis Values | Charts and Charting in Excel | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Missing values in Excel Line Chart | Charts and Charting in Excel | |||
linked values in a chart | Charts and Charting in Excel |