topic Re: vba go to in sas in SAS Programming

vba go to in sas

Srigyan — Tue, 30 Jul 2019 12:35:18 GMT

I am writing an automated SAS process where

It checks teradata first and if the data is available in the table then only run the code in program otherwise it jump on a given location like in VBA.

if <condition>=true then do:

process:

else goto gg:



statement,,,

statement,,,

statement,,,

statement,,,statement,,,



gg:

code resume from here

do we have same thing in SAS...

Re: vba go to in sas

Kurt_Bremser — Tue, 30 Jul 2019 12:40:38 GMT

Since 9.4M5 we can use %if in open code (outside a macro):

%let flag=0;

%if &flag %then %do;

proc print data=sashelp.class;
run;

%end;

Re: vba go to in sas

Srigyan — Tue, 30 Jul 2019 13:21:28 GMT

My Current version: 9.04.01M3P062415.

Will it work here or do we have any other alternative

Re: vba go to in sas

Kurt_Bremser — Tue, 30 Jul 2019 13:24:35 GMT

If %if %then %do does not work in open code, you need to pack all code you want to run conditionally into a macro, so you can use %if there.