convert variable with year information into year variable

Accepted Solution Solved
Reply
Regular Contributor
Posts: 161
Accepted Solution

convert variable with year information into year variable

Dear All:

May I ask how to transform the following have table to the want table right below? 

HAVE table:

patienttcell_[year1]tcell_[year2]tcell_[year3]tcell_[year4]tcell_[year5]
A233421345435
C132213123345435
D13123123435123
E34312314325435345

WANT table:

patientyeartcell

A

123
A234
A3213
A445
A5435
C1132
C2213
C3123
D113
D2123
D3123

Accepted Solutions
Solution
‎06-17-2013 10:14 PM
Super User
Posts: 19,772

Re: convert variable with year information into year variable

Posted in reply to caveman529

All Replies
Solution
‎06-17-2013 10:14 PM
Super User
Posts: 19,772

Re: convert variable with year information into year variable

Posted in reply to caveman529
Regular Contributor
Posts: 161

Re: convert variable with year information into year variable

Thank you so much, this work!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 170 views
  • 0 likes
  • 2 in conversation