I am converting it to a panel using the following code:
Code:
reshape long var, i(date)
variable _j contains all missing values
r(498);
Here is the data sample:
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input int date double(var1HK0000040383 var2HK0000050325) byte var3KR7000010009 double(var4KR7000020008 var5KR7000030007 var6KR7000040006) 16072 0 0 0 5243.082 11930.294 532.714 16075 0 0 0 5243.082 11930.294 532.714 16076 0 0 0 5243.082 11930.294 532.714 16077 0 0 0 5243.082 11930.294 532.714 16078 0 0 0 5243.082 11930.294 532.714 16079 0 0 0 5243.082 11930.294 532.714 16082 0 0 0 5243.082 11930.294 532.714 16083 0 0 0 5243.082 11930.294 532.714 16084 0 0 0 5243.082 11930.294 532.714 16085 0 0 0 5243.082 11930.294 532.714 16086 0 0 0 5243.082 11930.294 532.714 16089 0 0 0 5243.082 11930.294 532.714 16090 0 0 0 5243.082 11930.294 532.714 16091 0 0 0 5243.082 11930.294 532.714 16092 0 0 0 5243.082 11930.294 532.714 16093 0 0 0 5243.082 11930.294 532.714 16096 0 0 0 5243.082 11930.294 532.714 16097 0 0 0 5243.082 11930.294 532.714 end format %tdnn/dd/CCYY date
Thank you.
0 Response to Reshape Long Missing Values Error
Post a Comment