Hi all.    I have a dataset with two variables, MY_ID and MY_DATE.  The record MY_DATEs are all between the two year period of '01JUN2016'D AND '31MAY2018'D.    Using Proc SQL, I need to pull the IDs that are present with MY_DATEs between '01JUN2017'D AND '31MAY2018'D, but NOT also present between '01JUN2016'D AND '31MAY2017'D.   Does anyone have a suggest for a good way to code this?  Any help would be greatly appreciated.     ... View more

Hi. In SAS EG my results are opened in the Output Window automatically.  I like this.   In SAS EG using Proc SQL I can change the displayed variable output in the Output Window my specifying a format in the SELECT statement like this.  By doing this the myNewDollar variable appears in the Output Window looking like $100.00.   proc sql; create table Want as select myDollar format dollar15.2 as myNewDollar from Have; quit;   However when using the SAS datastep in SAS EG, when the Output Window is populated the variable is not formatted as desired. It is display as 100.00 (without the $ sign)    data Want; set Have; format myNewDollar dollar15.2; myNewDollar = myExistingDollar; run;   I'm wondering if it's possible to get the variable output to the Output Window formatted using the data step without having to add additional Procs like a Proc Print?     Any help would be greatly appreciated. ... View more

Hi. I need the individual all_volume for each region.  Currently I run this in 3 different data steps (see below). I'm wondering if there's a Proc I could us instead?  And if you could help with the syntax for it?  Thanks.   proc sql; create table Want as select sum(a_volume+b_volume+c_volume) AS all_volume from Have where region = '1' ;quit;   proc sql; create table Want as select sum(a_volume+b_volume+c_volume) AS all_volume from Have where region = '2' ;quit;   proc sql; create table Want as select sum(a_volume+b_volume+c_volume) AS all_volume from Have where region = '3' ;quit; ... View more

I have the following program and I'd like to try to use macros to simplify the repetative code. As you can see it runs the same steps for similarly named and structured datasets. The only difference is Quarter (Quarter 171 and Quarter 164).  The datasets are read in and then merged.   Would there be a nice way to use macros to read in any number of Quarter specific datasets, say 163, 164, and 171, without having to hardcode the Quarter throughout?   Any help would be greatly appreciated!   /*Permanent storage location of quarterly summary datasets*/ libname DSs 'K:\TTMS\IV_Internal SPM\Parallel Testing\Parallel Test Harness\PTH_Quarterly_DSs'; data querydatasummary171; set DSs.querydatasummary171; if imb_dlvry_zip_5='171'; rename total=total_171 percent=percent_171; drop rule_order score_impacting imb_dlvry_zip_5; run; /*Sort for merge*/ proc sort; by rule_nm; run; data querydatasummary164; set DSs.querydatasummary164; if imb_dlvry_zip_5='164'; rename total=total_164 percent=percent_164; drop rule_order score_impacting imb_dlvry_zip_5; run; /*Sort for merge*/ proc sort; by rule_nm; run; /*Merge the datasets for comparison*/ data combined; merge querydatasummary171 querydatasummary164; by rule_nm; run; /*Reorder columns*/ data Quarterly_Summary_Comparisons; retain rule_nm total_164 total_171 percent_164 percent_171; set combined; format total_164 comma12.0 total_171 comma12.0; run; /*For appearance*/ proc sort; by descending total_171; run; /*Print report*/ proc print; run;   ... View more