How to catch sas error codes \ description in powershell?

lamp_1234 — Thu, 29 Feb 2024 12:53:38 GMT

In a project named "Test.egp", there is a program called "missing_var" with the following code:

proc means data=sashelp.class;
	class sex;
	var wieght;
run;
%put &syserr;

The value of &syserr when running the code is 3000.

I need to get this value of 3000 in PowerShell when running the project.

$proj_full_path = "test.egp"                
$eg_guide_app = New-Object -comObject SASEGObjectModel.Application.8.1
$current_project = $eg_guide_app.Open($proj_full_path, "")
try{
    $current_project.run
}
catch{
    $err_num = ??? #(5000)
}
$current_project.Close()
$eg_guide_app.Quit()

Thanks

Re: How to catch sas error codes \ description in powershell?

ChrisHemedinger — Thu, 29 Feb 2024 19:28:37 GMT

@lamp_1234 EG won't return any SAS error codes or log content directly in the script. To accomplish this, you will need to enhance your script to get the .Log object from the Code item that runs this PROC MEANS. Then you'll have to use PowerShell to scan the Log (a text object) for the error message/code you're looking for.

You'll need to add quite a bit of logic, and you can find some examples here:

topic How to catch sas error codes \ description in powershell? in SAS Enterprise Guide

How to catch sas error codes \ description in powershell?

Re: How to catch sas error codes \ description in powershell?