Hi,    We're using SAS 9.xxxx.   I'm on a Linux SYSTEM calling a SAS program from a cronfile.   That SAS program is passing arguments to a SAS program it's calling. I having a hard time passing values from one SAS program to another in this method.   Here are the line from each program.     In the cronfile the line looks like this:   17 * 18 10 * /usr/bin/bash;. ~/.bash_profile; cd /sasdata/mids_output02/rjs;sas -noterminal -rsasuser -batch -log cron_rpts.log -print cron_rpts.lst -sysparm "param1=2500,param2=2" cron_rpts.sas   Here are the effective lines from the program its calling.    %macro set_constants; %global param1 param2; %* Get param1 and param2 from sysparm. sysparmpairs does not deal well with quotes, so quote the dates appropriately; %sysparmpairs(); %let param1 = %bquote(')&param1.%bquote('); %let param2 = %bquote(')&param2.%bquote('); %mend; %set_constants; /* Set macro variables for environment */ %put dates=&param1. &param2.; /****************************************************************************************************************************************/ /** Fetch raw pulls of data--transactions (10 min), dnb (33 min), FDIC **/ /****************************************************************************************************************************************/ systask command 'sas -noterminal -rsasuser -batch -log simple_run_2.log -print simple_run_2.lst -sysparm "param1=&param1.,param2=&param2. simple_run_2.sas' taskname = sim ple_run_2; When I look at the log afterwards I see the following:   WARNING: Apparent symbolic reference PARAM1 not resolved. ^L2 The SAS System 20:06 Thursday, October 18, 2018 WARNING: Apparent symbolic reference PARAM2 not resolved. WARNING: Apparent symbolic reference PARAM1 not resolved. WARNING: Apparent symbolic reference PARAM2 not resolved. WARNING: Apparent symbolic reference PARAM1 not resolved. How do I pass param1 and param2 in that first call to the simple_run_2.sas program so the parameters will pass their values? ... View more

Hi, Were using SAS Enterprise Guide V 7.13 HF1 (7.100.3.5419) (64-bit) I'm currently running a SAS program from SAS Enterprise Guide. I have external parameters I pass to it when I run it on Linux. The command looks like this:   sas -noterminal -batch -log simple_run.log -print simple_run.lst -sysparm "beg_dt=2500,end_dt=2" simple_run.sas   How do I pass external parameters for beg_dt and end_dt to my program from SAS Enterprise Guide? ... View more

Hi, We're using SAS V 9.04.01M4P110916 I'm accessing Data from a defined Library called: %let us_mkt = server='sandntz.bkrgc.net' database='IDP_PRD_US_MARKETING' port=5480 user=&db2_idx. password=&win_pwdx. libname ROLAP netezza &us_mkt. schema=USER_ROLAP data ROLAP.USER_ROLAP.SALES_TBL; set ROLAP.SALES_TBL; run; I'm getting the following errror message: 263 data ROLAP.USER_ROLAP.SALES_TBL; ______________________________ 211 ERROR 211-185: Invalid data set name. 264 set ROLAP.SALES_TBL; 265 /* set USER_ROLAP.SALES_TBL; */ 266 run; If ROLAP is the correctly defined library and USER_ROLAP is the correctly defined schema. Why am I getting this error? Also FYI: Any other combination of these names gives an error where the program won't read data. I understand that ROLAP.USER_ROLAP is redundant but if I just say ROLAP.SALES_TBL in the data statement: I get the following error. Here is how the documentation says I should define it. 263 data ROLAP.SALES_TBL; 264 set USER_ROLAP.SALES_TBL; ERROR: Libref 'USER_ROLAP' exceeds 8 characters. ERROR: File WORK.SALES_TBL.DATA does not exist. 265 /* set USER_ROLAP.SALES_TBL; */ 266 run; Why am I getting these errors? ... View more

HI, we're using SAS 7.13 HF1 (7.100.3.5419) (64-bit)   I'm currently looking at a post that shows how to pass a value from SAS to a database that your connecting in to. Here is the example below. You can see they take the Macro variable StartDate and pass it into Teradata to be used in the query.   %let StartDate = 2016/01/01; proc sql; connect to teradata (BULKLOAD=YES MODE=TERADATA user=&user. Password=&passwd.); CREATE TABLE WorkTest.test AS select * from connection to teradata ( SELECT TOP 10 * FROM SomeCalendarData WHERE SomeDate = %bquote('&StartDate.'); ); quit;    I want to go the other way.   How can I read a value from a similar query, only my DB is Netezza, and somehow pass it to a macro variable in SAS?    Thanks! ... View more