I am not certain this the best place for me to ask this question. Our office is just starting with DI Studio 4.9, and I am the only one using it. Our system deals with university students. I am trying to write a job that gets NEW students - only students enrolled in the current / target term. I have a macro that I used when using Base SAS to accomplish a similar goal. It looked at the current day, compared that to our Terms table and looked for a Term that had a start_date <= current date <= end_date. This macro returns the Term as well as the Day of the Term - start_date = current_date then Day of Term = 1, etc. I would like to incorporate this, or something similar into my DI Studio job so that I can use these variables in my DI Studio jobs. Can someone please point me to the best resource for learning more about this? Thank you for your time. ... View more

I pull from a database that has sum, but not all, variables prefixed with XCBM_ I would like to remove all of these prefixes from the variables name. Here is what I have tried: DATA TEST;     SET SASHELP.BWEIGHT; RUN; %MACRO RENAME(LIB=,DSN=); PROC CONTENTS DATA=&LIB..&DSN;     TITLE 'BEFORE'; RUN; PROC SQL NOPRINT;     SELECT    NVAR INTO :NUM_VARS     FROM    DICTIONARY.TABLES     WHERE    LIBNAME="&LIB" AND MEMNAME="&DSN"     ;     SELECT    DISTINCT(NAME) INTO :VAR1-:VAR%TRIM(%LEFT(&NUM_VARS))     FROM    DICTIONARY.COLUMNS     WHERE    LIBNAME="&LIB" AND MEMNAME="&DSN"     ; QUIT; %PUT &NUM_VARS; PROC DATASETS LIBRARY = &LIB;     MODIFY &DSN;     RENAME     %DO I = 1 %TO &NUM_VARS.;         %IF %SUBSTR(&&VAR&I,1,2) = 'm_' %THEN %DO;             &&VAR&I = %SUBSTR(&&VAR&I,3);         %END;     %END;     ; RUN; QUIT;     PROC CONTENTS DATA=&LIB..&DSN.;     TITLE 'AFTER'; RUN; %MEND RENAME; %RENAME(LIB=WORK,DSN=TEST) ... View more

In the following example, because of missing numeric data, using the plus sign to add horizontally across variables results in an overall missing value as well. However, using SAS's SUM function will display what I am expecting. Because of that, in what circumstances if any would using a plus sign be more beneficial? Thank you for your time. data test;     x = 10;     y = .;     z = 7;     test1 = x+y+z;     test2 = sum(x,y,z);     label test1='x+y+z' test2='sum(x,y,z)'; run; proc report data=test nowd; run; ... View more

I am trying to get demographic counts from a dataset. The below example is just a portion of the dataset, but contains most of what I am trying to measure. For each section of a class, I want to get the number of the different ethnicities, genders, colleges (to which the student belongs) and classification of the student. Right now my method is rather "clunky" but it works. I've tried a combination of arrays and do loops, but it didn't seem to like what I was trying. Thank you for your time. data have; length id $2 composite $12 ethnic $1 gender $1 college $2 class $2;     infile datalines dlm=',' dsd;     input id $ composite $ ethnic $ gender $ college $ class $; return; datalines; "01","MATH*4583*01",1,"M","AS","FR" "02","MATH*4583*01",5,"F","AS","SO" "03","MATH*4583*01",2,"M","HS","JR" "04","MATH*4583*01",4,"F","PE","SR" "05","MATH*4583*01",3,"F","N","PB" "06","MATH*4583*01",6,"M","G","FR" "07","MATH*4583*01",7,"M","G","FR" "01","MATH*4583*02",1,"M","AS","FR" "04","MATH*4583*02",4,"F","PE","SR" "02","MATH*4583*02",1,"F","AS","SO" "08","MATH*4583*02",8,"M","N","PB" ; run; proc sort data=have;     by composite; run;    /*    This works, but surely it can be done better    */ data want;     set have;     by composite;         if first.composite then do;         section_headcount = 0;         eth_1 = 0; eth_2 = 0; eth_3 = 0; eth_4 = 0;         eth_5 = 0; eth_6 = 0; eth_7 = 0; eth_8 = 0;         m = 0; f = 0;         as = 0; hs = 0; pe = 0; n = 0; g = 0;         fr = 0; so = 0; jr = 0; sr = 0; pb = 0;     end;     section_headcount + 1;     if ethnic = '1' then eth_1 + 1;     if ethnic = '2' then eth_2 + 1;     if ethnic = '3' then eth_3 + 1;     if ethnic = '4' then eth_4 + 1;     if ethnic = '5' then eth_5 + 1;     if ethnic = '6' then eth_6 + 1;     if ethnic = '7' then eth_7 + 1;     if ethnic = '8' then eth_8 + 1;     if gender = 'M' then m + 1;     if gender = 'F' then f + 1;     if college = 'AS' then as + 1;     if college = 'HS' then hs + 1;     if college = 'PE' then pe + 1;     if college = 'N' then n + 1;     if college = 'G' then g + 1;     if class = 'FR' then fr + 1;     if class = 'SO' then so + 1;     if class = 'JR' then jr + 1;     if class = 'SR' then sr + 1;     if class = 'PB' then pb + 1;     if last.composite;     drop ethnic id gender college class; run; ... View more