Hello Beautiful People!   I hope all is well!  I am trying to see if the variances of my samples are the same (for brevity's sake I only included 6 data, but my data sets in question have hundreds of rows), but I am not sure which procedure to use in SAS EG 8.1.  Also, is there a way to do this using the "Tasks" feature in SAS EG?  The sample data are below:   data work.DummySales; infile datalines; input Month monyy6. Sales: dollar10.2 SalesB: dollar10.2 SalesC: dollar10.2; format Month monyy. Sales dollar10.2 SalesB dollar10.2 SalesC dollar10.2; ; datalines; Jan-12 $6,300.28 $5,400.12 $6,002.77 Feb-12 $7,298.56 $7,919.22 $7,491.08 Mar-12 $5,098.79 $5,989.01 $5,488.23 Apr-12 $5,971.96 $5,622.71 $6,122.21 May-12 $5,585.79 $5,588.66 $5,771.39 Jun-12 $5,575.80 $4,923.47 $5,353.29 ; run; Which procedure should I use to do this?  And can this procedure be done using "Tasks"?  I've seen PROC GLM in different blogs, but I fail to see why I would want to create a model with my data unless it outputs tests for whether my different samples have the same variance or not.  Any help is greatly appreciated; thanks!   -Valentine ... View more

Hello Beautiful People!   I hope all is well.  I'm trying to automate a very manual process as follows: There is a %LET macro variable that references a date ---> %LET date = '2020-01-10'; There is then a data step that follows that generates basic data for that date.   Once the data step runs, change the date variable for the next day and rerun the process.  Repeat this for every day of the month. An example of the above process is below, where I would change the macro variable after this process runs for the next day and repeat until I capture all of the days of the month. %let date =20200110; Data example; set balance_&date.;run; /*Rerun the above step for every day of the month because busy work.*/ How would I translate this into a macro that encompasses a %DO loop to capture every day of the month?  For example: If it's February 2020, it would capture all 29 days.  If it's December, it would capture all 31 days.  Etc.  Any guidance on this is greatly appreciated!     ... View more

Hello Beautiful People!   I have a simple SAS program that's producing blanks when I run it.  The program is below (my intention is for the program to produce what the datalines statement shows):   data work.example_2012; infile datalines dsd; input Month monyy6. Sales: dollars.; format month monyy. Sales dollars4.2; ; datalines; 12-Jan $1,000.00 12-Feb $2,000.00 12-Mar $3,000.00 12-Apr $4,000.00 12-May $5,000.00 12-Jun $6,000.00 12-Jul $7,000.00 12-Aug $8,000.00 12-Sep $9,000.00 12-Oct $10,000.00 12-Nov $11,000.00 12-Dec $12,000.00 ; run; And the output is like so:   Month Sales . . . . . . . . . . . . . . . . . . . . . . . . Can someone tell me what I'm doing wrong?  Any guidance is greatly appreciated!   -Valentine ... View more

Hello Everyone,   I'm scratching my head at this problem.  Here's what I'm trying to do:   1. Use cats to create a concatenation between a calculated Month, a delimiter, an arbitrary day (15 in this case), and a calculated two digit year.  I then use the input function on this to force it to MMDDYY10. format, but I keep getting 21564, not 01/15/2019 as I intended.   2. The string date is shown next to the formulaically derived date.   proc sql; create table example2 as select * from (select put(&YYMM.,Best4.) as YYMM, Acct_No, sum(Balance) as BalAmt, avg(Balance) as Avg_Bal_Amt, avg(Mon_Var) as Month, cats(calculated Month,"/",15,"/",substr(calculated YYMM,1,2)) as Date, input(cats(calculated Month,"/",15,"/",substr(calculated YYMM,1,2)),MMDDYY10.) as Date2 from example1 ); run; quit;     The output is shown like so:   Date (str)         Date2 (Num) 1/15/19           21564 1/15/19           21564 1/15/19           21564 1/15/19           21564   Mon_Var is simply the month number such as 1, 2, 3, etc (an integer).  YYMM is a macro that is predefined.  In this case, it is 1901 (a string).  I am, in effect, trying to take an arbitrary day like 15, and create a date out of this YYMM variable, but to no avail.  Any help is appreciated!   -Valentine ... View more

Hello Beautiful People!   I keep running into a syntax error when for my last Case Statement (Case MOB), but I do not know why it's wrong.  Below is the code:   proc sql; create table MOB&YYMM. as select * from (select YYMM, MOB, count(a.PROD_ACCT_NO) as AcctCt, sum(STMT) as BalAmt, avg(STMT) as AVG_Bal_Amt, Year, substr(put(&YYMM.,4.),3,2) as Month_Var, Case calculated Month_Var when '01' then 'Jan' when '02' then 'Feb' when '03' then 'Mar' when '04' then 'Apr' when '05' then 'May' when '06' then 'Jun' when '07' then 'Jul' when '08' then 'Aug' when '09' then 'Sep' when '10' then 'Oct' when '11' then 'Nov' when '12' then 'Dec' End as Month, Case MOB when <13 then '1-12' when >=13 and <61 then '13-60' when >=61 and <121 then '61-120' when >=121 then '121+' End as MOB_Range from example3 as a group by MOB ); run; quit;     The log gives the following error:    ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, BTRIM, INPUT, PUT, SUBSTRING, USER. My end goal is to try to use this case statement to create ranges for my MOB variable.  The MOB variable is an integer, and I would like the ranges to be strings.  Any information on this is greatly appreciated!   -Valentine ... View more

Hello Beautiful People!   I'm using Proc SGPLOT to plot the end results of Proc X11.  What I would like to do is specify an output file for my graph, but I'm not seeing an Output statement or anything of the sort that will allow me to save my graph to a file to then be exported.  Here's an example:   /*Plot of D10 - the Final Seasonal Factors*/ Title "Monthly Seasonal Factors"; proc sgplot data=work.dummytest; series x=Month y=d10 / markers markerattrs=(symbol=CircleFilled) ; run; Can this be done with Proc SGPLOT?  Any information is greatly appreciated; thanks!   -Valentine ... View more