It seems that variable cnt is a vestige. It is a counter that was not fully enacted. To make it work, for example, by counting the number of outputted observations with datemount > “202221”, you would need to put it in a do-loop like instead of “then output” write …then do; Output; Cnt + 1; End; The top condition would make more sense with cnt = 0, or the counter will show one more observation. ... View more

1) extract constant parts into variables E.g., if find (string, “Mobile”) then city = Mobile; 2) group by those constant variables* *ideally take those constant parts out of the strings, e.g., using COMPRESS, just keep them in variables 3) create variable “length” with length of each string 4) sort by length descending and chose the longest string in each group (first.length) as your “standard” 5) compare strings in each group to its “standard” e.g., using COMPGED function* There are other functions that can compare two strings in SAS, COMPLEV, etc, for fuzzy matching 6) the function will return distance scores 7) addresses within reasonable distance of the standard are the same What is reasonable distance? You will have to find out experimentally - e.g., take one with score of 100 and see if it seems the same. ... View more

This program accrues work hours? It takes the date stamps from the log for start and finish and checks if positive hours can be computed. It also checks date time when they were posted and how that compares to start and finish. ... View more

You mean without the grid lines? There are various styles you can use. Please check out this gallery: https://sassavvy.com/proc_report_gallery.html/ ... View more

Here is some related information: https://documentation.sas.com/doc/en/etlug/4.905/p040fn3sixu7vqn1usa7uiai1m2d.htm ... View more

You would need two transfers 1) DEV to SAS, and 2) SAS to PROD. The principle how to load Oracle tables into SAS and vice versa can be found here: https://communities.sas.com/t5/New-SAS-User/Copy-datasets-from-Oracle-to-SAS/td-p/539311. It involves pointing a SAS library to an Oracle database so they can “talk” (i.e., transfer tables) back and forth. You can even modify table in SAS then transfer to Oracle, but you are saying here just to copy. ... View more

That is because of overfitting. It is usually one or two of them that have a lot of categories. Like @SAS_Rob said, you can try adding them back one-by-one and leave out the trouble-makers. ... View more

Keep going: Select unique(name) into :a_names separated by “ “ From dataset Group by group Having group = “A” ; If you want this to be dynamic, then 1) select unique(group) Into &groups separated by “ “ ; 2) iterate over &groups like so: https://blogs.sas.com/content/sastraining/2015/01/30/sas-authors-tip-getting-the-macro-language-to-perform-a-do-loop-over-a-list-of-values/ ... View more

data want; informat A DDMMYYD. ; input A; format A date9.; cards; 09-30-21 run; https://support.sas.com/resources/papers/proceedings/proceedings/sugi24/Coders/p073-24.pdf ... View more

If 09-30-21 is not a sting but a SAS date in DDMMYYD. format, you can just apply date9. format to get 30Sep2021: https://support.sas.com/documentation/cdl/en/lrcon/65287/HTML/default/viewer.htm#p1wj0wt2ebe2a0n1lv4lem9hdc0v.htm ... View more

N_OnHand is how many items you have in stock. Ships is how many times you need to ship them. You also have stopship_dt when to stop shipping (e.g., milk spoils or something). The while clause says while you have items on hand and they are being ordered do this: Scenario 1: if the order date is before stop-ship date, then subtract items ordered from number on hand because everything is ok and you can go ahead and ship them. Scenario 2: The second if clause is for when they ordered more than you have, so on-hand is zero and you are also a little in debt (so there are some remaining ships). Scenario 3: The third if scenario is fair - they ordered as many items as you have, so no more items and no more orders. ... View more

Would the warning go away if you comment out the covar statement? ... View more

Thank you, @WarrenKuhfeld! The text string does not need quotation marks. Third argument in quotes lists delimiters. x = scan( text, 2, '(),' ); y = scan( text, 3, '(),' ); ... View more

They are already a SAS date. You can just format admdate date9., and that should change the display. ... View more