Data have; String1='aaaaa*bbbb*ddddddd@jjjjjj'; Output; String2='&aaaa*ggggghgg####'; Output; Run; How to replace special symbols by space ... View more

Data ex1; Input number ; Cards; 3 9 22 34 49 3 33 50 12 23 34 48 ; If we take range 50 how to create sequence number 50 group wise like see below Number seq 3. 1 9. 1 22. 1 34. 1 49. 1 3. 2 33. 2 50. 2 12. 3 23. 3 34. 3 48. 3 ; ... View more

I have one value 234782617327.23456 How to write informat and format for above value ... View more

I have one dataset like see below data have ; input number ; cards ; 2  4 4 8 2 7 9 5 7 ;   How to sum upto 20 and again start with record value like see below example number                   sum 2                               2 4                               6 4                               10 8                                18 2                                20 7                                7------------------------again start with record value 9                                16 5                                 5----------------------again start with record value 7                                 12 ; ... View more

i will give one example they are 36 files equally give to 6 employees in on office see below example id     office    file_name 101 office1    file1 101 office1    file2  101 office1    file3 101 office1    file4 101 office1    file5 101 office1    file6 102 office1    file17 ...................... 106 office1    file36     How to write coding? ... View more

data have ; input id group$ ; cards ; 101  group1 102 group1 103 group1 104 group2 105 group2 106 group2 ; 1)Group1 has 88 files  2)Group2 has 99 files How to share files each group equally  like see below   101 group1 file1  101 group1 file2 .................. 106 group2 file99 ... View more

Data ex; Name='sas community software'; Run; How to do like see below New_name='sa.s . Co.mm.un.it.y .so.ft.wa.re' ... View more