Good morning.   I'm looking for advice on how to find the difference between dates and time. The wrinkles are each date and time are in separate fields and the time is in 24-hour clock format. As you can see from the column ATTEMPT_1 I haven't been all that successful.    For the attempt I did try dhms(date_1, 0, 0, time_1) as attempt_1 format = datetime15. but obviously that did not work. If I could just get the date time conversion to work, I could then determine the number of hours between the two date-time variables.    What do you think? Is there an efficient way to do this?   PERSON DATE_1 TIME_1 DATE_2 TIME_2 ATTEMPT_1 100 5/7/2018 2222 5/9/2018 1008 07MAY18:00:37 100 5/9/2018 1009 5/15/2018 1430 09MAY18:00:16 101 9/13/2020 957 9/13/2020 1046 13SEP20:00:15 101 9/13/2020 1047 9/21/2020 1541 13SEP20:00:17 101 1/19/2023 2200 1/21/2023 1336 19JAN23:00:36 102 5/17/2012 2306 5/18/2012 1530 17MAY12:00:38 102 7/23/2012 2257 7/24/2012 945 23JUL12:00:37 102 12/5/2012 1749 12/6/2012 1503 05DEC12:00:29 103 11/9/2014 808 11/11/2014 1237 09NOV14:00:13 104 6/21/2008 1840 6/23/2008 1600 21JUN08:00:30 105 2/27/2015 1539 2/28/2015 630 27FEB15:00:25 105 2/28/2015 631 3/8/2015 1005 28FEB15:00:10 106 12/15/2020 1918 1/21/2021 1118 15DEC20:00:31 107 4/15/2013 1940 4/17/2013 1510 15APR13:00:32 108 6/6/2009 37 6/7/2009 928 06JUN09:00:00 109 12/15/2020 1918 12/24/2020 1530 15DEC20:00:31 110 1/26/2023 2254 1/30/2023 1445 26JAN23:00:37 111 3/21/2012 2212 3/22/2012 1439 21MAR12:00:36 111 4/18/2012 1630 4/23/2012 800 18APR12:00:27 112 4/16/2017 915 4/16/2017 1548 16APR17:00:15 112 4/16/2017 1548 4/19/2017 1700 16APR17:00:25 113 6/22/2016 255 6/22/2016 449 22JUN16:00:04 113 6/22/2016 508 6/28/2016 1525 22JUN16:00:08 114 8/19/2020 1352 8/20/2020 1150 19AUG20:00:22 115 9/25/2009 1621 10/7/2009 1430 25SEP09:00:27 ... View more

Good morning.    I am attempting to concatenate rows of data from multiple line onto one line. I can't see to get this work. I've deconstructed it to see if I can tell what's going on but I can't see to locate the error. What I end up with is a single line per ID_NUMBER with only the first comment. I don't get the subsequent concatenations for the same ID_NUMBER.    I'm sure there must be a better way to do this but I'm trying to understand how such a data step works.   HAVE       ID_NUMBER COMMENT_NUMBER COMMENT_SEQUENCE_NUMBER INCOMING_COMMENT 1 10 1 This person has four lines 1 10 2 on their comment. I would like all four 1 10 3 on the same line. 1 10 4 This is the final line for this comment. 1 15 1 Jack and Jill went up the 1 15 2 hill to fetch a pail 1 15 3 of water. 2 16 1 I wish the sky was purple 2 17 1 If the sky was purple can you 2 17 2 imagine the sunsets? 3 22 1 Sand paintings are the best. 3 22 2 You can always get a different 3 22 3 view by changing the orientation. 3 22 4 Just tip the picture and BAM! 3 22 5 You get a brand new landscape         WANT       ID_NUMBER COMMENT_NUMBER   INCOMING_COMMENT 1 10   This person has four lines on their comment. I would like all four on the same line. This is the final line for this comment. 1 15   Jack and Jill went up the hill to fetch a pail of water of water. 2 16   I wish the sky was purple 2 17   If the sky was purple can you imagine the sunsets? 2 22   Sand paintings are the best. You can always get a different view by changing the orientation. Just tip the picture and BAM! You get a brand new landscape Thanks very much if someone has the time to help out. data want (keep = id_number w_comment); set have (rename=(id_number = in_id_number comment_sequence_number = in_comment_sequence_number comment_line = in_comment)) end = eof_input; length w_comment $ 1000; retain id_number comment_sequence_number comment_line w_comment; /*Initialize the output (retained) columns and return to top of data step.*/ if _n_ = 1 then do; id_number = in_id_number; comment_sequence_number = in_comment_sequence_number; comment_line = in_comment; w_comment = in_comment; return; end; if id_number = in_id_number and comment_sequence_number = in_comment_sequence_number then do; w_comment = catx(", ", w_comment, in_comment); end; if in_id_number > id_number then do; output; id_number = in_id_number; comment_sequence_number = in_comment_sequence_number; comment_line = in_comment; w_comment = in_comment; return; end; /*At end of file on input file write out the last retained record of data.*/ if eof_input then output; run; ... View more

