SAS

update_with_history macro search
dear all, we are using the macro "update_with_history" already for years (version 2.4 sept 2004). I was wondering is there is an updated version available regarding loading extra (old) data ?? I found this somewhere http://bi-ego.com/tiki/tiki-index.php?page_ref_id=24&PHPSESSID=4ca5dbb3da63ce344058a6ccbf87993f ... 22 Jan 2010 02:55

Concatenating Times
Points to consider Time8 format actually allows a decimal portion for fractions of a second as in Time13.4 Milliseconds are 1000th of second so if your second variable is milliseconds the corresponding display would be 00:45:28.0073 If the milliseconds field is always the fractional ... 22 Jan 2010 10:37

Weird naming convention with newfile=bygroup ?
Maybe not so weird, I think I like it. To obtain the behavior you desire put a 1 an the end of the filename. ods html file="junk1aa1.html" to produce 19 files junk1aa1-junk1aa19 On 1/21/10, Ya Huang <ya.huang(a)amylin.com> wrote: Hi there, When you use newfile=bygroup option for ods, SAS will auto... 21 Jan 2010 22:32

Importing CSV, first row has column names
When import csv file : proc import datafile='file.csv' out=newfile dbms=csv replace; getnames=yes; run; this happens: column names appear in Row 1 instead of actual column names (that are now Var1, etc...)..... how can I either import column names so they appear as column names, or rename first row (values)... 21 Jan 2010 19:10

IN - Option
All, Can someone please let me know , What exactly would be the use for using IN option in data set For e-g data vacdata; length src $1.; set datasetA (in=in1) datasetB (in=in2); if in1 then src='1'; else src='2'; format src $1.; run; I was trying to find the documentation , but someho... 21 Jan 2010 15:44

keep text together
For ODS RTF using data step object, what is the code to keep a block of text together on the page? Also can the same be done for PDF? Thanks, Masoud ... 21 Jan 2010 15:44

Proc ARIMA - by groups
I have a question regarding Proc ARIMA - I would like to forecast for many by groups and was wondering if there is a way to automate the model fitting process. Maybe by outputting the autocorrelations to see if they are decreasing towards zero and then outputting the p+d and q to fit into the model for each by grou... 21 Jan 2010 21:26

SASware ballot #18 Proc Transpose preserving variable
What you are asking for is not just variable attributes but a fundamental change in the way PROC TRANSPOSE works with more than one variable in the VAR statement. As long as it doesn't break any exisiting features. You can achieve a similar result with PROC SUMMARY but it requires knowledge of the dimension of ... 27 Jan 2010 20:34

Can Proc Import define data column numbers?
I know Proc Import has datarow=n option. But I need to just read in column1 to column17 as my variable in a TXT file. Is there a way to do it in Proc Import? Thank you for any input. Good day! ... 20 Jan 2010 23:01

not enough memory
Hi , I use proc model to estimate a hundred equations using proc model data... ..... fit eq1 eq2 ..eq100/GMM And sas log says unable to allocate sufficient memory,need at least 400mb more. Which is strange, I have 4G physicaly memory on WinXP 32 using sas 9.2. Surely I have 400mb of free memory. Just a... 21 Jan 2010 08:55