Hi Kurt, Thanks for getting back to me, heres a sample of the dataset: DATA final_master_sample;
infile datalines dsd truncover;
INPUT PARTICIPANT DATETIME APP_1 APP_2 APP_3 APP_4 APP_5 ;
DATALINES;
1,1615939200,21,1,96,3,94
1,1615939501,64,23,97,7,11
1,1615939802,58,42,42,50,93
1,1615940103,77,74,82,21,44
1,1615940404,46,47,42,32,96
1,1615940705,45,55,7,42,71
1,1615941006,49,41,21,100,39
1,1615941307,82,85,46,86,5
1,1615941608,11,33,86,40,43
1,1615941909,19,21,84,3,29
1,1615942210,45,100,11,55,49
1,1615942511,58,67,13,15,47
1,1615942812,47,56,55,13,50
1,1615943113,76,14,3,10,41
1,1615943414,27,56,31,79,17
1,1615943715,32,85,94,40,23
1,1615944016,84,23,80,94,36
1,1615944317,37,13,17,49,54
1,1615944618,45,78,45,78,96
1,1615944919,2,43,24,55,57
1,1615945220,37,70,3,61,10
1,1615945521,78,95,33,30,6
1,1615945822,94,18,58,86,73
1,1615946123,79,70,94,32,8
1,1615946424,40,95,4,60,50
1,1615946725,98,8,54,55,44
1,1615947026,32,54,4,89,47
1,1615947327,17,5,31,80,39
1,1615947628,18,52,84,32,62
1,1615947929,59,27,2,45,50
1,1615948230,17,55,100,74,6
1,1615948531,18,84,9,8,14
1,1615948832,5,34,63,96,75
1,1615949133,66,71,18,50,70
1,1615949434,4,16,76,53,93
1,1615949735,3,58,30,27,5
1,1615950036,49,50,28,78,44
1,1615950337,68,66,58,13,7
;
run; I had a feeling it would be something to do with memory, is there a way to execute the macro without loading it in every time? The rest of the data has this structure, with (roughly) 5 minute intervals between each row, some are missing however. Thanks!
... View more