About J_J_J

J_J_J · ‎11-05-2021

PeterClemmensen, thank you so much!

J_J_J · ‎11-03-2021

Hi! I want to put 7 consecutive numbers in to one column, and the rest characters in the other. Please let me know how to do it? data state; input ID $; cards; AAAAAA BBB 1111111 2222222 CCC -1111 CCCCCCC 2222222 CCCCCCCCCCC 3333333 ; run; Want: ID Number ABC AAAAAA BBB 1111111 1111111 AAAAAA BBB 2222222 CCC -1111 2222222 CCC -1111 CCCCCCC 2222222 2222222 CCCCCCC CCCCCCCCCCC 3333333 3333333 CCCCCCCCCCC

J_J_J · ‎07-02-2021

Hi When I use this code: date = mdy(month,1,year); format date yymms7.; I get period like this 2021M01 not 2021/01. What did i do wrong?

J_J_J · ‎05-12-2021

Thank you Sajid01!

J_J_J · ‎05-11-2021

Hi! I'm trying to find the way to sort data after PROC TRANSPOSE automatically I have data: data have; month=1; code='AA1111111'; text='aaa'; prior='2'; type='BB'; num=4; output; month=1; code='BB1111111'; text='bbb'; prior='4'; type='AA'; num=8; output; month=1; code='BB1111111'; text='bbb'; prior='4'; type='BB'; num=1; output; month=1; code='CC1111111'; text='ccc'; prior='4'; type='CC'; num=5134; output; month=1; code='CC1111111'; text='ccc'; prior='4'; type='DD'; num=525; output; month=1; code='CC1111111'; text='ccc'; prior='4'; type='EE'; num=125; output; month=2; code='BB1111111'; text='bbb'; prior='4'; type='AA'; num=4; output; month=2; code='CC1111111'; text='ccc'; prior='4'; type='CC'; num=5321; output; month=2; code='CC1111111'; text='ccc'; prior='4'; type='DD'; num=256; output; month=2; code='CC1111111'; text='ccc'; prior='4'; type='EE'; num=151; output; month=3; code='BB1111111'; text='bbb'; prior='4'; type='AA'; num=12; output; month=3; code='CC1111111'; text='ccc'; prior='4'; type='CC'; num=2860; output; month=3; code='CC1111111'; text='ccc'; prior='4'; type='DD'; num=655; output; month=3; code='CC1111111'; text='ccc'; prior='4'; type='EE'; num=62; output; month=4; code='AA1111111'; text='aaa'; prior='2'; type='AA'; num=2; output; month=4; code='BB1111111'; text='bbb'; prior='4'; type='AA'; num=12; output; month=4; code='CC1111111'; text='ccc'; prior='4'; type='CC'; num=1962; output; month=4; code='CC1111111'; text='ccc'; prior='4'; type='DD'; num=865; output; month=4; code='CC1111111'; text='ccc'; prior='4'; type='EE'; num=112; output; run; PROC SORT DATA=have(KEEP= month num code text prior type) OUT=sorted ; BY code text prior type; RUN; PROC TRANSPOSE DATA=sorted OUT=want(LABEL="Transposed WORK.WANT") NAME=Source LABEL=Label ; BY code text prior type ; ID month ; VAR num; RUN; QUIT; and get the result: code text prior type Source 4 1 2 3 AA1111111 aaa 2 AA num 2 AA1111111 aaa 2 BB num 4 BB1111111 bbb 4 AA num 12 8 4 12 BB1111111 bbb 4 BB num 1 CC1111111 ccc 4 CC num 1962 5134 5321 2860 CC1111111 ccc 4 DD num 865 525 256 655 CC1111111 ccc 4 EE num 112 125 151 62 but I need it in the next order and with total: code text prior type Source 1 2 3 4 Total AA1111111 aaa 2 AA num 2 2 AA1111111 aaa 2 BB num 4 4 BB1111111 bbb 4 AA num 8 4 12 12 36 BB1111111 bbb 4 BB num 1 1 CC1111111 ccc 4 CC num 5134 5321 2860 1962 15277 CC1111111 ccc 4 DD num 525 256 655 865 2301 CC1111111 ccc 4 EE num 125 151 62 112 450 Each month the number of columns will change from 1 to 12 and should be in the order from 1 to 12 (from left to right) and total should be calculated for filled months. Can you help me please?

J_J_J · ‎03-08-2021

Ksharp, thank you very much!👍 It works!

