Hi, I would like to add a new column that will compare my 2 first columns and say if Yes or No the value are the same. I have some problem with those values, because they are the same, but with some little difference. I would like those values to say Yes in my new column. M. Jaques Richard Jaques Richard DominiqueBlais Dominique Blais J. R Paquin J R Paquin Bertrand Raymond Raymond Bertrand Difference in row 1: M. Difference in row 2: space Difference in row 3: doth Difference in row 4: inverse name Thank you for your help and time. ... View more

Hi, I have a SAS EG 4.1 project that I would like to run monthly as a scheduled job. I tries using tools > schedule project and scheduling a vbs script. For some reason the script is run by Windows, but the project is not run in SAS EG. Below is the content of the script. Could you please help me schedule an automatic job. Thank you.   Option Explicit Dim app Call dowork 'shut down the app If not (app Is Nothing) Then app.Quit Set app = Nothing End If 　 Sub dowork() On Error Resume Next '---- ' Start up Enterprise Guide using the project name '---- Dim prjName Dim prjObject prjName = "C:\P2P v3.egp" 'Project Name Set app = CreateObject("SASEGObjectModel.Application.4") If Checkerror("CreateObject") = True Then Exit Sub End If '----- ' open the project '----- Set prjObject = app.Open(prjName,"") If Checkerror("app.Open") = True Then Exit Sub End If '----- ' run the project '----- prjObject.run If Checkerror("Project.run") = True Then Exit Sub End If '----- ' Save the new project '----- prjObject.Save If Checkerror("Project.Save") = True Then Exit Sub End If '----- ' Close the project '----- prjObject.Close If Checkerror("Project.Close") = True Then Exit Sub End If End Sub Function Checkerror(fnName) Checkerror = False Dim strmsg Dim errNum If Err.Number <> 0 Then strmsg = "Error #" & Hex(Err.Number) & vbCrLf & "In Function " & fnName & vbCrLf & Err.Description 'MsgBox strmsg 'Uncomment this line if you want to be notified via MessageBox of Errors in the script. Checkerror = True End If End Function ... View more