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).

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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