Reshape wide to long with string

[Minjae Kim]

Hello,

I am struggling to reshape a data set and I think this is because I have letters as identifiers as opposed to numeric values.
The data is organized in form below and the command that I've tried is variations of :

reshape long NPL_*, i(quarterly) j(NPL_)


quarterly NPL_TD NPL_RBC NPL_BMO NPL_BNS NPL_NBC NPL_CIBC
2000q1 0 1614 0 0 44 0
2000q2 0 1672 1189 0 44 1600
2000q3 0 1737 1334 0 45 1800
2000q4 989 0 1501 1239 0 1648
2001q1 0 1736 1702 0 54 1600
2001q2 0 0 1653 696 78 2080
2001q3 0 2193 1836 395 82 2070
2001q4 1267 2428 2014 4464 970 1702
2002q1 0 2713 2193 670 568 2070
2002q2 0 2529 2150 777 670 2150
2002q3 0 2371 2057 656 640 2290
2002q4 2525 2256 2337 3988 503 2275
2003q1 0 2374 2282 559 460 2300
2003q2 0 2163 2312 1853 467 2070
2003q3 0 1899 2043 317 470 1890
2003q4 1371 1711 1918 3241 476 1376


However, I get an error message "no xij variables found".
Could anyone kindly help me resolve this issue?

Thank you!
Minjae

[Nick Cox]

Look at the help for reshape long to see that it wants stubnames, not variable names. Consider

reshape long NPL_, i(quarterly) j(panel) string

[Minjae Kim]

Thank you! I should've done what stubnames are. I managed to reshape the data into long format. Thank you for your help again.