Hello!   I hope someone can point me in the right direction and I'm sure they can.   I'm attempting to generate an Excel file with data if data is available. If not, I simply want the same file name with no data but with text entered in cell A2 (or a blank Excel sheet with text in A1). The text should simply say "No records were found." I've figured out how to count the observations so I know if I'm at zero or non-zero and how to test for that. The Excel file generates correctly if there is data but the "No records were found." doesn't generate. I just get an error message that says the Excel can't open the file. I'm assuming this is because there's no data in it but I'm not sure of that.   I've inherited this code and now have to figure out how to make it work. I'd sure appreciate any help.   Thank you.   /*The first section is if there is data to report.*/ %macro which_report; %if "&count." > 0 %then %do; ods listing close; options missing = ' '; ods Excel file = "<<PATH>>" options (sheet_interval = 'none' sheet_interval = 'none' sheet_name = 'DATA'); proc report data = HAVE nowd style(REPORT) = {cellpadding = 5 background = #D0C7A8 font_size = 9pt} style(COLUMN) = {font_face = Arial background = white font_size = 9pt} style(HEADER) = {font_face = Arial foreground = black background = #EBE8DA font_size = 9pt}; column VARIOUS COLUMNS; run; ods Excel close; ods listing; %end; %else %do; /*This section is for when there is no data to report.*/ data _null_; file "<<PATH>>"; put "No records were found."; run; ods Excel close; ods listing; %end; %mend; %which_report; ... View more

Hello. Could someone help understand why I cannot get this very simple macro to execute? When I run it I do get the params data from that step but nothing within the macro executes. On the initial run I get no failure at all, just no execution. On all subsequent runs I get,   "The quoted string currently being processed has become more than 262 characters long. You might have unbalanced quotation marks."   This forces me to close SAS and reopen.    Thank you very much.     data params; attrib run_date length = 8 format = mmddyy10. begin_date length = 8 format = mmddyy10. ending_date length = 8 format = mmddyy10. rep_start_date length = $10 rep_end_date length = $10; run_date = today(); run_month = month(run_date); /* begin_date = intnx('semiyear',run_date,1,"BEGIN");*/ /* ending_date = intnx('semiyear',run_date,1,"END");*/ /* rep_start_date = put(begin_date, mmddyy10.);*/ /* rep_end_date = put(ending_date, mmddyy10.);*/ call symput("run_month",run_month); /* call symput("begin_date",begin_date);*/ /* call symput("ending_date",ending_date);*/ /* call symput("rep_start_date",rep_start_date);*/ /* call symput("rep_end_date",rep_end_date);*/ run; %macro run_code; %if %eval(&run_month. = 1 or &run_month. = 7) %then %do; data temp_01; test_var = 'This code actually ran.'; run; %end; %mend; %macro run_code;   ... View more

Good morning.    I'm using the attached code to document all tables in my code (thanks to others as I'd have never figured this out on my own). However, I'd like the result to be a bit cleaner. For instance, you can see that a number of entries contains the leading words SEQ and MULTI as well as the trailing words.DATA and .VIEW. I'd like to remove those before the Excel file creation. I've never used this type of code so I'd appreciate any help someone could give me.   proc scaproc; write; run; filename sca_rec "&documentation.\&documentation_name..txt"; filename sca_rec '<<SCAPROC TEXT FILE'; data myinfo; infile sca_rec truncover; input @1 scaline $256.; length type myinfo $100; keep type myinfo; retain prxifile prxidata; if _n_ = 1 then do; prxifile = prxparse("!\bJOBSPLIT: FILE INPUT SEQ (\b.*\b) \*/!"); prxidata = prxparse("!\bJOBSPLIT: DATASET INPUT (\b.*\b) \*/!"); end; if prxmatch (prxidata,scaline) > 0 then do; myinfo = prxposn(prxidata,1,scaline); type = 'Input File'; output myinfo; end; run; proc export data = myinfo outfile = '<<outfile path>>' /* putnames = no;*/ dbms = xls replace; run; ... View more