About kpdoe

kpdoe · ‎04-20-2023

data A; input ACCT Date mmddyy10.; format Date mmddyy10.; datalines; 1111 10/31/2022 1111 02/26/2023 ; run; /* Creating Dataset B */ data B; input ACCT Txt $ Src_Date mmddyy10.; format Src_Date mmddyy10.; datalines; 1111 ABC 03/23/2023 ; run; ACCT Date Txt 1111 10/31/2022 1111 02/28/2023 ABC Is this result achievable without having a matching date filed? Thanks in advance for any help!

kpdoe · ‎04-22-2021

@Astoundingthat worked but, I still want a record with the highest score. For the above scenario the code worked but did not satisfy this one. Output with your code below: ID secnd_ID A B Score Cnt Tag Code 67890 35456 001 0.01567 1 67890 37459 004 0.04237 2 D Delete 67890 75456 001 0.00958 3 D Delete Desired output: I need the output with the higher score ID secnd_ID A B Score Cnt Tag Code 67890 37459 004 0.04237 1 67890 35456 001 0.01567 2 D Delete 67890 75456 001 0.00958 3 D Delete

kpdoe · ‎04-22-2021

Meaning if there's a value in var "A" there should be no tag and code assigned.

kpdoe · ‎04-22-2021

Hello I need help with assigning tag for high score by variable "A" taking a priority regardless of the high score in var "B". With below code, I am not getting the correct output. I have a data: testa ID secnd_ID A B Score 12345 34557 1 0.00514 12345 23456 3 0.00449 12345 34545 1 0.00384 Output with code below: ID secnd_ID A B Score Cnt Tag Code 12345 34557 1 0.00514 1 12345 23456 3 0.00449 2 D Delete 12345 34545 1 0.00384 3 D Delete Desired output: ID secnd_ID A B Score Cnt Tag Code 12345 34557 1 0.00514 2 D Delete 12345 23456 3 0.00449 1 12345 34545 1 0.00384 3 D Delete Code: proc sort data=testa; by ID descending score descending A; run; data test_keep set testa; by id; retain cnt; if first.id = 1 then cnt = 0; cnt + 1; if cnt > 1 then tag = 'D' if tag = 'D' then code = 'Delete'; run;

kpdoe · ‎12-19-2019

kpdoe · ‎12-19-2019

Yes it was intentional. I need to do sampling

kpdoe · ‎12-19-2019

I tried this method but the all the missing group is assigned as 1

kpdoe · ‎12-18-2019

Hello, I have an excel file which I create a dataset from and want to assign the group #. How can I achieve the below scenario? Have: ID QTY GROUP 1 2 0.05 2 3 0.05 2 4 5 0.05 5 6 0.05 5 7 8 Want: ID QTY GROUP 1 1 2 0.05 2 3 0.05 2 4 3 5 0.05 5 6 0.05 5 7 6 8 7

kpdoe · ‎12-16-2019

I tried but then in the output I would get random samples but not complete. for ex, from the table ID 4 would only one record would get printed. I want to print all 5 obs printed in the random samples from that group. ID ID 2 ACCT_CNT GROUP 1 123 1 2 1234 1 2 1235 2 5 1789 1 5 1790 2 3 1236 1 3 1237 2 3 1238 3 4 1561 1 D 4 1562 2 D 4 1563 3 D 4 1564 4 D 4 1565 5 D 6 1910 1 D 6 1920 2 D 6 1930 3 D 6 1940 4 D 6 1950 5 D 6 1960 6 D

kpdoe · ‎12-16-2019

Hello, I have a large data set and I want to get random samples with each ID, ACCN, ACCT_CNT, and group Please see the sample below One ID can have multiple ACCN and ACCT_CNT is counts per each ID. ID ID 2 ACCT_CNT GROUP 1 123 1 2 1234 1 2 1235 2 5 1789 1 5 1790 2 3 1236 1 3 1237 2 3 1238 3 4 1561 1 D 4 1562 2 D 4 1563 3 D 4 1564 4 D 4 1565 5 D 6 1910 1 D 6 1920 2 D 6 1930 3 D 6 1940 4 D 6 1950 5 D 6 1960 6 D I tried proc survey select to get random samples by each ID and acct_cnt but I couldn't figure it out.

kpdoe · ‎08-15-2019

Hello I need help with the data which having count sID > 10 Data: ID sID. Dt 1. 1234. 1/7/2019 1. 1234. 1/7/2017 2. 1233. 1/6/2017 3. 1233. 1/6/2017 4. 1233. 1/6/2017 5. 1233. 1/6/2017 6. 1233. 1/6/2017 7. 1233. 1/6/2017 8. 1233 1/6/2017 9. 1233. 1/6/2017 11. 1233. 1/6/2017 10. 1233. 1/6/2017 11. 1233. 1/6/2017 I need to get ID. sID. No_acc 2. 1233. 11 . . 11. 1233. 11

kpdoe · ‎06-01-2017

Thank you very much. It worked!

kpdoe · ‎06-01-2017

No x15 doesnt have to match y17. x1 should mach y1. It is one to many relationship.

kpdoe · ‎06-01-2017

Hello, I need help with joining two tables with hash. Both tables has one unique key and one other duplicate variable. Below are the matching variables x1 - y1 x15 - y17 /* 15 variables */ Table a x1 . . x15 /* 17 variables */ Table b y1 . . y17 I tried with following code but I am getting all the variables from table b and only one from table a instead I want to display all the var from table a and all the var from table b data left_join(drop=rc); declare Hash a (dataset: "o.a"); rc=a.definekey('x1'); rc=a.definedata(); rc=a.definedone(); do until(eof); set o.b end=eof; rc=a.find(); output; end; stop; run;

Online Status	Offline
Date Last Visited	‎04-21-2023 03:41 AM

Need help with merge

Re: assigning code based on score

Re: assigning code based on score

assigning code based on score

Re: Assign number to group

Re: Assign number to group

I tried this method but the all the missing group is assi...

Assign number to group

Re: Random Samples by ID

Random Samples by ID

Need help with merge

Re: assigning code based on score

Re: assigning code based on score

assigning code based on score

Re: Assign number to group

Re: Assign number to group

I tried this method but the all the missing group is assi...

Assign number to group

Re: Random Samples by ID

Random Samples by ID

Counts gt 10

Re: HASH Left Join

Re: HASH Left Join

HASH Left Join