Hello Kurt, What you have directed me are links after links. If I want to get that route, I would be lost and each day, I need to start working in a new company. Obviously, reading is essential part of gaining education, I always read and search and then I post my question here. I clicked on the links then other links came up and then till seven layers deep that I forgot what I wanted. Anyway, thank you for sending me the direction that I go back and read them after I deliver my projects. I have short deadlines.   Respectfully, Blue & Blue ... View more

Hello, Why don’t I say if difference is > 0 and <= 30? And should I find the difference first and then bring if? Respectfully, Blueblue ... View more

Hello Tom, Thanks for your response.  why should I use abs? if dateofservice is less than discharge date, then that is ok. We want to find out those records when they had a visit within 30 days after their discharge. if we use abs, then we can’t find out within 30 days after thr discharge date. can’t we use datedif?   how should I guard against missing values? If discaregedate or dateofservice ne.? yes both values are dates. I think if the result is positive, then dos has occurred after discharge date. Then, I need to find out if it is between 0 to 30 days. regards  blue & blue ... View more

Hello, I know sql and relational database management system. I did the code myself and it gave me 8 errors and I fixed them one by one, still the last one persisted. Last night, it was too late and I couldn't apply your solution. Please bear with me. Blue&Blue ... View more

Hello Astounding, Sorry, my mistake. I thought you already knew at least the basics of the SELECT statement. I wrote the code by myself and posted here. It was giving 8 errors and I fixed them all, except the last one that I couldn't, that is why, I posted here in this forum. I know sql. Respectfully, BlueBlue ... View more

Hello team member, Because your WHEN statements specify a complete comparison, you need to simplify the SELECT statement. Use: SELECT(); Can you please kindly explain it more? If I select one variable, are the other variable included in the result?   Regards, blue & white  ... View more

data want; set test; length Month $3; if DateOfService ne . then do; Month=substr(put(DateOfService,date9.),3,3); /* result is like FEB */ Month=propcase(substr(put(DateOfService,date9.),3,3));/* result is like Feb select as you like */ end; run; Hello team member, First solution: dates are like 03/12/2021, it is not text.  All months as character have 3 characters. How does SAS distinguish this?   I think your second solution is the answer. Let me test it and get back to you. What would be the syntax if I want to write in process sql?   Refering to dates in datelines, thanks for clarification, I am so thankful, Blue&white ... View more