One variable (device_scan) in my dataset is very long. I would like to create multiple variables using responses in this long variable. See below example,   Obs            device_scan        1        {"screenW":1098,"screenH":618,"touch":true,"OS":"Windows","UTCoffset":300}        2       {"screenW":1024,"screenH":768,"touch":true,"OS":"MacOS","UTCoffset":240}        3       {"screenW":1536,"screenH":864,"touch":true,"OS":"Windows","UTCoffset":300}        4       {"screenW":1280,"screenH":1024,"touch":false,"OS":"Windows","UTCoffset":240}        5       {"screenW":1080,"screenH":810,"touch":true,"OS":"MacOS","UTCoffset":300}   I would like to create 4 variables using the "device_scan" row: Device_width (corresponds to response of "screenW":) Device_height (corresponds to response of "screenH":) Touch (corresponds to response of "touch":) Device_OS (corresponds to response of "OS":) Thank you! ... View more

Hi,   I have 8 observations per subject ID. All subjects were asked to complete 8 tasks (i.e., 8 observations) in the same session, i.e., each ID should have an identical session time. However, in my dataset, for ID #5, 2 observations had the same session time, and 6 observations had the same session time. Therefore, I would like to exclude ID#5 from this example dataset. I have multiple IDs in my extended dataset. I would appreciate if someone could provide an example code to remove IDs with different session times.   Example dataset:   ID SessionTime v1 v2 v3 1 18.2 2 3 6 1 18.2 3 7 8 1 18.2 4 6 12 1 18.2 6 8 10 1 18.2 8 9 22 1 18.2 9 10 25 1 18.2 10 12 30 1 16.7 12 17 4 2 16.7 3 7 6 2 16.7 4 11 10 2 16.7 5 10 8 2 16.7 7 12 20 2 16.7 9 13 23 2 16.7 10 14 28 2 16.7 11 16 2 2 16.7 13 21 4 3 18.2 4 11 8 3 18.2 5 15 6 3 18.2 6 14 18 3 18.2 8 16 21 3 18.2 10 17 26 3 18.2 11 18 0 3 18.2 12 20 2 3 18.2 14 25 6 4 19.3 5 15 4 4 19.3 6 19 16 4 19.3 7 18 19 4 19.3 9 20 24 4 19.3 11 21 7 4 19.3 12 22 0 4 19.3 13 24 4 4 19.3 15 29 2 5 20.3 6 19 14 5 20.3 7 23 17 5 28.4 8 22 22 5 28.4 10 24 5 5 28.4 12 25 5 5 28.4 13 26 2 5 28.4 14 28 0 5 28.4 16 33 12   Thank you ... View more