About UMR13

UMR13 · ‎07-26-2019

I have added a SAS Capture of what it looks like at this moment. I would like for example all the years to be in one cell together with one school. Example: ADA Merritt K-8 Center in one cell with no duplicates and the years all in one cell as 2010-2011,2011-2012,2012-2013, etc... all in one cell.

UMR13 · ‎07-26-2019

Hello, I was wondering if SAS had the capability of matching two columns together for me. I have a School Name column and a Academic Year column. Each school has multiple years associated with it but they are all separate: Example: School 1/ 2018-2019 School 1/ 2013-2014 I would like for SAS to give me a combined list in the form this format: School 1/ 2013-2014,2018-2019 and so on. Is this possible? Thank you.

UMR13 · ‎06-24-2019

Hello, I am having an issue figuring out how to do this on SAS. I have provided a picture below MC3-1 are different months of completion. I need the latest month of completion which would be MC3 if it has a month, MC2 if MC3 is missing and MC1 if MC3 and MC2 are missing. What would be the simplest way of doing this? Thank you.

UMR13 · ‎06-11-2019

Thank you very much for your speedy reply. This helped Tremendously.

UMR13 · ‎06-11-2019

Hello, I am relatively new to SAS I have three data columns with completion dates over 3 days. Some days do not have a date and some do which would indicate completion. How do i check which cells have dates completed across the board for all three days. Thank you.

Online Status	Offline
Date Last Visited	‎07-29-2019 06:21 PM

Re: SAS matching two columns together

SAS matching two columns together

Help with Dates Dilema

Re: Sas Help Dates

Sas Help Dates

Re: SAS matching two columns together

SAS matching two columns together

Help with Dates Dilema

Re: Sas Help Dates

Sas Help Dates