About mauri0623

mauri0623

I have a birthdate such as 01SEP60:00:00:00. Length = 8 Format datetime16. Informat anydtdtm40. I want to get the year of this string. I tried birth_year = year(input(birthdate,anydtdte20.)); I did not get any erro but every birth_year came out as missing. Thank you!

mauri0623 · ‎09-28-2023

I have this table that I can get using proc summary. The problem is that the result of the proc summary does not exactly look like the table and it needs to be minuplated more to make it look like the table. Is there a way to do it using SQL prehaps? R1a. Number of Line Items With Select Procedure Codes, FY 2014 -2023 Fiscal Year Procedure Code Total Line Items Q4145 Q4155 Q4162 Q4171 Q4174 Q4177 Q4185 Q4192 Q4213 Q4215 Q4231 Q4244 Q4246 2014* 2015 2016 2017 2018 2019 2020 2021 2022 2023* Total Line Items

mauri0623 · ‎07-06-2023

I want to be able to form a where statement based on three variables. One variable is called edipn and the others are patcat_e and patcat_p. basically I want to say, where edipn not equal to missing and the first to 5th position of the patcat_e and patcat_p. Please help

mauri0623 · ‎05-12-2023

Thank you. I appreciate your time. Obviously, you are a very versed programmer. If it is OK I would like to contact you about this. I still have other part of this that I also need a little help with. I however do not want to be demanding. Just if you have a few minutes that you can spare. Any day or any time will be fine. Hope you have a blast weekend. Thank you again.

mauri0623 · ‎05-11-2023

Washout is 183 days from the grace period of the one week forward and two weeks backward.

mauri0623 · ‎05-11-2023

Starting with the dataset below, we need to identify the index encounter, which is the encounter_date closest to the start_date. Encounter_date may be up to two weeks prior to intake survey date(start_Date) through 1 week after it We also need to apply a washout period. To qualify as an index encounter, there must be no other encounters within 183 days prior to the 2 week grace period, up to two weeks before the index period. Person_ID Encoured_Date Start_Date 00006A7087 10/7/2021 4/5/2022 00006A7087 11/5/2021 4/5/2022 00006A7087 11/15/2021 4/5/2022 00006A7087 12/2/2021 4/5/2022 00006A7087 12/14/2021 4/5/2022 00006A7087 12/21/2021 4/5/2022 00006A7087 1/3/2022 4/5/2022 00006A7087 1/18/2022 4/5/2022 00006A7087 1/25/2022 4/5/2022 00006A7087 2/4/2022 4/5/2022 00006A7087 2/8/2022 4/5/2022 00006A7087 2/17/2022 4/5/2022 00006A7087 3/2/2022 4/5/2022 00006A7087 3/8/2022 4/5/2022 00006A7087 3/18/2022 4/5/2022 00006A7087 4/5/2022 4/5/2022 00006A7087 4/12/2022 4/5/2022 0000E20E92 1/28/2022 4/5/2022 0000E20E92 3/22/2022 4/5/2022 0000E20E92 4/5/2022 4/5/2022 0000E20E92 5/3/2022 4/5/2022 0000E20E92 5/17/2022 4/5/2022 0000E20E92 5/31/2022 4/5/2022 0000E20E92 7/15/2022 4/5/2022 0000E20E92 8/9/2022 4/5/2022 0000E20E92 10/19/2022 4/5/2022 0000E20E92 11/30/2022 4/5/2022 I know how to go 1 week forward and two weeks backward using the intnx function. I however don'w know about how to construct the washout period part.

mauri0623 · ‎05-11-2023

Starting with the dataset below, we need to identify the index encounter, which is the encounter_date closest to the start_date. Encounter_date may be up to two weeks prior to intake survey date(start_Date) through 1 week after it We also need to apply a washout period. To qualify as an index encounter, there must be no other encounters within 183 days prior to the 2 week grace period, up to two weeks before the index period. Person_ID Encoured_Date Start_Date 00006A7087 10/7/2021 4/5/2022 00006A7087 11/5/2021 4/5/2022 00006A7087 11/15/2021 4/5/2022 00006A7087 12/2/2021 4/5/2022 00006A7087 12/14/2021 4/5/2022 00006A7087 12/21/2021 4/5/2022 00006A7087 1/3/2022 4/5/2022 00006A7087 1/18/2022 4/5/2022 00006A7087 1/25/2022 4/5/2022 00006A7087 2/4/2022 4/5/2022 00006A7087 2/8/2022 4/5/2022 00006A7087 2/17/2022 4/5/2022 00006A7087 3/2/2022 4/5/2022 00006A7087 3/8/2022 4/5/2022 00006A7087 3/18/2022 4/5/2022 00006A7087 4/5/2022 4/5/2022 00006A7087 4/12/2022 4/5/2022 0000E20E92 1/28/2022 4/5/2022 0000E20E92 3/22/2022 4/5/2022 0000E20E92 4/5/2022 4/5/2022 0000E20E92 5/3/2022 4/5/2022 0000E20E92 5/17/2022 4/5/2022 0000E20E92 5/31/2022 4/5/2022 0000E20E92 7/15/2022 4/5/2022 0000E20E92 8/9/2022 4/5/2022 0000E20E92 10/19/2022 4/5/2022 0000E20E92 11/30/2022 4/5/2022 I know how to go 1 week forward and two weeks backward using the intnx function. I however don'w know about how to construct the washout period part.

