About luvscandy27

luvscandy27 · ‎12-20-2021

Hello, I need some help and I'm not sure where to begin. I have two datasets: Dataset One last_name first name DOB address City State Zip Billy Bob 8/15/1979 702 Park Avenue St. Wilmington NC 57896 Will Jr. King 5/11/1993 55556 Martin Lane Charlotte NC 12589 And dataset two last_name first name DOB address City State Zip Billy Bob 8/15/1979 702 Park Avenue St. Wilmington NC 57896 Will King 5/11/1993 55556 Martin Ln. Charlotte NC 12589 I would like to match on dob, and the first 9 characters of the address since the Street could be spelled Street or St. etc. What I am trying to achieve is to find duplicates in the two datasets where the name maybe different by matching on dob and street address. For instance, Will, King is in the both datasets but dataset one has him listed as Will Jr., King. Then I would like to output all instances where the DOB and address match but there is a possibility that the name maybe different.

luvscandy27 · ‎09-28-2021

Hello everyone, I have data like this: month type total_2021 delta 1 ip $13,523,323 -14% 2 ip $12,969,525 -16% 3 ip $13,678,954 -22% 1 ipop $68,414,734 -7% 2 ipop $62,715,246 -7% 3 ipop $68,270,752 -2% 1 op $54,891,411 -5% 2 op $49,745,721 -4% 3 op $54,591,797 5% What I would like to do, but am not sure how is to get the data like this: type 1 1_delta 2 2_delta 3 3_delta ip $13,523,323 -14% $12,969,525 -16% $13,678,954 -22% ipop $68,414,734 -7% $62,715,246 -7% $68,270,752 -2% op $54,891,411 -5% $49,745,721 -4% $54,591,797 5% Any assistance would be great. Below please find the code to create the dataset. data have; input month type $ total_2021 delta; format delta percentn10.0 total_2021 dollar12.0; datalines; 1 ip 13523323 -0.14153 2 ip 12969525 -0.15819 3 ip 13678954 -0.21653 1 ipop 68414734 -0.06826 2 ipop 62715246 -0.06579 3 ipop 68270752 -0.01973 1 op 54891411 -0.04825 2 op 49745721 -0.03827 3 op 54591797 0.04611 ; run;

luvscandy27 · ‎09-17-2021

Sure. data date; infile datalines delimiter = ','; input fy 4. month $ fruit $ total 12.; format total dollar12.0; datalines; 2021, JAN, orange, 212741 2020, JAN, orange, 660370 2021, FEB, orange, 259731 2020, FEB, orange, 340820 2021, MAR, orange, 416599 2020, MAR, orange, 600608 2021, JAN, apple, 366962 2020, JAN, apple, 512251 2021, FEB, apple, 374792 2020, FEB, apple, 362118 2021, MAR, apple, 803769 2020, MAR, apple, 744443 2021, JAN, grapes, 1023649 2020, JAN, grapes, 529001 2021, FEB, grapes, 755241 2020, FEB, grapes, 786307 2021, MAR, grapes, 614506 2020, MAR, grapes, 784661 ; run;

luvscandy27 · ‎09-17-2021

Good morning, I have searched the internet and can not find the answer to my question. Any assistance would be greatly appreciated. Below please find sample data. FY month Fruit year Total 2021 JAN orange current_2021 $212,741 2020 JAN orange previous_2020 $660,370 2021 FEB orange current_2021 $259,731 2020 FEB orange previous_2020 $340,820 2021 MAR orange current_2021 $416,599 2020 MAR orange previous_2020 $600,608 2021 JAN apple current_2021 $366,962 2020 JAN apple previous_2020 $512,251 2021 FEB apple current_2021 $374,792 2020 FEB apple previous_2020 $362,118 2021 MAR apple current_2021 $803,769 2020 MAR apple previous_2020 $744,443 2021 JAN grapes current_2021 $1,023,649 2020 JAN grapes previous_2020 $529,001 2021 FEB grapes current_2021 $755,241 2020 FEB grapes previous_2020 $786,307 2021 MAR grapes current_2021 $614,506 2020 MAR grapes previous_2020 $784,661 What I would like to do is determine the percent change by month for each fruit. Change would be calculated as follows (2021/2020)-1. What I would like to end up with is : FY Fruit year Total Delta 2021 orange JAN current_2021 $212,741 -68% 2021 orange FEB current_2021 $259,731 -24% 2021 orange MAR current_2021 $416,599 -31% 2021 apple JAN current_2021 $366,962 -28% 2021 apple FEB current_2021 $374,792 3% 2021 apple MAR current_2021 $803,769 8% 2021 grapes JAN current_2021 $1,023,649 94% 2021 grapes FEB current_2021 $755,241 -4% 2021 grapes MAR current_2021 $614,506 -22% Is this possible using SAS?

