Hi frds, I have requirement to fill the missing dates with next month dates here is the example. I have dataset EMP_ID    KEY     Year    Month    Office    Date  101            1         2016      Jan       A       03JAN2016 101            2         2016      Feb        A     15FEB2016 101            3         2016       Mar       A       101            4         2016      Apr        A       101            5         2016       May      A      20MAY2016  101            6         2016       Jun       A       101            7         2016        Jul       A      101            8         2016       Aug      A     15AUG2016 101            9         2016       Sep      A       101           10        2016       Oct       A      101           11        2016      Nov       A      20NOV2016 I want the data to be like EMP_ID    KEY     Year    Month    Office    Date 101            1         2016      Jan       A       03JAN2016 101            2         2016      Feb        A     15FEB2016 101            3         2016       Mar       A      20MAY2016 101            4         2016      Apr        A      20MAY2016 101            5         2016       May      A      20MAY2016 101            6         2016       Jun       A     15AUG2016 101            7         2016        Jul       A     15AUG2016 101            8         2016       Aug      A     15AUG2016 101            9         2016       Sep      A      20NOV2016 101           10        2016       Oct       A     20NOV2016 101           11        2016      Nov       A      20NOV2016 Please help.. Thanks in advance. Vicks ... View more

Hi Techies, I came across a requirement to concatenate month and year and from that concat I have to get the previous month end. I tried with PUT(mdy(t1.MONTH_NUMBER, 1, t1.YEAR_WORKED),MMDDYY10.) and I am getting like 03/01/2016 if the month is MARCH and theYEAR is 2016, in this case. here is the data I am having Data having : YEAR_WORKED                    MONTH_NAME                                DATE_WANTED 2016                                        MARCH                                             28FEB2016 2016                                        APRIL                                                31MAR2016 2016                                        NOVEMBER                                      31OCT2016 2017                                         FEBRUARY                                       31JAN2017 2017                                        MARCH                                              28FEB2017 2018                                         APRIL                                                31MAR2018 2018                                         MAY                                                  30APR2018 2018                                         SEPTEMBER                                    31AUG2018 Really appreciate if some one Could please help me . Thanks, Vickys ... View more

Hi All, I am new to SAS DI, I know how to create jobs with transformations. But, I am not sure how can I make the Job flows. I have 12 Jobs which need to run concurrently and then after this 12 Jobs I have to run the two jobs sequentially. I am not sure how can I do that, appreciate if some one could provide some document or link to get some information please. Thanks, Vicks ... View more

Hi, Can some please help me t how to deal a csv file data like this in SAS DI. I tried with comma as delimiter while create a file through external wizard. When the file reader reads the data from the data file, its shows missing(.) for 2013 and 2014 data, as the collage has double quotes and has comma. But, my file reader code has following code, which makes sense in handling the double quotes.   infile '/*/*/test_data.csv' lrecl = 379 delimiter = ',' dsd missover firstobs = 2; ; File data-: year , dept, class, collage,total 2012, science, two, abc, 23 2012, maths, three, abc, 34 2013, science, four, "abc,xyz", 55 2013, social, five, "asd,jhg", 21 2014, maths, two, "qwe,lki", 37   Thanks, Vicks ... View more

Hi All,   I am facing problem to open the temp table created, after loading the data to extract transform. I used join transform which gets data from 5 source tables, after that two extracts and then append and then extract trasform. The last extract tranformation has 20 variables out of which 18 have case statements in expression builder. When I ran the job, the data gets loaded in 2-3 secs (as i filtered data), but when I tried to open the data loaded in temp table next to extract, its taking more than 2 mins for 5 records. When I opened the first 2 extracts temp tables they are opening in 2 secs. This opening of temp table is delaying the development work.   I havn't achanged any settings or options. I closed the application and tried again, but have same issue. It was working fine the day before this issue.   I appreciate if any one came across the same issue or have some solution near to that.   Thannks Vicks ... View more

Hi, I am new to SAS DI and seeking help from experience guys. I had a requiremnt to merge the two temporary tables coming from extract txn. There are 6 columns in common which have different data like below. dataset t1 A             B      C     D     E    F apple    fruit    23    0     25   0 mango  fruit     0    12     0   45 carrot   veg     0     52     0   23 tomato veg     3     0      16   0   dataset t2 A         B       C      D      E      F apple fruit     0      72     0     13 mango fruit   16    0      19     0 carrot veg     49    0     12      0 tomato veg   0      9       0      21 the resultant set Iam looking is A           B        C      D       E      F apple fruit       23     72      25    13 mango fruit     16     12      19    45 carrot veg       49     52      12    23 tomato veg      3      9        16    21   Thanks, ... View more