A follow-up to: https://communities.sas.com/t5/SAS-Programming/let-list-quot-X-quot-gt-Literal-Contains-Unmatched-Quote/td-p/585064   The arrays (not_done_list, col_list, query_list, sas_check) are all aligned so that the same indexed value corresponds with each other.     %let not_done_list = SODIUMND | SODIUMND; /*column names (ND=NOT DONE) */ %let col_list = SODIUM | SODIUM ; /*column names */ /* query_list and sas_check are just strings in array, not column names */ %let query_list= 'querytext1' | 'querytext2' ; %let sas_check = "CHEM005" | "CHEM006"; %macro create_table(not_done_list, col_list, query_list, sas_check); proc sql noprint; CREATE TABLE t1 AS SELECT DISTINCT %str(&query_list) as query_text, %str(&sas_check) as SAS_Check, Subject, %str(&not_done_list) as not_done_list, %str(&col_list) as col_list FROM chem GROUP BY Subject HAVING ((put(&col_list, best.)^="" or put(&col_list, best.)="No") and not_done_list IS NOT NULL) OR ((put(col_list, best.)="" or put(&col_list, best.)="Yes") and not_done_list IS NOT NULL) ; quit; %mend create_table; %macro prep_table(notdone, col, query, sas_check ); %local item; %do item=1 %to %sysfunc(countw(&not_done_list)); %let notdone=%scan(&not_done_list,&item); %let col=%scan(&col_list,&item); %let query=%scan(&query_list,&item, |); %let sas=%scan(&sas_check,&item, |); %create_table(not_done_list=&notdone, col_list=&col, query_list=&query, sas_check=&sas); %end; %mend prep_table; %prep_table(notdone=&not_done_list, col=&col_list, query=&query_list, sas_check=&sas_check );   Example Input: ╔═════════╦══════════╦════════╗ ║ Subject ║ SODIUMND ║ SODIUM ║ ╠═════════╬══════════╬════════╣ ║ 001 ║ No ║ ║ ║ 001 ║ Yes ║ ║ ║ 002 ║ Yes ║ 221 ║ ║ 002 ║ No ║ ║ ╚═════════╩══════════╩════════╝   No error log, but (not expected) Output: ╔════════════╦═══════════╦═════════╦═══════════════╦══════════╗ ║ query_text ║ SAS_Check ║ Subject ║ not_done_list ║ col_list ║ ╠════════════╬═══════════╬═════════╬═══════════════╬══════════╣ ║ querytext1 ║ CHEM005 ║ 001 ║ No ║ ║ ║ querytext1 ║ CHEM005 ║ 002 ║ Yes ║ 221 ║ ║ querytext1 ║ CHEM005 ║ 002 ║ No ║ ║ ╚════════════╩═══════════╩═════════╩═══════════════╩══════════╝ What's wrong: 1. Only querytext1 is outputted (there is dirty data for querytext2, but no output). 2. SAS_Check isn't right, it should be the corresponding SAS_Check via the same index in all the arrays.  3. not_done_list and col_list should be the value as a string       Expected output: ╔════════════╦═══════════╦═════════╦══════════╦════════╗ ║ query_text ║ SAS_Check ║ Subject ║ SODIUMND ║ SODIUM ║ ╠════════════╬═══════════╬═════════╬══════════╬════════╣ ║ querytext1 ║ CHEM005 ║ 001 ║ No ║ ║ ║ querytext1 ║ CHEM005 ║ 002 ║ Yes ║ 221 ║ ║ querytext2 ║ CHEM006 ║ 002 ║ No ║ ║ ╚════════════╩═══════════╩═════════╩══════════╩════════╝ So, if there's a third, different column name in not_done_list and col_list, then it would be like ╔════════════╦═══════════╦═════════╦══════════╦════════╦═════════╦═══════╗ ║ query_text ║ SAS_Check ║ Subject ║ SODIUMND ║ SODIUM ║ thirdND ║ third ║ ╠════════════╬═══════════╬═════════╬══════════╬════════╬═════════╬═══════╣ ║ querytext1 ║ CHEM005 ║ 001 ║ No ║ ║ ║ ║ ║ querytext1 ║ CHEM005 ║ 002 ║ Yes ║ 221 ║ ║ ║ ║ querytext2 ║ CHEM006 ║ 002 ║ No ║ ║ ║ ║ ╚════════════╩═══════════╩═════════╩══════════╩════════╩═════════╩═══════╝   I know this is a lot to ask, but I'm just stuck.   Thanks       ... View more

