I need help on comparing two macro variable dates. Below is the code. You can see by the log that MINDT_AS_DATE_MINUS_ONE_DT1 is 23JUL2012 and TESTDT1 is 01JAN2013. However, when comparing SAS says 23JUL2012 <01JAN2013. is FALSE. I am very confused. Thanks Removed Not working in LOG, See: Removed ... View more

I am trying to delete an XLSX file on the unix server and getting error messages. Below is my code. How can I delete this file in SAS EG? I need code to do this. Below are the error messages that I am getting.       Removed ... View more

What are the best ways to zip SAS data sets? Below is the code that I have tried using SAS and Putty. In SAS, I did not get a log saying this was successful or not. I did get an ! exclamation point. In Putty, I also did not get any message if successful or not. What are the best and fastest ways to zip large data sets in SAS or Putty? Also, is there a way to do multiple data sets at once? Also, I think a log would be nice as well. Thank you! SAS   Removed Putty Unix   Removed ... View more

I am looking through someone's code. What does this piece of code do? I am getting better at PRXCHANGES and regex's. I am not a pro yet but still learning. It looks to me like it is replacing something like P.O. BOX with PO BOX. Does \s? mean optional spaces? and 0? mean 0 is optional? Also :? means : is optional? Looks like I may be understanding some of it. Thanks   Removed   ... View more

I have a question in SAS. How do you normally determine a difference in two data sets? Below is the code that I have used. This is what I have used to determine if records are in one data set but not the other. For example, if someone running the code got higher or lower record counts. I am looking for any alternatives. Thanks.     Removed ... View more

I am looking through some code and wondering what this does. Below are the code comments. I'm still not sure what this code does even with the code comments. I have used arrays but not familiar with this code. It looks like this code dedupes by using two indices. Is that correct? So if there is a combination of CCS_DR_IDX and TXN_IDX, it will delete those records?   Now handle cases where the dollar matches. If ccs_dr_idx has already been used then delete the record. Dropped txns here will be added back in with the claim data called missing.     Removed   ... View more

Do you guys know how to replace remove the comma and period in something like this:   Removed I had to concatenate to get list of claim numbers (with leading zeros). Now, I have that string but I want to delete all the stuff at the end. I tried this but it didn't work Removed By the way, I am using SAS and regex, something like prxchange. ... View more

I have a question. I have a field in my SAS dataset that has a mixture of datetime and date variables. The field is PST_DT and is Type: Numeric. Group: Date. Format: Date9. Length: 8. Some values look like this: Removed How can I turn just the datetime values in date format? I want all the values to be in date format. Thanks. ... View more

I am analyzing data. I need to extract everything from these strings before the first space. How can I extract the substring of everything up to the first space. I am using SAS and have used PRXMATCH but not familiar with doing this. Thanks!   Removed   So in my output I need: Removed I then need to extract only the first numbers so I get:   Removed Any help is greatly appreciated. Thanks much ... View more