Hi,
So I have browsed the forum, but could not find any solution to my problem so I hope that you guys can help me(:
I need to append two datasets and use the command append using... But i get the error message that "variable startdate is str19 in master but double in using data". Startdate is the variable that makes the problems
In the main data-file the variable startdate is string; type: str19, format: %19s
in the file i want to append to my main file startdate is; type: double, format: %tcdd-Mon-CCYY_HH:MM:SS
In my main file the variable startdate is string and is structured the following way when looking in the data editor
2019-10-08 15:17:16
2019-12-09 18:02:42
2019-10-01 09:19:40
2019-10-01 08:46:35
2019-10-01 14:43:02
2019-10-01 15:18:03
2019-10-07 08:03:57
2019-10-07 15:58:58
2019-10-08 08:30:31
2019-10-08 08:33:16
2019-10-08 09:13:11
2019-10-08 10:38:38
I have tried in a various of ways to make one varyable string or the other double, but cannot get it right.
Any help is highly appreciated,
Thanks!
Related Posts with Help with appending files with same variable in two formats (tostring/destring)
User-written machine learning add onsHello list users I'm trying to determine if any user-written programs exist for Stata and the follow…
rewriting the codeI would like to calculate relative_all forecast accuracy and I intend to use the following code. How…
How to assign row number in a dataset to a new variable SHROUT RETX sprtrn event_date event_window 2516605 0.00555951 0.00027547 -10 . 2516605 -0.005…
Tricky wide to long conversionDear Statalist users I need help turning a wide file into a long file, however, I'm having some dif…
How to generate a new variable that takes only the variable name of the other variable and not the value labelDear All Is there a way where we can generate a new variable from an existing numeric variable with…
Subscribe to:
Post Comments (Atom)
0 Response to Help with appending files with same variable in two formats (tostring/destring)
Post a Comment