mauri0623 · ‎06-22-2021

I tried index but the values are coming up as numbers.

mauri0623 · ‎06-22-2021

*--HS002108475----HS002108475 *---HS002105485---SFHS002105485 *---HS002105485---SFHS002105485 *---HS002105485---SFHS002105485 *---HS002105485---SFHS002105485 *--ZKA----AA *--ZKA----AA only these one.

mauri0623 · ‎06-22-2021

Only HS002 and ZKA.

mauri0623 · ‎06-22-2021

That is a part of the string. I want the HS002 rows.

mauri0623 · ‎06-22-2021

I have the followings, *--FA807518F1456-FA807518F1456-1002-07-HS002193888 *--HS002108475----HS002108475 *---HS002105485---SFHS002105485 *---HS002105485---SFHS002105485 *---HS002105485---SFHS002105485 *---HS002105485---SFHS002105485 *------SFHS002106080 *------AAZKA021821TSPLOS *------AAZKA021821TSPBRK *------AAZKA030421TSPLOS *------AAZKA030421TSPBRK *------AAZKA031821TSPBRK *--HQ0642149245----HQ0642149245 *------AAZKA040121TSPLOS *------AAZKA041221TSPBRK *---HS47371659Z010---HS47371659Z010 *--HQ0642149245----HQ0642149245 *--AGENTPAGE----HS002121076MW0 *--ZKA----AA *--ZKA----AA *--AGENTGUZMAN----HS002121076MW0 *--AGENTLEE----HS002121076MW0 *--AGENTMELLGREN2----HS002121076MW0 *--AGENTPRICE----HS002121076MW0 *--PWFFSA21337860321--0007--HAFC0583142 *--AGENTELDRIDGE----HS002121076MW0 *--AGENTMELLGREN----HS002121076MW0 *------AAZKA042921TSPBRK *--N0003421----AA I am trying to get those rows that start with HS002 or ZKA and place them in a variable called GOTIT. Some kind of substring. Thank you!

mauri0623 · ‎06-11-2021

data first(keep = major_ag ag_abbr first_year) last(keep = major_ag ag_abbr last_year); length major_ag $2; set Data_Rep.c_agency; major_ag = substr(ag_code,1,2); select (major_ag); when ('03') ag_abbr = 'HHS'; when ('06') ag_abbr = 'NSF'; when ('02') ag_abbr = 'DOD'; when ('04') ag_abbr = 'DOE'; when ('05') ag_abbr = 'NASA'; when ('01') ag_abbr = 'USDA'; when ('19') ag_abbr = 'ED'; when ('08') ag_abbr = 'DOC'; end; output first; output last; run; I am trying to also get the agencies that are not 03,06,02,04,05,01,08, and 19 in as Other agencies. I am not sure where to place that when statement in the same code.

mauri0623 · ‎06-03-2021

