I have some data from Google trends that I'd like to maybe work with, following this interesting story. Consider an excerpt
Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input str24 v1 str47 searchrate str20 state float id
"2023-04-28T18" "15"  "Alabama" 1
"2023-04-28T19" "12"  "Alabama" 1
"2023-04-28T20" "8"   "Alabama" 1
"2023-04-28T21" "15"  "Alabama" 1
"2023-04-28T22" "10"  "Alabama" 1
"2023-04-28T23" "21"  "Alabama" 1
"2023-04-29T00" "50"  "Alabama" 1
"2023-04-29T01" "18"  "Alabama" 1
"2023-04-29T02" "28"  "Alabama" 1
"2023-04-29T03" "0"   "Alabama" 1
"2023-04-29T04" "30"  "Alabama" 1
"2023-04-29T05" "72"  "Alabama" 1
"2023-04-29T06" "37"  "Alabama" 1
"2023-04-29T07" "21"  "Alabama" 1
"2023-04-29T08" "6"   "Alabama" 1
"2023-04-29T09" "18"  "Alabama" 1
"2023-04-29T10" "12"  "Alabama" 1
"2023-04-29T11" "16"  "Alabama" 1
"2023-04-29T12" "6"   "Alabama" 1
"2023-04-29T13" "14"  "Alabama" 1
"2023-04-29T14" "11"  "Alabama" 1
"2023-04-29T15" "16"  "Alabama" 1
"2023-04-29T16" "21"  "Alabama" 1
"2023-04-29T17" "23"  "Alabama" 1
"2023-04-29T18" "13"  "Alabama" 1
"2023-04-29T19" "10"  "Alabama" 1
"2023-04-29T20" "10"  "Alabama" 1
"2023-04-29T21" "13"  "Alabama" 1
"2023-04-29T22" "13"  "Alabama" 1
"2023-04-29T23" "16"  "Alabama" 1
"2023-04-30T00" "18"  "Alabama" 1
"2023-04-30T01" "23"  "Alabama" 1
"2023-04-30T02" "27"  "Alabama" 1
"2023-04-30T03" "34"  "Alabama" 1
"2023-04-30T04" "35"  "Alabama" 1
"2023-04-30T05" "0"   "Alabama" 1
"2023-04-30T06" "0"   "Alabama" 1
"2023-04-30T07" "26"  "Alabama" 1
"2023-04-30T08" "19"  "Alabama" 1
"2023-04-30T09" "18"  "Alabama" 1
"2023-04-30T10" "6"   "Alabama" 1
"2023-04-30T11" "23"  "Alabama" 1
"2023-04-30T12" "19"  "Alabama" 1
"2023-04-30T13" "11"  "Alabama" 1
"2023-04-30T14" "11"  "Alabama" 1
"2023-04-30T15" "14"  "Alabama" 1
"2023-04-30T16" "0"   "Alabama" 1
"2023-04-30T17" "12"  "Alabama" 1
"2023-04-30T18" "9"   "Alabama" 1
"2023-04-30T19" "13"  "Alabama" 1
"2023-04-30T20" "16"  "Alabama" 1
"2023-04-30T21" "21"  "Alabama" 1
"2023-04-30T22" "20"  "Alabama" 1
"2023-04-30T23" "18"  "Alabama" 1
"2023-05-01T00" "20"  "Alabama" 1
"2023-05-01T01" "27"  "Alabama" 1
"2023-05-01T02" "20"  "Alabama" 1
"2023-05-01T03" "0"   "Alabama" 1
"2023-05-01T04" "62"  "Alabama" 1
"2023-05-01T05" "0"   "Alabama" 1
"2023-05-01T06" "0"   "Alabama" 1
"2023-05-01T07" "11"  "Alabama" 1
"2023-05-01T08" "31"  "Alabama" 1
"2023-05-01T09" "28"  "Alabama" 1
"2023-05-01T10" "17"  "Alabama" 1
"2023-05-01T11" "21"  "Alabama" 1
"2023-05-01T12" "17"  "Alabama" 1
"2023-05-01T13" "22"  "Alabama" 1
"2023-05-01T14" "17"  "Alabama" 1
"2023-05-01T15" "15"  "Alabama" 1
"2023-05-01T16" "11"  "Alabama" 1
"2023-05-01T17" "15"  "Alabama" 1
"2023-05-01T18" "17"  "Alabama" 1
"2023-05-01T19" "21"  "Alabama" 1
"2023-05-01T20" "12"  "Alabama" 1
"2023-05-01T21" "9"   "Alabama" 1
"2023-05-01T22" "13"  "Alabama" 1
"2023-05-01T23" "13"  "Alabama" 1
"2023-05-02T00" "16"  "Alabama" 1
"2023-05-02T01" "45"  "Alabama" 1
"2023-05-02T02" "28"  "Alabama" 1
"2023-05-02T03" "22"  "Alabama" 1
"2023-05-02T04" "18"  "Alabama" 1
"2023-05-02T05" "100" "Alabama" 1
"2023-05-02T06" "22"  "Alabama" 1
"2023-05-02T07" "22"  "Alabama" 1
"2023-05-02T08" "25"  "Alabama" 1
"2023-05-02T09" "18"  "Alabama" 1
"2023-05-02T10" "34"  "Alabama" 1
"2023-05-02T11" "17"  "Alabama" 1
"2023-05-02T12" "18"  "Alabama" 1
"2023-05-02T13" "20"  "Alabama" 1
"2023-05-02T14" "17"  "Alabama" 1
"2023-05-02T15" "9"   "Alabama" 1
"2023-05-02T16" "14"  "Alabama" 1
"2023-05-02T17" "14"  "Alabama" 1
"2023-05-02T18" "17"  "Alabama" 1
"2023-05-02T19" "15"  "Alabama" 1
"2023-05-02T20" "14"  "Alabama" 1
"2023-05-02T21" "12"  "Alabama" 1
end

generate double time = clock(v1, "20YMDh")
I wanna generate a time variable, with something like 01may202312pm. for all the states of interest, but at the moment Stata generates them as missing. How might I do this, I've never seen this kind of date before?