luvscandy27 · ‎09-07-2021

Hello everyone, I have a question that I can not for the life of me figure out. I have the following sample dataset. ID appt_type qtr_1 1852558 Specialty 1 1852558 Future . 1852558 Future . 1852558 Future . 0001D9DA82 Future . 00026A2508 Specialty 1 What I would like to do is keep the ids that have qtr_1 = 1 and get a count of how many appt_types happened after the first appt_type. If an id has qtr_1 = 1 and but only has one appt_type then that id can be excluded. From the sample data above, I am trying to achieve this outcome: ID appt_type qtr_1 count 1852558 Specialty 1 1852558 Future . 1 1852558 Future . 2 1852558 Future . 3

luvscandy27 · ‎07-10-2021

Hello everyone, My data table looks like this: order gender count1 percent1 count2 percent2 1 MALE 191,404 85.6% 22,320 87.7% 2 FEMALE 23,349 10.4% 2,995 11.8% 3 MISSING 8,861 4.0% 132 0.5% However, I would like to combine the count variables with the percent variables to get the table to look like this: order gender count1 count2 1 MALE 191,404(85.6%) 22,320(87.7%) 2 FEMALE 23,349(10.4%) 2,995(11.8%) 3 MISSING 8,861(4.0%) 132 (0.5%) I searched this site and found two codes that will combine the variables and they are: Test=CAT(strip(date),'(',strip(Devdate),')'); Test2=compress(date||"("||Devdate||")"); They work but my formats will not stay and the data looks like this: test 22320(0.8771171454) 2995(0.1176956026) 132(0.0051872519) My question is does anyone know how I can combine the columns and keep the formats? And if possible, can I do this using Proc Sql? If not, I can also use a data step.

luvscandy27 · ‎03-05-2021

Hello all, I am working with the code below and I keep getting the error. ERROR: Invalid date/time/datetime constant "stdft."d. I have checked my formats and they are all the same and I just can't seem to figure out what is causing the error? data dates; infile datalines delimiter = ','; input ID $ DATE:anydtdte11. COND STDT:anydtdte11. ENDT:anydtdte11. ; format date stdt endt mmddyy10.; datalines; 1, 05/03/2018, ., 05/03/2017, 05/03/2018 1, 05/02/2018, ., 05/02/2017, 05/03/2018 2, 04/26/2018, 1, 04/26/2017, 04/27/2018 2, 04/18/2018, 1, 04/18/2017, 04/18/2018 2, 04/10/2018, 1, 04/10/2017, 04/10/2018 ; run; proc sql; create table want as select distinct *, stdt as STDFT format date9., stdt as ENDTFT format date9. from dates where cond=1 and date between "stdft."d and "endtft."d; quit;

luvscandy27 · ‎03-04-2021

Thank you!

luvscandy27 · ‎03-04-2021

This is great however, I am very new at macro processing . I hate to ask this but could you provide me with an explanation of what is happening in the code? Also, the sample data I put in the post only processes January data. With the code you provide can I process all months at one time or do I need to separate the months?

luvscandy27 · ‎03-04-2021

I'll try call execute. Any documentation would be greatly appreciated.

luvscandy27 · ‎03-04-2021

