What are the steps that I need to take to write to an Oracle schema in Data Integration Studio directly?  When to creating a new table or when updating the table.  I can view Oracle schema in Data Integration Studio. ... View more

I have a script that runs correctly in Enterprise Guide on my computer.  However when I run the script overnight on a server it errors.  With the block:   proc sql; _33                                                         The SAS System                                 05:28 Monday, May 20, 2019   1421       1422       1423       create table capacity_base as 1424       1425       1426       select academic_period, census_period, input(begin_time1,hhmm.) as time, COURSE_IDENTIFICATION, COURSE_REFERENCE_NUMBER, 1427       ACTUAL_ENROLLMENT, MAXIMUM_ENROLLMENT 1428       from odsstu.registration_course 1429       where census_period=&census and (academic_period>="&first_academic_period" and academic_period<="&last_academic_period") 1430       order by academic_period, COURSE_IDENTIFICATION, COURSE_REFERENCE_NUMBER; ERROR: The informat HHMM was not found or could not be loaded. ERROR: The informat HHMM was not found or could not be loaded.   It appears that when I run the block in Enterprise Guide that the script understands format hhmm.  But when running the .sas script on the server, the server does not understand the format expression. ... View more

Is there a high level implementation guide for DataFlux?  I have some general business level questions about implementing it. ... View more

How can I set the value of first_academic_period to character.     %let last_academic_period='201910'; %macro setFirstAndLastPeriod(); %let testing = %substr(&last_academic_period, 5, 2); %put (&testing); %if %substr(&last_academic_period, 5, 2) = '10' or %substr(&last_academic_period, 5, 2) = '20' %then %let first_academic_period = input(%eval(&last_academic_period - 490), 6.); %else %if %substr(&last_academic_period, 5, 2) = '30' %then %let first_academic_period = input(%eval(&last_academic_period - 420), 6.); %put &first_academic_period; %mend; %setFirstAndLastPeriod(); ... View more

In Visual Analytics.  I have columns ID, and Course.  How can I show the distinct number of times that each ID i related to a course?   The output should look like   Math PersonA 3  Math PersonB 2 Math PersonC 5   ... View more