Treat as numaric and use round function as shown below, if it is character then use input function data have; input Field_1 ; Field2=round(Field_1, .01); datalines; 22.5 1.000 40.000 1.25 ; Run; ... View more

@RW9 I got correct answer for your  code thanks for spending your time on this question   thanx Rajkumar ... View more

I got correct answer for this code thanks for spending your time on this question ... View more

@Patrick My clarification for your queries. 1. You've got a "large" source table with dates - right?   yes 2. You've got a reference table with dates which are holidays - yes 3. You want to add a column to your large source table which contains a count of remaining working days - yes i have a large dataset it contains 2 lack observations and around 150 variables. In this job date variables are there. in date variable date  count i want(31MAR2017-date) without repeating the count is correct but my values are repeating so my count is decreasing 1 for every repeating value,it effect to all other values,so i need to change code for your conformation a) All dates that are not in the holidays reference table - yes b) Count per month so last day of month gets always a count of zero - yes   thanks Rajkumar ... View more

@Patrick see patrick for your undersatand i sent you data  i got output for using below code data want (drop=hols); merge list (in=a) holidays (in=b rename=(date1=date)); by date; retain date_diff hols; if _n_=1 then hols=8; date_diff=('31mar2017'd - date) - hols; if b then hols=hols-1; if a then output; run; but if i use more holidays(in data 2017-2018) or  if i use same date for multiple times the correct output will not come  and some members confuses about data so i use same data for two-three times ... View more

hi the   variable is numeric so use formate option   DATA test_data1; input studyid ; format studyid z8.; cards; 543 243 15967 26484143651 5442 124 1 23 4423 ; run; formate zw.   w means total how many digits you want with zeros ... View more

input data data list; input name$ date; informat date date9.; format date date9.; datalines; abc 1MAR2017 ab2 2MAR2017 ab3 3MAR2017 ab4 4MAR2017 ab5 5MAR2017 ab6 6MAR2017 ab7 7MAR2017 ab8 8MAR2017 ab9 9MAR2017 ab10 10MAR2017 ab11 11MAR2017 ab12 12MAR2017 ab1a 12MAR2017 ab1B 12MAR2017 ab1c 12MAR2017 ab13 13MAR2017 ab14 14MAR2017 ab15 15MAR2017 ab16 16MAR2017 ab17 17MAR2017 ab18 18MAR2017 ab19 19MAR2017 ab20 20MAR2017 ab2a 20MAR2017 ab2b 20MAR2017 ab2c 20MAR2017 ab2d 20MAR2017 ab21 21MAR2017 ab22 22MAR2017 ab23 23MAR2017 ab24 24MAR2017 ab25 25MAR2017 ab26 26MAR2017 ab27 27MAR2017 ab28 28MAR2017 ab29 29MAR2017 ab30 30MAR2017 ab31 31MAR2017 ; run; Holidays list   data holidays; input date1 date9.; informat date1 date9.; format date1 date9.; datalines; 05MAR2017 11MAR2017 12MAR2017 15MAR2017 19MAR2017 20MAR2017 21MAR2017 22MAR2017 24MAR2017 25MAR2017 26MAR2017 02APR2017 04APR2017 08APR2017 09APR2017 14APR2017 16APR2017 22APR2017 23APR2017 30APR2017 07MAY2017 14MAY2017 21MAY2017 28MAY2017 04JUN2017 11JUN2017 18JUN2017 25JUN2017 02JUL2017 09JUL2017 16JUL2017 23JUL2017 30JUL2017 06AUG2017 13AUG2017 20AUG2017 27AUG2017 03SEP2017 10SEP2017 17SEP2017 24SEP2017 01OCT2017 08OCT2017 15OCT2017 22OCT2017 29OCT2017 05NOV2017 12NOV2017 19NOV2017 26NOV2017 03DEC2017 10DEC2017 17DEC2017 24DEC2017 31DEC2017 07JAN2018 14JAN2018 21JAN2018 26JAN2018 28JAN2018 04FEB2018 11FEB2018 18FEB2018 25FEB2018 04MAR2018 11MAR2018 run; my condition is date_diff="31MAR2017"d-date;(in list dataset) and use holidays data for exclude holidays. I want output like this: NAME DATE Date_diff abc 1MAR2017 19 ab2 2MAR2017 18 ab3 3MAR2017 17 ab4 4MAR2017 16 ab5 5MAR2017 15 ab6 6MAR2017 15 ab7 7MAR2017 14 ab8 8MAR2017 13 ab9 9MAR2017 12 ab10 10MAR2017 11 ab11 11MAR2017 10 ab12 12MAR2017 10 ab1a 12MAR2017 10 ab1B 12MAR2017 10 ab1c 12MAR2017 10 ab13 13MAR2017 10 ab14 14MAR2017 9 ab15 15MAR2017 8 ab16 16MAR2017 8 ab17 17MAR2017 7 ab18 18MAR2017 6 ab19 19MAR2017 5 ab20 20MAR2017 5 ab2a 20MAR2017 5 ab2b 20MAR2017 5 ab2c 20MAR2017 5 ab2d 20MAR2017 5 ab21 21MAR2017 5 ab22 22MAR2017 5 ab23 23MAR2017 5 ab24 24MAR2017 4 ab25 25MAR2017 4 ab26 26MAR2017 4 ab27 27MAR2017 4 ab28 28MAR2017 3 ab29 29MAR2017 2 ab30 30MAR2017 1 ab31 31MAR2017 0 Kidly check   ... View more

