Hi,    I have a 2 dataset. Let's say A and B. In which A data set contains only 1 variables (num_var) containing all numeric variables names (5 variable) of B data set. On the other hand B data set contains 15 variables out of which 5 variable are numeric and 10 are character.  So all these 5 variables are listed in A dataset.   Now i need to create a macro which trigger to change all those listed in A data set (5 variable) to character for the B dataset.   Let me know if you need any clarification.    Regards,  Ganesh K      ... View more

Hi,   I have data set Category Code aaa 202020201 aaa 20202 bbb 450011111 bbb 45001 bbb 450011111 cc 466667777 cc 46666 dd 333332221 dd 33333 ee 45616 ee 232324343 ee 456166661   What i want is:   Category Code aaa 202020201 aaa 202020201 bbb 450011111 bbb 450011111 bbb 450011111 cc 466667777 cc 466667777 dd 333332221 dd 333332221 ee 456166661 ee 232324343 ee 456166661   Thanks, Ganesh K ... View more

Hi,   I have table as shown below,    Id Date Category Price 1 1/1/2001 Jam 12 2 1/2/2001 Jam   3 1/3/2001 Jam   4 1/4/2001 Glocose 13 5 1/5/2001 Jam 15 6 1/6/2001 Jam   7 1/7/2001 Glocose 16 8 1/8/2001 Glocose   9 1/9/2001 Glocose     need to fill missing value as show below:   Id Date Category Price 1 1/1/2001 Jam 12 2 1/2/2001 Jam 12 3 1/3/2001 Jam 12 4 1/4/2001 Glocose 13 5 1/5/2001 Jam 15 6 1/6/2001 Jam 15 7 1/7/2001 Glocose 16 8 1/8/2001 Glocose 16 9 1/9/2001 Glocose 16   ... View more

Hi all,   Scenario 1: I have only 2 years (2015, 2016) with start and end dates in data set. Start End 201511 201610   Now based on above data set is basically range with 2 date (start & End) need to split according to year & month as shown in below table: S: start date E: Ending date of that year S1: continuity of year start E1: Ending of study date. Start End S E S1 E1 201511 201610 201511 201512 201601 201610   Scenario 2: I have only 3 years (2015, 2016, and 2017) with start and end dates in data set. Start End 201511 201703   Now based on above data set is basically range with 2 date (start & End) need to split according to year & month as shown in below data set table: S: start date E: Ending date of that year S1: continuity of year start E1: Ending date of that year S2: continuity of year start E2: Ending of study date.   Start End S E S1 E1 S2 E2 201511 201610 201511 201512 201601 201612 201701 201703   How to create this data set?   Thanks, Ganesh K ... View more

Hi,   I have a data as shown in below table:   ID Group Subgroup 101 A AB 102 A CD 103 A EF 101 A GH 104 A IJ 102 A KL 501 B MN 521 B OP 531 B QR 501 B ST 531 B UV 540 B WX   From the above table i need to obtain Summary based on Group wise and Subgroup wise. Note: Within in the group there must be unique Id on overall. EX:101 ID is present in both "AB" and "GH" Subgroup in Group "A". In this case we need to consider only "AB" Subgroup and the other one "GH" can be 0   ID Group Subgroup 101 A AB 102 A CD 103 A EF 0 A GH 104 A IJ 0 A KL 501 B MN 521 B OP 531 B QR 0 B ST 0 B UV 540 B WX   Kindly note: ID 101 can be more than twice among the group.   Thanks, Ganesh K ... View more

Hi All,   I assigned library name for SQL DB as shown below:   Libname SQLDB ORACLE user=ABCD pass=1234 Path="SCHEMA_123" insertbuff=50000 dbcommit=50000 schema=1234   If i run any SQL part of code to create table in that library, connectivity is getting diconnected. so abnormal termination happens with limited observation.   so i removed insertbuff=50000 and processed,   Libname SQLDB ORACLE user=ABCD pass=1234 Path="SCHEMA_123" dbcommit=50000 schema=1234   now connectivity is good but computation time is more than a day its taking to create table.   Please suggest to compute efficiently.    Thanks, Ganesh K ... View more