Hi all,

I am experiencing trouble converting my data from long to wide. Specifically, some distance values change into missing values once the data is converted from long to wide.
The variable inputid is a string containing the name of a train station, targetid is a string containing the name of a metro station and the distance variable is the distance between them. See below:

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str26 inputid str21 targetid float distance
"Den Haag Mariahoeve" "Den Haag Centraal"      3270.954
"Den Haag Mariahoeve" "Laan van NOI"          2260.3313
"Den Haag Mariahoeve" "Voorburg 't Loo"        994.2022
"Den Haag Mariahoeve" "Leidschendam-Voorburg" 1671.3826
"Den Haag Mariahoeve" "Forepark"               2805.655
"Den Haag Mariahoeve" "Leidschenveen"          3574.066
"Den Haag Mariahoeve" "Nootdorp"               5715.811
"Den Haag Mariahoeve" "Pijnacker Centrum"      9106.829
"Den Haag Mariahoeve" "Pijnacker Zuid"        10901.992
"Den Haag Mariahoeve" "Berkel Westpolder"     12627.426
"Den Haag Mariahoeve" "Rodenrijs"             14256.983
"Den Haag Mariahoeve" "Meijersplein"          16319.845
"Den Haag Mariahoeve" "Melanchtonweg"         17125.008
"Voorburg"            "Den Haag Centraal"      2878.122
"Voorburg"            "Laan van NOI"          1809.6858
"Voorburg"            "Voorburg 't Loo"       1788.1842
"Voorburg"            "Leidschendam-Voorburg" 1947.7887
"Voorburg"            "Forepark"               2287.896
"Voorburg"            "Leidschenveen"          2774.256
"Voorburg"            "Nootdorp"              4305.2324
"Voorburg"            "Pijnacker Centrum"      7377.844
"Voorburg"            "Pijnacker Zuid"         9045.772
"Voorburg"            "Berkel Westpolder"     10691.874
"Voorburg"            "Rodenrijs"             12249.353
"Voorburg"            "Meijersplein"           14186.69
"Voorburg"            "Melanchtonweg"         14968.638
"Zoetermeer Oost"     "Den Haag Centraal"     12223.956
"Zoetermeer Oost"     "Laan van NOI"          10988.954
"Zoetermeer Oost"     "Voorburg 't Loo"        9639.177
"Zoetermeer Oost"     "Leidschendam-Voorburg"  8466.716
"Zoetermeer Oost"     "Forepark"               7432.588
"Zoetermeer Oost"     "Leidschenveen"          6756.526
"Zoetermeer Oost"     "Nootdorp"               5447.995
"Zoetermeer Oost"     "Pijnacker Centrum"      4861.727
"Zoetermeer Oost"     "Pijnacker Zuid"          5679.61
"Zoetermeer Oost"     "Berkel Westpolder"      6826.687
"Zoetermeer Oost"     "Rodenrijs"              8187.242
"Zoetermeer Oost"     "Meijersplein"          10314.964
"Zoetermeer Oost"     "Melanchtonweg"         11071.383
"Rotterdam Alexander" "Voorburg 't Loo"       19380.242
"Rotterdam Alexander" "Leidschendam-Voorburg" 18315.063
"Rotterdam Alexander" "Forepark"              17166.844
"Rotterdam Alexander" "Leidschenveen"         16394.117
"Rotterdam Alexander" "Nootdorp"              14296.662
"Rotterdam Alexander" "Pijnacker Centrum"     11044.306
"Rotterdam Alexander" "Pijnacker Zuid"         9458.007
"Rotterdam Alexander" "Berkel Westpolder"      8029.334
"Rotterdam Alexander" "Rodenrijs"              6899.683
"Rotterdam Alexander" "Meijersplein"           6283.415
"Rotterdam Alexander" "Melanchtonweg"          6116.705
"Rotterdam Alexander" "Blijdorp "              6959.911
"Rotterdam Alexander" "Rotterdam Centraal"     6565.827
"Delft"               "Den Haag Centraal"      8540.293
"Delft"               "Laan van NOI"           8111.881
"Delft"               "Voorburg 't Loo"        8433.163
"Delft"               "Leidschendam-Voorburg"  8102.998
"Delft"               "Forepark"                 7478.3
"Delft"               "Leidschenveen"          7133.186
"Delft"               "Nootdorp"               6042.332
"Delft"               "Pijnacker Centrum"      5701.481
"Delft"               "Pijnacker Zuid"         6092.941
"Delft"               "Berkel Westpolder"      6921.683
"Delft"               "Rodenrijs"              7900.833
"Delft"               "Meijersplein"           9168.331
"Delft"               "Melanchtonweg"          9807.453
"Delft Zuid"          "Laan van NOI"           9902.534
"Delft Zuid"          "Voorburg 't Loo"       10146.544
"Delft Zuid"          "Leidschendam-Voorburg"  9731.183
"Delft Zuid"          "Forepark"               9010.215
"Delft Zuid"          "Leidschenveen"          8579.103
"Delft Zuid"          "Nootdorp"               7179.103
"Delft Zuid"          "Pijnacker Centrum"      5949.607
"Delft Zuid"          "Pijnacker Zuid"         5779.691
"Delft Zuid"          "Berkel Westpolder"      6154.335
"Delft Zuid"          "Rodenrijs"              6809.305
"Delft Zuid"          "Meijersplein"            7758.27
"Delft Zuid"          "Melanchtonweg"          8328.034
"Delft Zuid"          "Blijdorp "               9289.83
"Den Haag HS"         "Den Haag Centraal"      1225.402
"Den Haag HS"         "Laan van NOI"          1722.0498
"Den Haag HS"         "Voorburg 't Loo"        3285.588
"Den Haag HS"         "Leidschendam-Voorburg" 4147.3394
"Den Haag HS"         "Forepark"              4812.0444
"Den Haag HS"         "Leidschenveen"          5353.723
"Den Haag HS"         "Nootdorp"               6777.577
"Den Haag HS"         "Pijnacker Centrum"      9585.514
"Den Haag HS"         "Pijnacker Zuid"        11116.615
"Den Haag HS"         "Berkel Westpolder"     12658.647
"Den Haag HS"         "Rodenrijs"             14120.048
"Den Haag HS"         "Meijersplein"           15896.79
"Den Haag HS"         "Melanchtonweg"         16640.906
"Boskoop"             "Laan van NOI"           20834.04
"Boskoop"             "Voorburg 't Loo"       19244.713
"Boskoop"             "Leidschendam-Voorburg" 18170.283
"Boskoop"             "Forepark"              17427.883
"Boskoop"             "Leidschenveen"          16952.33
"Boskoop"             "Nootdorp"               16248.37
"Boskoop"             "Pijnacker Centrum"     15709.694
"Boskoop"             "Pijnacker Zuid"        15962.984
"Boskoop"             "Berkel Westpolder"     16380.026
end

For example, Leidschendam-Voorburg will not be supported as a variable name in the wide format by Stata so I used:

Code:
replace targetid = strtoname(targetid)
Then to convert the data shape:

Code:
reshape wide distance, i(inputid) j(targetid) string
Now when I open my data viewer, for example I find that for some inputid's distance_to_Den_Haag_Centraal is converted into "." same goes for some other distance variables.
I checked beforehand if any distance values in the long format are missing, this is not the case.

Hope my question is clear.
Thank you in advance!