J_J_J · ‎03-08-2021

Ksharp, something goes wrong with this code. data have; input id $ key $ date datetime18.; format date datetime18. ; cards; A 11111111 31Oct2019 10:50:42 A 22222222 31Oct2019 10:51:17 A 22222222 02Mar2020 15:12:33 B 33333333 16Mar2020 12:23:46 A 44444444 25Mar2020 13:02:00 A 55555555 27Mar2020 13:20:07 A 66666666 27Mar2020 13:35:35 B 22222222 30Mar2020 10:49:35 A 33333333 30Apr2020 16:09:14 A 22222222 12Jun2020 15:32:04 A 66666666 12Jun2020 16:42:03 A 33333333 19Aug2020 9:16:55 A 33333333 18Sep2020 9:40:37 B 44444444 01Oct2020 8:56:40 A 11111111 12Oct2020 12:32:40 A 11111111 09Nov2020 14:19:16 B 33333333 17Nov2020 9:31:58 B 66666666 20Nov2020 14:26:29 A 66666666 26Feb2021 11:44:59 ; run; data a b; set have; if id='A' then output a; else output b; run; data want; if _n_=1 then do; if 0 then set b(rename=(date=n_dtstamp)); declare hash h(dataset:'b(rename=(date=n_dtstamp))'); h.definekey('key'); h.definedata('n_dtstamp'); h.definedone(); end; set a; call missing(n_dtstamp); rc=h.find(); drop rc; run; Expected result is: id key date n_dtstamp A 11111111 31Oct2019 10:50:42 A 22222222 31Oct2019 10:51:17 30Mar2020 10:49:35 A 22222222 02Mar2020 15:12:33 B 33333333 16Mar2020 12:23:46 A 44444444 25Mar2020 13:02:00 01Oct2020 8:56:40 A 55555555 27Mar2020 13:20:07 A 66666666 27Mar2020 13:35:35 20Nov2020 14:26:29 A 33333333 30Apr2020 16:09:14 17Nov2020 9:31:58 A 22222222 12Jun2020 15:32:04 A 66666666 12Jun2020 16:42:03 A 33333333 19Aug2020 9:16:55 A 33333333 18Sep2020 9:40:37 A 11111111 12Oct2020 12:32:40 A 11111111 09Nov2020 14:19:16 A 66666666 26Feb2021 11:44:59 But I get: id key n_dtstamp date A 11111111 31Oct2019 10:50:42 A 22222222 30Mar2020 10:49:35 31Oct2019 10:51:17 A 22222222 30Mar2020 10:49:35 02Mar2020 15:12:33 A 44444444 01Oct2020 8:56:40 25Mar2020 13:02:00 A 55555555 27Mar2020 13:20:07 A 66666666 20Nov2020 14:26:29 27Mar2020 13:35:35 A 33333333 16Mar2020 12:23:46 30Apr2020 16:09:14 A 22222222 30Mar2020 10:49:35 12Jun2020 15:32:04 A 66666666 20Nov2020 14:26:29 12Jun2020 16:42:03 A 33333333 16Mar2020 12:23:46 19Aug2020 9:16:55 A 33333333 16Mar2020 12:23:46 18Sep2020 9:40:37 A 11111111 12Oct2020 12:32:40 A 11111111 09Nov2020 14:19:16 A 66666666 20Nov2020 14:26:29 26Feb2021 11:44:59

J_J_J · ‎03-05-2021

Could you help me to do it with a key please? data have; input id $ key $ date datetime18.; format date datetime18. ; cards; ID key date A 4129 21Jan2021 15:31:53 A 5951 21Jan2021 15:33:13 A 1093 27Jan2021 13:04:08 A 5794 04Feb2021 16:25:07 A 6095 04Feb2021 16:26:41 B 5794 12Feb2021 14:55:57 B 6095 15Feb2021 8:19:39 A 1031 15Feb2021 14:08:23 A 2166 26Feb2021 11:44:59 ; run; Expected result: key datea dateb 4129 21Jan2021 15:31:53 5951 21Jan2021 15:33:13 1093 27Jan2021 13:04:08 5794 04Feb2021 16:25:07 12Feb2021 14:55:57 6095 04Feb2021 16:26:41 15Feb2021 8:19:39 1031 15Feb2021 14:08:23 2166 26Feb2021 11:44:59

J_J_J · ‎03-04-2021

mkeintz, thank you very much!

