Thank you ... View more

READBUFF (as @Ksharp shows in his example) is the only option I know about that could affect performance in the data transfer from Oracle. BULKOAD does not help here, it helps you when you want to load Oracle tables. So again, network bandwidth, and Oracle query performance is the two other areas you can look into. ... View more

Hi, can you please explain how you resolved this issue. Thanks ... View more

@kuppusamy wrote: In report col lead generated instead of  "Total OCC A&C" , I want "Total Digital" But In a program how to edit the macro variables to get "Total Digital". Please do not post pictures of CODE or Log results. Copy from the text from the editor or Log and paste into a code box opened on the forum using the {I} or "running man" icons. One issue with your specific image is that you have code that runs past the margins of the image. So we don't even have the complete code that you attempted to show.   If you are using macro variables, ensure to include the place that you set the variables as well as how you are attempting to use them.   Also post complete procedure code not just snippets from the middle of a procedure. From the partial code you show we cannot tell: 1) which variable or column you are referencing 2) what the current label might be for the variable (likely default value in a column heading) 3) why you think you need any macro variable to set a heading: the define statement will do that without any macro code needed 4) what you may have attempted that would have changed the displayed heading ... View more

You do not provide any information so its impossible to provide any constructive feedback.  Can SAS access the area, is it network attached?  If not, do you SFTP the files?  Can the SFTP program run scripts?   Can you access command line?  Can you script in VB?  Simplest method would be to have a small VB script which runs, SFTP's the files over, and unzips them into a folder ready for SAS to import. ... View more

@kuppusamy wrote: i modified to distinct party_rk. it is not working.......can you edit above code.. I can't test anything, as I do not have Oracle, I only have SAS and google 😉 . I suggest you get hold of one of your local Oracle DBA's to check your code. ... View more

Thank you for your response,     that error is because of risk assessment process(its completed with wrong input). now i rectified that and process running smoothly... ... View more

@kuppusamy,   Are you sure you have no duplicates for that entry? Try to delete it and run the autoload process once again. ... View more