Hello all, I would like to know if there is any way for me to use the code below for several months. I have several rosters from January to December. The code below processes the roster for only January therefore I have to change the code multiple times to fit each month I am working with. I'm processing them separately since I need to have a rolling twelve months i.e. for February rosters the dates would be February 28 2017 to February 2018 and so on. The data below is only sample data. data date; infile datalines delimiter = ','; input ID $ DATE:mmddyy10. TYPE $11. PAIN HEART INPAT OUTPAT; format date mmddyy10.; datalines; 1, 05/03/2018, OUTPATIENT, ., 1, ., 1 1, 05/02/2018, OUTPATIENT, ., 1, ., 1 2, 01/26/2018, OUTPATIENT, 1, ., ., 1 2, 01/18/2018, OUTPATIENT, 1, ., ., 1 2, 01/10/2018, OUTPATIENT, 1, ., ., 1 ; run; %macro split(cond, titlemonyr, ranstart, ranend); /*Split the conditions*/ proc sort data=date nodupkey out=&cond._&titlemonyr.; by id date type; where &cond.=1 and date ge "&ranstart."d and date le "&ranend."d ; run; /*Determine what cases meet the case definition (2 outpatient or one inpatient unless is head trauma. Note: head trauma is counted once regardless of inpatient or outpatient. The look back period is one year.*/ data &cond._&titlemonyr._2; set &cond._&titlemonyr.; retain count; by id date type; if first.id then count= 1; else count = count + 1;/*adding the total appointments*/ %if &cond. ne HT %then %do; if last.id and count = 1 and INPAT = . then delete; %end; run; %mend split; %split (PAIN, JAN2018, 31jan2017, 31jan2018); %split (HEART, JAN2018, 31jan2017, 31jan2018);

luvscandy27 · ‎03-03-2021

Got it. Thank you!

luvscandy27 · ‎03-03-2021

Hello all, I have the following data and code below. What I would like to do is choose the last monyr by id. Example the id listed below I would like to choose 04/26/2017 and 05/03/2017. I tried using the code below but no obs are chosen. data date; infile datalines delimiter = ','; input ID $ DATE:mmddyy10. ; format date mmddyy10.; datalines; 1, 05/03/2017 1, 05/02/2017 1, 04/26/2017 1, 04/18/2017 1, 04/10/2017 ; run; data date; set date; MONYR=DATE; format monyr monyy7.; run; proc sort data=date; by id monyr date; run; data want_date; set date; by id monyr date; if last.monyr; run;

luvscandy27 · ‎02-17-2021

I'm not sure if what I'm trying to do is possible but, any help would be greatly appreciated. I have several rows of data. What I would like to do is calculate the number of days between each date by ID and create the following flags: le 180 days = 6 months 181 days to 360 days = 12 months 361 days to 540 days = 18 months 541 days to 720 days = 24 months ge 721 days = gt two years For example, for ID 2 12/13/2016 - 03/14/2017 = 91 days, 03/14/2017-07/11/2017 = 120 so 120+90=210 therefore I should get a flag then continue on. The sample data is below. data mydata; input ID DATE:mmddyy10. ; format DATE mmddyy10.; datalines; 1 07/31/2017 1 08/14/2017 1 08/15/2017 1 08/21/2017 1 09/08/2017 1 10/27/2017 1 01/03/2019 1 02/28/2019 1 03/01/2019 1 03/18/2019 2 12/13/2016 2 03/14/2017 2 07/11/2017 2 07/12/2017 2 08/22/2017 3 12/15/2017 4 10/25/2016 5 11/30/2016 5 11/30/2016 5 12/12/2016 5 12/21/2016 5 02/17/2017 5 03/24/2017 6 12/22/2020 7 03/26/2019 7 04/08/2019 8 01/27/2021 8 02/04/2021 9 07/12/2016 10 05/04/2018 10 05/25/2018 10 09/24/2019

luvscandy27 · ‎01-29-2021

OMG!!! You are absolutely correct. I forgot its a new year and had not updated my denominators. The whole time I was thinking my format was incorrect. Thank you so much.

Online Status	Offline
Date Last Visited	‎03-26-2025 05:44 AM

Re: Graph Recreation

Graph Recreation

Two different formats under one variable

Drop zeros after rounding

Re: Add characters to a String

Re: Add characters to a String

Add characters to a String

Re: Rearrange Variables in the same Column

Re: Rearrange Variables in the same Column

Re: Rearrange Variables in the same Column

Re: Graph Recreation

Re: Divide by the same variable

Re: Divide by the same variable

Re: Combine two variables and keep the formatting

Re: Combine two variables and keep the formatting

Re: Finding and removing duplicates

Match on address and DOB to find Duplicates

Transpose and arrange two variables

Re: Divide by the same variable

Divide by the same variable

Grouping and counting by ID

Combine two variables and keep the formatting

Invalid date/time constant

Re: Processing multiple months

Re: Processing multiple months

Re: Processing multiple months

Processing multiple months

Re: Choosing obs by monyr

Choosing obs by monyr

Creating Flags for Six Month Increments

Re: Joining Tables