BookmarkSubscribeRSS Feed
CG1
Calcite | Level 5 CG1
Calcite | Level 5

Hi All,

 

I am SAS learner, so please help me on below issue.

 

I am scheduling one job in SAS. Please suggest where I am doing mistake.

 

Step 1:- Create a batch file with below code

       "K:\Program Files\SAS\SASFoundation\9.4\sas.exe" –SYSIN
       "L:\SASCode\sasprog.sas"

 

my SAS program which is shared in L drive

 

libname ACB1 'L:\SASCode';
libname mydblib2 oracle user=Scott password=A12345 path=TST1 schema=CAMP;
data ACB1.print_profile ;
keep prod_id pabbr individual_id last_order_dt last_role LAST_ORDER_MEDIUM;
merge mydblib2.pub_prod (in=a)
mydblib2.product (in=b);
by prod_id;
if (a and b) and pub_status='A';
run;

 

after this I am scheduling .bat file in Task scheduler but when it execute automatciaaly it open the command prompt window and also SAS universell viewer but did not execute the code.

 

Please suggest 

1 REPLY 1
SASKiwi
PROC Star

Try testing your SAS command by running: "K:\Program Files\SAS\SASFoundation\9.4\sas.exe" from the Windows command prompt.

 

It should open a SAS Windows System session (program editor, Log, output etc).

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1176 views
  • 0 likes
  • 2 in conversation