Hi, I'm getting a " Literal Contains Unmatched Quote" with my array/list, I think:     ERROR LOG:   ERROR: Literal contains unmatched quote. ERROR: The macro PREP_TABLE will stop executing. The lists: %let not_done_list = SALTND PEPPERND; %let col_list = SODIUM PEPPER; %let query_list= '"Not Done" is marked, however, the result of Passing is provided, please correct.' '"Not Done" is marked, however, the result of Passing is provided, please correct.';   I'm passing this list to a macro that iterates through this list being called through %prep_table(...):   %macro prep_table(notdone, col, query); %local item; %do item=1 %to %sysfunc(countw(&notdone)); %let notdone=%scan(&not_done_list,&item); %let col=%scan(&col_list,&item); %let query=%scan(&query_list,&item); %create_table(notdone=&notdone, col=&col, query=&query) %end; %mend prep_table; %prep_table(notdone=&not_done_list, col=&col_list, query=&query_list);   The %create_table thing: %macro create_table(notdone, col, query); proc sql noprint; CREATE TABLE t1 AS SELECT DISTINCT &query, Subject, &notdone, &col FROM chem GROUP BY Subject HAVING ((col^="" or col="No") and col2^="") OR ((col="" or col="Yes") and col2="") ; quit; %mend create_table;   I tried the thing here (https://stackoverflow.com/questions/5944628/unmatched-quotation-mark-issue-in-sas) but still same error %let query_list= %str(%"Not Done%" is marked, however, the result of Passing is provided, please correct.); How do I have list in SAS where each item also has quotes?   The structure of the code is based on the solution comment: https://communities.sas.com/t5/SAS-Enterprise-Guide/Macro-iteration-on-two-variables/td-p/393804   Thanks   EDIT: updated with more code   EDIT EDIT: Ok, thanks to the comments, I realized that my program has issues elsewhere as well. So, I'm currently sorting it out and seeing if I can fix. Thanks        ... View more

  So, I'm trying to output the data rows where given the same TimePoint, the difference Time1 between from the lowest time and the middle time as well as the middle time and the highest time should be greater than 2 minutes. For every given TimePoint, there will only be 3 Time1s.   Sample Input Data: ╔═════════╦══════════╦════════════╗ ║ Subject ║ Time1 ║ TimePoint ║ ╠═════════╬══════════╬════════════╣ ║ 1 ║ 11:13:10 ║ s1 ║ ║ 1 ║ 11:15:10 ║ s1 ║ ║ 1 ║ 11:17:30 ║ s1 ║ ║ 1 ║ 11:45 ║ s2 ║ ║ 1 ║ ║ s2 ║ ║ 1 ║ 11:50 ║ s2 ║ ╚═════════╩══════════╩════════════╝     Output Data: ╔═════════╦══════════╦════════════╗ ║ Subject ║ Time1 ║ TimePoint ║ ╠═════════╬══════════╬════════════╣ ║ 1 ║ 11:15:10 ║ s1 ║ ║ 1 ║ 11:17:30 ║ s1 ║ ║ 1 ║ 11:45 ║ s2 ║ ║ 1 ║ 11:50 ║ s2 ║ ╚═════════╩══════════╩════════════╝ Explanation:  Highest time - Middle time: 11:17:30 - 11:15:10 > 2 (should output) Middle time - Lowest time:  11:13 - 11:11 <= 2 minutes (should not output)   Highest time - Lowest time: 11:50 - 11:45 > 4min (should output) ^this means that whatever the middle time is, at least one of the interval is > 2min, so should output ---------------------------------------------------------------------------------------   I'm open to either proc sql/SAS advices, but I am more experienced in SQL but I can't think of a way for this. This would be a lot easier if it's just two Time1s. I do know of the INTCK function to get the time difference, but I'm stuck on getting it to apply in this manner.   I did a quick google search on this, including search queries like "sas sql get middle time between three 3 times" but nothing really relevant came up.       Thanks!   EDIT: Thinking about it now, I think the best way to approach this is to compile all three times onto one single row into their own column, along with the other data (subject and timepoint). Then I can just compare by doing like TimeONE - TimeTwo and so on with the columns.  Is there a better way than this? But now I'm kind of stuck on how to get each Time onto their own column:/   ╔═════════╦══════════╦══════════╦═══════════╦═══════════╗ ║ Subject ║ TimeONE ║ TimeTWO ║ TimeTHREE ║ TimePoint ║ ╠═════════╬══════════╬══════════╬═══════════╬═══════════╣ ║ 1 ║ 11:13:10 ║ 11:15:10 ║ 11:17:30 ║ s1 ║     ... View more