About agoldma

agoldma · ‎09-01-2017

I would like to calculate a moving average and standard errors across 6 previous time periods (for each period). Total number of periods = 50; starting the calculations on the 7th period. I can do this in a non-statistical way, but I was wondering if it's possible to do this with PROC MODEL or PROC MIXED or another procedure. I have many observations per period (thousands), but I have a field called period, so I'd like to use that somehow. I would like to avoid taking averages of averages, so I don't want to reduce my data to 1 observation per period. If I have 2 numeric variables: X and period, how can I generate a 6-period moving average over 50 periods? I would also like to get moving standard errors in addition to that average. Thank you

agoldma · ‎07-06-2017

If the enoding problem happened upon the creation of XML, then it's probably necessary to "preprocess" the XML text prior to reading it (like Chris suggested above) Search for things LIKE "&#___;" ... that are bad translations of HTML codes I removed them with this code: line1_fixed = prxchange('s/&#([0-9])+;//',-1, line1);

agoldma · ‎07-03-2017

Thank you, art297 It was "Ignore HTML" Apparently, we don't want to ignore HTML

agoldma · ‎07-02-2017

If I don't log-in, the posts look good -- as expected -- the code boxes ("insert code") are grey in courier font, and if I use the courier font, my post displays the currier font. After I log-in, the code boxes look like plain text in Arial font all in one line ignoring carriage returns. If I choose the courier font, it's ignored in favor of Arial. I get the same results in 3 browsers: IE, Chrome, Firefox Is this a known issue? Do I have some settings set incorrectly? Thanks

agoldma · ‎07-02-2017

Ksharp, thank you for a very thoughtful and efficient solution. I modified the array references a little bit -- to make it work in a PROC FCMP. Since SAS doesn't have a built-in function like this, I wanted to make my own. proc datasets nolist lib=work; delete functions; quit; options cmplib=_null_; proc fcmp outlib=work.functions.smd; function count_dist_val(arr_val{*} $ ) varargs ; array t{100} $100 _temporary_ ; n = 0; call missing( of t1-t100); do i=1 to dim(arr_val); if arr_val{i} not in (t1-t100) then do; n + 1 ; t{n} = arr_val{i} ; end; end; return (n); endsub; run; options cmplib=work.functions; data have; input (name1 name2 name3 name4)($); array x{*} $ name1-name4; dist_val = count_dist_val(x) ; put dist_val= ; datalines; AA BB CC DD AA AA BB EE FF FF CC CC AA AA AA AA BB BB BB ZZ ; run;

agoldma · ‎06-23-2016

I submitted a ballot idea for this: Format Description at the Time of Definition

agoldma · ‎06-18-2016