About hk2013

hk2013 · ‎06-29-2018

result would look like this ID Date total Predicted diff 1 6/18/20 200 230 -30 2 5/22/18 160 170 -10 3 5/4/18 300 425 -125

hk2013 · ‎06-29-2018

data one; input ID Date total predicted; cards; 1 6/24/18 200 250 1 6/30/18 200 270 1 6/18/20 200 230 2 5/24/18 160 200 2 5/27/18 160 210 2 5/22/18 160 170 3 5/20/18 300 450 3 5/14/18 300 400 3 5/4/18 300 425 ; i want to pick the first date for each ID and subtract that date and IDs Predicted from Total

hk2013 · ‎06-29-2018

sorry yeah i meant count of the cust_id

hk2013 · ‎06-29-2018

I have two data sets with IDs and Cust_id data_1 is my main data set its a snapshot of our customer list at the start of the year and i want to compare to data_2 which is updated monthly. Data_2 might have new cust_id added over the time but I dont want to look at those. Data_1 : data at start of year ID Cust_id 1 111 1 222 1 333 1 444 2 555 2 666 2 777 2 888 3 999 3 1000 3 1001 3 1002 Data_2 ID Cust_id 1 111 1 222 1 1110 1 5786 2 555 2 8989 2 0986 3 999 Want: Compare Data_1 to Data_2 and only keep cust_ids in data_2 that are also in Data_1 and than get the diff New_Data_2 ID Cust_id difference 1 111 2 1 222 2 2 555 3 3 999 3 difference = count(data_1.Cust_id) -count(data_2.Cust_id)

hk2013 · ‎06-19-2018

I just realize that this is giving me every day of the week but i only want first day of the weeks so that target_to_hit_per_week is added ones a week not daily. or is there a way that it can give it daily but target_to_hit_per_week is only added once a week.

hk2013 · ‎06-19-2018

i have 4 columns in my data set 1: todays date 2: ID 3: member_visit 4: target to hit every week Date ID Member_visit target_to_hit_per_week 19jun2018 1 230 20 19jun2018 2 357 10 19jun2018 3 100 40 19jun2018 4 444 5 19jun2018 5 159 30 19jun2018 6 300 11 what I want add next 16 weekly dates and what the total be if the IDs hit their weekly total Example: ID future_date future_total 1 25JUN2018 230+20 = 250 1 02JUL2018 250+20 = 270 1 09JUL2018 270+20 = 290 1 16JUL2018 290+20=310 1 23JUL2018 1 1 1

hk2013 · ‎06-18-2018

how would i count distinct ID that are that have appointments after the next 28 days from today ID appt_date 1 6/30/2018 1 7/7/2018 1 7/18/2018 1 7/28/2018 1 8/6/2018 1 9/20/2017 2 6/17/2018 2 6/28/2018 2 7/5/2018 2 7/6/2018 want ID 1 has 4 appt after 28 days ID 2 has 0 appt after 28 days

hk2013 · ‎05-11-2018

I have tried that but it doesn’t seem to work. The transpose give data as column1,column2... And I have tried x=catx(' ‘,of column:); but it does not work.

hk2013 · ‎05-11-2018

I just proc transposed my data and its giving me Column1 to ColumnX and the x number will keep changing how do i do a Catx( ) calculation when i dont know the number of columns

hk2013 · ‎05-11-2018

I have a data set that has ID, Metric, score and month but i am noticing some the ids data for month here or there for certain metrics what i have: id Metric month score 1 a 1 .9 1 b 1 .9 1 c 1 .8 1 d 1 .8 1 a 2 .7 1 c 2 .8 1 d 2 .8 1 b 3 .9 1 c 3 .6 1 d 3 .6 out put i want id Metric month score 1 a 1 .9 1 b 1 .9 1 c 1 .8 1 d 1 .8 1 a 2 .7 1 b 2 0 1 c 2 .8 1 d 2 .8 1 a 3 0 1 b 3 .9 1 c 3 .6 1 d 3 .6

hk2013 · ‎04-25-2018

would it be possible to tell if the encounter happened on the same day but with a different reps for example in data1 ID 1 has encounter on 7jan2018 with sam but in data2 ID1 has encounter on 7jan2018 with sam and bob and i want that to equal to 1 as seen? data Data1; input id date :date9. reps; format date date9.; datalines;1 07JAN2018 sam 2 28MAR2018 bob 3 14FEB2018 sally; data Data2; input id date :date9.reps; format date date9.; datalines; 1 07JAN2018 sam 1 07JAN2018 bob 1 14FEB2018 sally 2 28MAR2018 sam 2 04APR2018 bob 2 17APR2018 sally 3 14FEB2018 sam 3 18FEB2018 bob 3 27MAR2018 sally ;

hk2013 · ‎04-25-2018

i have two data sets data1 has one date for one ID and data2 has all the encounters dates for the ID's. What I want is to check if IDs in data1 had any encounters dates within 7 days in data2 and if they did create a new colunm that states 1 for yes and 0 for no. data Data1; input id date :date9.; format date date9.; datalines;1 07JAN2018 2 28MAR2018 3 14FEB2018; data Data2; input id date :date9.; format date date9.; datalines; 1 07JAN2018 1 17JAN2018 1 14FEB2018 2 28MAR2018 2 04APR2018 2 17APR2018 3 14FEB2018 3 18FEB2018 3 27MAR2018 ; output : ID Date SEEN 1 07JAN2018 0 2 28MAR2018 1 3 14FEB2018 1

hk2013 · ‎04-24-2018

output example is included i just want a col that if there is a next date within 14 days it says yes or no

hk2013 · ‎04-24-2018

I have a id and date column and I want to find out if the id had a second within 2 weeks(14 days); id date 1 07JAN2018 2 28MAR2018 3 14FEB2018 1 28JAN2018 2 11APR2018 3 24FEB2018 .. .. .. OUTPUT: id date SEEN within 2 weeks(14 days from the first date) 1 07JAN2018 No 2 28MAR2018 yes 3 14FEB2018 yes 1 28JAN2018 . 2 11APR2018 . 3 24FEB2018 . .

hk2013 · ‎04-02-2018

I have date in DDMMYYYY (29mar2018) format and i want to convert it to MMM-YYYY (Mar-2018)

Online Status	Offline
Date Last Visited	‎05-12-2022 04:35 PM

Need help with do look

Read in the last 3 files from folder SAS EG

create dates based on columns

Keeping columns for the last 12 months

Re: Subtracting rows

Re: Subtracting rows

Subtracting rows

Re: Repeating numbers in cell

Re: Repeating numbers in cell

Repeating numbers in cell

Re: create dates based on columns

Re: create date and sum

How do I sum values from prevs value

Re: find first id and date

find first id and date

Re: Deleted and take the difference

Deleted and take the difference

Re: create date and sum

create date and sum

Sum anything past 28 day from today

Re: cat or catx unknow number of columns

cat or catx unknow number of columns

add zero for missing value

Re: merge data and check it there is data with in 7 days

merge data and check it there is data with in 7 days

Re: Date within two weeks

Date within two weeks

convert date