Hey,   I want to add a dummy date variable: - if the metric column value changes - every 12 months after the first recorded date for the by group (id) even if the metric column value doesn't change   Can someone help produce the WANT dataset? Thanks.   P.S.: Even if metric doesn't change I need a date populated every 12 months after the first known date of each id.   data have; informat id 1. date_record mmddyy10. metric 1. metric_change $1.; input id date_record metric metric_change; format date_record date9.; datalines; 1 01/01/2010 5 n 1 01/01/2011 5 n 1 01/01/2014 6 y 1 06/01/2014 6 n 1 11/30/2014 6 n 1 05/01/2015 8 y 1 12/01/2015 3 y 2 03/01/2015 3 n 2 03/05/2015 4 y 2 02/28/2016 5 y ; run; data want; informat id 1. date_record mmddyy10. metric 1. date_wanted mmddyy10.; input id date_record metric date_wanted; format date_record date9.; format date_wanted date9.; datalines; 1 01/01/2010 5 01/01/2010 1 01/01/2011 5 01/01/2011 1 5 01/01/2012 1 5 01/01/2013 1 01/01/2014 6 01/01/2014 1 6 01/01/2015 1 05/01/2015 8 05/01/2015 1 12/01/2015 3 12/01/2015 2 03/01/2015 3 03/01/2015 2 03/05/2015 4 03/05/2015 2 4 03/05/2016 2 02/28/2016 5 02/28/2016 ; run; ... View more

Hi All, Was waiting for the sas community upgrade to finish so that I could post this. SAS enviornment: I am running EG 4.3 on a unix based server Problem: I can write ods html, rtf and pdf to a server userdata folder. However I can't write a xls or xlsx file. Code: Desired result: Produce a html file in the server userdata folder ods html body="/someserverlocation/alpha.html"; proc print data=sashelp.class; run; ods html close; Problem: Using a xls or xlsx extension causes issue ods html body="/gbm/gbmrisksys/teamdata/users/gulahar/alpha.xlsx"; proc print data=sashelp.class; run; ods html close; xls issue: if i use xls it says file format not recognized and it does produce a file xlsx issue: if i specify this then on trying to open the file it comes up with a file import wizard and the imported table just consists of the variable format information rather than the data. Question: 1. If i can write to pdf, rtf and html to the server user folder shouldn't i be able to write xls or xlsx files also? 2. When the html file gets produced on opening it i can easily import it to my EG enviornment using the file wizard. However the xlsx file only results in the variable formats getting imported. Why can't i import the xlsx file? Thanks ... View more

Hey, My goal is to have a script that can - Check the date a file has been created in a network folder 'X' - If it is the latest file then copy it over to another network folder 'Y'. Latest file can be compared using system dates or checking file names in folders 'X' and 'Y' What I have: I have EG 4.2 installed on a server that I am connecting via a UNIX account. In terms of permissions I can import and export files from my computer. Question: - Does SAS EG support such a task? I have looked online and there are non sas scripts and softwares that do that but was wondering if SAS can do that for me. Have a nice bank holiday weekend. Thanks Jai ... View more

Hi, My question is will 'archtest, reset and godfrey' tests produce different output for a model when - you include the weights option in proc reg - exclude the weight option. Alternative that I have is that: I need these 3 tests but my problem is that proc reg doesn't support these tests as default code options. Autoreg supports these options but I don't think it has a weights option. So is there any way of producing these three tests in proc reg? I am running following code: proc reg data=test; model actual=ind1 ind2; restrict ind1=xxx; weight w1; quit; proc autoreg data=test; model actual=ind1 ind2/archtest reset godfrey; quit; Any thoughts? Regards, ... View more