Hi,   I have imported a data set from excel(.xlsx) to SAS and have to output part of the data back to excel again. I found that the apostrophe (') will be translated to ' in excel(.xlsx). Any recommendations on the issue?   Thank you. Ying ... View more

Hi, I have a data set (OBS to COL7) listed below and have problem to generate transition and comments through calculating the up and down trend from COL1 to COL7. Any recommendations on programming? Obs COL1 COL2 COL3 COL4 COL5 COL6 COL7 transition comment 44 up down           1 Transitionaing 45 down up           1 Transitionaing 46 up up           2 all the way up 47 down up down up       1 Transitionaing 48 down down           3 all the way down 51 up down up down       1 Transitionaing 68 up                 69 down down               70 down up down             71 down                 72 down                 73 down down               Thanks. Ying ... View more

Hi, I generate a column of id (its variable name is c) from data set one (discrepancy_2016_2) and try to put it for data set two as IF/THEN criteria. Here is my example of code but it doesn’t work. Please advise.    PROC SQL NOPRINT; SELECT c INTO : cList FROM discrepancy_2016_2  ; QUIT ;     data discrepancy_2016_last_2; set discrepancies_20jun17; IF case_no in "compress(&clist)"; run;   Thank you. ... View more

Hi, I have a data set to deduplicate, I have problem summarizing a complete deduplicating rules, but here’s a few records from it with how to deduplicate. If any value of status1_date, status1, status2, status3, or status4 are different under the same ID, then all records should be kept. For ID 1, rec_no 2 should be kept, because if all variable values under the same ID are the same, then we don’t keep the “NA” result. For ID 2, rec_no 4 should be kept, because Result_date2 should be later then status_date. For ID 3, rec_no 5 and 6 should be kept because status 2 are different. For ID 4, rec_no 7 and 8 should be kept, because status 2 are different. For ID 5, no need to dedup. For ID 6, keep rec_no 10 and 11, because status 2 are different. rec_no ID status1_date status1 status2 status3 status4 Result_date1 Result_date2 Result To keep 1 1 10/22/2013 1 7 No 7 25-Oct-13 25-Oct-13 NA   2 1 10/22/2013 1 7 No 7 25-Oct-13 25-Oct-13 A1 x 3 2 2/25/2014 1 7 Unknown 0 27-Feb-14 15-Jan-14 NA   4 2 2/25/2014 1 7 Unknown 0 27-Feb-14 27-Feb-14 A1 x 5 3 2/25/2014 1 0 Unknown 0 25-Feb-14 15-Jan-14 NA x 6 3 2/25/2014 1 7 Unknown 0 25-Feb-14 27-Feb-14 A1 x 7 4 5/14/2014 5 0 No 0     NA x 8 4 5/14/2014 5 7 No 0     NA x 9 5 11/20/2013 5 7 No 1     NA x 10 6 5/14/2014 5 0 No 0     A1 x 11 6 5/14/2014 5 7 No 0     A1 x   Thank you. ... View more