J_J_J · ‎03-04-2021

I'll try to explain other way. How to select next latest than group_id date from table B for each group_id from table A, provided that this date wasn't used for the previous group? Group_id and evnt_d are in chronological order. data A; input group_id$21.; cards; 05Mar2020 13:02:00 16Mar2020 14:26:17 19Mar2020 14:01:21 20Mar2020 18:01:21 28Mar2020 10:42:16 ; run; data B; input evnt_d$21.; cards; B 06Mar2020 13:45:11 B 08Mar2020 13:15:42 B 14Mar2020 12:36:22 B 23Mar2020 8:56:01 B 27Mar2020 8:56:40 B 29Mar2020 10:42:16 ; run; Expected result: A 05Mar2020 13:02:00 06Mar2020 13:45:11 A 16Mar2020 14:26:17 23Mar2020 8:56:01 A 19Mar2020 14:01:21 27Mar2020 8:56:40 A 20Mar2020 18:01:21 29Mar2020 10:42:16 A 28Mar2020 10:42:16

J_J_J · ‎03-03-2021

data want; input id$ evnt_d$21.; cards; A 05Mar2020 13:02:00 B 06Mar2020 13:45:11 B 08Mar2020 13:15:42 B 14Mar2020 12:36:22 A 16Mar2020 14:26:17 A 19Mar2020 14:01:21 A 20Mar2020 18:01:21 B 23Mar2020 8:56:01 B 27Mar2020 8:56:40 A 28Mar2020 10:42:16 B 29Mar2020 10:42:16 ; run; Expected result: A 05Mar2020 13:02:00 06Mar2020 13:45:11 A 16Mar2020 14:26:17 23Mar2020 8:56:01 A 19Mar2020 14:01:21 27Mar2020 8:56:40 A 20Mar2020 18:01:21 29Mar2020 10:42:16 A 28Mar2020 10:42:16

J_J_J · ‎03-03-2021

Data: data want;1 input id evnt_d;2 datalines; 3 A 05Mar2020 13:02:00 B 06Mar2020 13:45:11 B 08Mar2020 13:15:42 B 14Mar2020 12:36:22 A 16Mar2020 14:26:17 A 19Mar2020 14:01:21 A 20Mar2020 18:01:21 B 23Mar2020 8:56:01 B 27Mar2020 8:56:40 A 28Mar2020 10:42:16 B 29Mar2020 10:42:16 ; 3 Expected result: A 05Mar2020 13:02:00 06Mar2020 13:45:11 A 16Mar2020 14:26:17 23Mar2020 8:56:01 A 19Mar2020 14:01:21 27Mar2020 8:56:40 A 20Mar2020 18:01:21 29Mar2020 10:42:16 A 28Mar2020 10:42:16

J_J_J · ‎03-03-2021

Hi guys! Help me please to solve the problem. I try to find score. ID=A gives 1 point, ID=B minus 1 point, but it should be in chronological order, like in attached file. How is it possible to solve it? The result for code 111 should be 1 point. Thanks in advance.

J_J_J · ‎06-30-2020

Thanks, Tom. Your solution seems good too.

J_J_J · ‎06-30-2020

Thanks a lot, novinosrin!

Online Status	Offline
Date Last Visited	‎07-19-2023 12:37 PM

Re: Rank variables by group

Rank variables by group

Re: Convert my format to numeric

Convert my format to numeric

Re: space as thousands separator

Re: space as thousands separator

space as thousands separator

Re: The character is followed by 7 digits

Re: The character is followed by 7 digits

The character is followed by 7 digits

Re: day, month and year extraction

Re: consecutive numbers in to one column, and the rest characters in t...

Re: How to combine year and month columns into one column

Re: Reordering columns after PROC TRANSPOSE

Re: searching for the next not repetitive date

result comparing to previous month

Re: consecutive numbers in to one column, and the rest characters in t...

consecutive numbers in to one column, and the rest characters in the o...

Re: How to combine year and month columns into one column

Re: Reordering columns after PROC TRANSPOSE

Reordering columns after PROC TRANSPOSE

Re: searching for the next not repetitive date

Re: searching for the next not repetitive date

Re: searching for the next not repetitive date

Re: searching for the next not repetitive date

Re: searching for the next not repetitive date

Re: searching for the next not repetitive date

Re: searching for the next not repetitive date

searching for the next not repetitive date

Re: Find numeric values in character

Re: Find numeric values in character