in Banking sector 1st and 3rd and/or 5th saturday is working day 2nd and 4th saturday holiday how can i exclude  2nd and 4th saturday  and once recheck my input list,holiday list and output ... View more

but the count is wrong please check it and if i use same date multiple time it will not give correct count My input is data list; input name$ date; informat date date9.; format date date9.; datalines; abc 1MAR2017 ab2 2MAR2017 ab3 3MAR2017 ab4 4MAR2017 ab5 5MAR2017 ab6 6MAR2017 ab7 7MAR2017 ab8 8MAR2017 ab9 9MAR2017 ab10 10MAR2017 ab11 11MAR2017 ab12 12MAR2017 ab1a 12MAR2017 ab1B 12MAR2017 ab1c 12MAR2017 ab13 13MAR2017 ab14 14MAR2017 ab15 15MAR2017 ab16 16MAR2017 ab17 17MAR2017 ab18 18MAR2017 ab19 19MAR2017 ab20 20MAR2017 ab2a 20MAR2017 ab2b 20MAR2017 ab2c 20MAR2017 ab2d 20MAR2017 ab21 21MAR2017 ab22 22MAR2017 ab23 23MAR2017 ab24 24MAR2017 ab25 25MAR2017 ab26 26MAR2017 ab27 27MAR2017 ab28 28MAR2017 ab29 29MAR2017 ab30 30MAR2017 ab31 31MAR2017 ; run; and my holiday list is data holidays; input date1 date9.; informat date1 date9.; format date1 date9.; datalines; 05MAR2017 11MAR2017 12MAR2017 15MAR2017 19MAR2017 20MAR2017 21MAR2017 22MAR2017 24MAR2017 25MAR2017 26MAR2017 02APR2017 04APR2017 08APR2017 09APR2017 14APR2017 16APR2017 22APR2017 23APR2017 30APR2017 07MAY2017 14MAY2017 21MAY2017 28MAY2017 04JUN2017 11JUN2017 18JUN2017 25JUN2017 02JUL2017 09JUL2017 16JUL2017 23JUL2017 30JUL2017 06AUG2017 13AUG2017 20AUG2017 27AUG2017 03SEP2017 10SEP2017 17SEP2017 24SEP2017 01OCT2017 08OCT2017 15OCT2017 22OCT2017 29OCT2017 05NOV2017 12NOV2017 19NOV2017 26NOV2017 03DEC2017 10DEC2017 17DEC2017 24DEC2017 31DEC2017 07JAN2018 14JAN2018 21JAN2018 26JAN2018 28JAN2018 04FEB2018 11FEB2018 18FEB2018 25FEB2018 04MAR2018 11MAR2018 run; my condition is date_diff="31MAR2017"d-date;(in list dataset) and use holidays data for exclude holidays.     i want this output    ******************************************************* NAME DATE     Date_diff   abc 1MAR2017     19 ab2 2MAR2017     18 ab3 3MAR2017     17 ab4 4MAR2017     16 ab5 5MAR2017     15 ab6 6MAR2017     15 ab7 7MAR2017     14 ab8 8MAR2017     13 ab9 9MAR2017     12 ab10 10MAR2017   11 ab11 11MAR2017   10 ab12 12MAR2017   10 ab1a 12MAR2017   10 ab1B 12MAR2017   10 ab1c 12MAR2017   10 ab13 13MAR2017   10 ab14 14MAR2017   9 ab15 15MAR2017   8 ab16 16MAR2017   8 ab17 17MAR2017   7 ab18 18MAR2017   6 ab19 19MAR2017   5 ab20 20MAR2017   5 ab2a 20MAR2017   5 ab2b 20MAR2017   5 ab2c 20MAR2017   5 ab2d 20MAR2017   5 ab21 21MAR2017   5 ab22 22MAR2017   5 ab23 23MAR2017   5 ab24 24MAR2017   4 ab25 25MAR2017   4 ab26 26MAR2017   4 ab27 27MAR2017   4 ab28 28MAR2017   3 ab29 29MAR2017   2 ab30 30MAR2017   1 ab31 31MAR2017   0 ************************************ Thanks in advance.. ... View more