How to turn table A into Table B using proc transpose. Table A fy DST_Name totalSE totalRD fttg 2014 All Institution 2624024.488 1460889.476 126428.746 2015 All Institution 2852550.170 1539595.556 138213.344 2016 All Institution 2697110.604 1570449.914 125886.366 2014 Aaniiih Nakoda C. 309.655 0.000 209.655 2014 Adams State U. 75.000 75.000 0.000 2014 Alabama A&M U. 6632.544 3379.987 134.443 2014 Alcorn State U. 6282.778 3290.692 0.000 2014 Alfred U. 40.000 40.000 0.000 2015 Aaniiih Nakoda C. 309.655 0.000 209.655 2015 Adams State U. 75.000 75.000 0.000 2015 Alabama A&M U. 6632.544 3379.987 134.443 2015 Alcorn State U. 6282.778 3290.692 0.000 2015 Alfred U. 40.000 40.000 0.000 2016 Aaniiih Nakoda C. 309.655 0.000 209.655 2016 Adams State U. 75.000 75.000 0.000 2016 Alabama A&M U. 6632.544 3379.987 134.443 2016 Alcorn State U. 6282.778 3290.692 0.000 2016 Alfred U. 40.000 40.000 0.000 Table B Dst_name 2014 2015 2016 All Institution 2624024.488 1460889.476 126428.746 All Institution 2852550.170 1539595.556 138213.344 All Institution 2697110.604 1570449.914 125886.366 Aaniiih Nakoda C. 309.655 0.000 209.655 Adams State U. 75.000 75.000 0.000 Alabama A&M U. 6632.544 3379.987 134.443 Alcorn State U. 6282.778 3290.692 0.000 Alfred U. 40.000 40.000 0.000 Aaniiih Nakoda C. 309.655 0.000 209.655 Adams State U. 75.000 75.000 0.000 Alabama A&M U. 6632.544 3379.987 134.443 Alcorn State U. 6282.778 3290.692 0.000 Alfred U. 40.000 40.000 0.000 Aaniiih Nakoda C. 309.655 0.000 209.655 Adams State U. 75.000 75.000 0.000 Alabama A&M U. 6632.544 3379.987 134.443 Alcorn State U. 6282.778 3290.692 0.000 Alfred U. 40.000 40.000 0.000

mauri0623 · ‎06-03-2021

Table A fy DST_Name totalSE totalRD fttg 2014 All Institution 2624024.488 1460889.476 126428.746 2015 All Institution 2852550.170 1539595.556 138213.344 2016 All Institution 2697110.604 1570449.914 125886.366 2014 Aaniiih Nakoda C. 309.655 0.000 209.655 2014 Adams State U. 75.000 75.000 0.000 2014 Alabama A&M U. 6632.544 3379.987 134.443 2014 Alcorn State U. 6282.778 3290.692 0.000 2014 Alfred U. 40.000 40.000 0.000 2015 Aaniiih Nakoda C. 309.655 0.000 209.655 2015 Adams State U. 75.000 75.000 0.000 2015 Alabama A&M U. 6632.544 3379.987 134.443 2015 Alcorn State U. 6282.778 3290.692 0.000 2015 Alfred U. 40.000 40.000 0.000 2016 Aaniiih Nakoda C. 309.655 0.000 209.655 2016 Adams State U. 75.000 75.000 0.000 2016 Alabama A&M U. 6632.544 3379.987 134.443 2016 Alcorn State U. 6282.778 3290.692 0.000 2016 Alfred U. 40.000 40.000 0.000 Table B Dst_name 2014 2015 2016 All Institution 2624024.488 1460889.476 126428.746 All Institution 2852550.170 1539595.556 138213.344 All Institution 2697110.604 1570449.914 125886.366 Aaniiih Nakoda C. 309.655 0.000 209.655 Adams State U. 75.000 75.000 0.000 Alabama A&M U. 6632.544 3379.987 134.443 Alcorn State U. 6282.778 3290.692 0.000 Alfred U. 40.000 40.000 0.000 Aaniiih Nakoda C. 309.655 0.000 209.655 Adams State U. 75.000 75.000 0.000 Alabama A&M U. 6632.544 3379.987 134.443 Alcorn State U. 6282.778 3290.692 0.000 Alfred U. 40.000 40.000 0.000 Aaniiih Nakoda C. 309.655 0.000 209.655 Adams State U. 75.000 75.000 0.000 Alabama A&M U. 6632.544 3379.987 134.443 Alcorn State U. 6282.778 3290.692 0.000 Alfred U. 40.000 40.000 0.000

Online Status	Offline
Date Last Visited	4 weeks ago

date_manipulation

Adjust PROC SUMMARY output

simple where statement.

Re: Dates manipulation

Re: Date forward and backward.

Dates manipulation

Date forward and backward.

Re: question

Re: question

Re: question

Re: convert

Re: convert

Re: sas subtraction

date_manipulation

Adjust PROC SUMMARY output

simple where statement.

Re: Dates manipulation

Re: Date forward and backward.

Dates manipulation

Date forward and backward.

Re: question

Re: question

Re: question

Re: question

question

data first(keep = major_ag ag_abbr first_year) last(keep = major...

Chanaging tables

Re: The table to be changed