@Kurt_Bremser already gave you the answer to that - Use File Save As after opening the project. ... View more

Hi @Hema_12, Are you facing this issue recently? The timestamp of the log seems to be old. Can you long list the job using -l flag with bjobs and check if any info on why the job is waiting displayed? ... View more

@SASKiwi wrote: @Hema_12  - Another possibility is if you are defining these libnames in SMC and stored in SAS metadata they need to be pre-assigned to work in SAS batch jobs. This is likely not the issue because if using SAS DI then the code generated will include an explicit libname statement for any library used but not pre-assigned. It would only become an issue if a metadata library definition gets change to not pre-assigned after job deployment (scheduling). ... View more

Thanks for the help.   I appreciate your solution and i know this trick but for repeated work, I should not use your solutions. 😉    ... View more

To get information of a prior job, it has to leave something behind that you can use, eg a SAS log. Or you wrap your SAS batch jobs in a script that keeps track of all jobs that were run with it. ... View more

@Hema_12 wrote: Hi Paige,   Thank you so much for your solution.But I  already achieved the deletion of rows. it deleted the rows which are older than 10 days but not setting the id again from 1.  i need to alter the id from 1 after deletion the rows. It's not clear to me what this means. The code I provided gives ID number from 1 to 11 in the output data set, just as your example shows. If that's not what it does, then please explain further, and show us the code you used, and show us the results that are not what you want. ... View more

1. Use the {i} icon or the running man to post log or code.    This avoids issues like smileys. 2. Are you updating Teradata or a WORK data set? 3. What variable do you increment and why and when?   There is no where condition on your SET statement 4. Since you seem to be driving the process from a data step,    call execute() might be better suited than macros. 5. You can use the exist() function to test that a table exists and avoid error messages 6. Changing the thread title to something more relevant than "sas eg" 7. Loaded not loeaded 🙂 ... View more

Just use the wanted format: options locale=Fi_Fi; data one; a='30. heinäkuuta 2018 09:52:06'; b=strip(substr(a,1,(length(a)-8))); c=input(b,nldate20.); d=c; format c yymmddd10. d date9.; run; proc print data=one noobs; run; Result: a b c d 30. heinäkuuta 2018 09:52:06 30. heinäkuuta 2018 2018-07-30 30JUL2018 Which format you use, or if any format at all, depends on what you want to do later on. If you need the date later on for reference in a where or similar, a format is not needed: data one; a='30. heinäkuuta 2018 09:52:06'; b=strip(substr(a,1,(length(a)-8))); c=input(b,nldate20.); call symput('c',put(c,best.)); run; %put c=&c.; data have; /* build some example data */ format date yymmddd10.; do date = today() - 10 to today() + 10; output; end; run; data want; /* select from example */ set have; where date le &c.; run; ... View more