sophiecs's articles:

Items(9) /1

unsubscribe #28 0 24 (12/12/2007 2:46:56 AM) comp.soft-sys.sas Thank you and good luck to all ... sophiecs

how to output combination 0 30 (8/30/2007 9:29:49 PM) comp.soft-sys.sas I use ods csv file to output some proc freq and proc means results. All the tables are two-dimensional and all by income categories. eg. age by income, region by income. The income variable has four categories ... sophiecs

How to turn off ods csvall "file download" dialog window 2 64 (7/23/2007 7:19:55 PM) comp.soft-sys.sas When i submit SAS codes locally with ods csvall file to generate the output in csv. it always pop out a dialog window. Does anyone know how to turn it off? I looked it up in SAS help but did not find anything r... sophiecs

Re: how to compound annual rate in SAS #2 0 31 (7/21/2007 2:32:09 PM) comp.soft-sys.sas Thanks, Howard, and do you think I should separate them ? like (1+a)**20 * (1+&)**20? On 7/21/07, Howard Schreier wrote: > On Sat, 21 Jul 2007 09:50:17 -0400, Sophie Shen wrote: > > >I am projecting peopl... sophiecs

how to compound annual rate in SAS 3 126 (7/21/2007 1:50:17 PM) comp.soft-sys.sas I am projecting people's income forward to 2020 and 2030. Everyone has a historical real income change annual rate, a, and also have a macro variable, b, which stand for the overall real income change annual ra... sophiecs

Re: macro problem #17 0 22 (7/8/2007 11:04:40 PM) comp.soft-sys.sas Hi Toby and Ian, Thanks for your input. I added another two if statements after "if %y >=10": if x10 then It was a little bit tedious. Ian, you raised a good question about apply people of today's mortality t... sophiecs

macro problem #6 3 28 (7/7/2007 8:44:07 PM) comp.soft-sys.sas I have two temp datasets for this program base2000 and donor 2000. One problem is the macro wells well until Y resolves to 10 when x resolves to 9. The run before y resolves to 10 generates a data set base2009... sophiecs

Re: Excel VB to call SAS read in data and run and spit out the #2 0 22 (6/30/2007 12:07:59 AM) comp.soft-sys.sas Hi Alan, Yeah, Excel is needed as the user-interface. The user can fill in the value for 15 parameters in the userform and their input will be stored in one of the sheets of the workbook and they can name thei... sophiecs

Excel VB to call SAS read in data and run and spit out the output 3 25 (6/29/2007 9:44:03 PM) comp.soft-sys.sas Does anyone by any chance know how to get an excel macro to create a csv file that could then be read in by SAS to run a model? I create a user form in excel that the user can type in values for 15 different pa... sophiecs

sophiecs's replies:

Items(3) /1

Excel VB to call SAS read in data and run and spit out the output 3 25 (6/29/2007 9:44:03 PM) comp.soft-sys.sas Does anyone by any chance know how to get an excel macro to create a csv file that could then be read in by SAS to run a model? I create a user form in excel that the user can type in values for 15 different pa... sophiecs (12)

macro problem #6 3 28 (7/7/2007 8:44:07 PM) comp.soft-sys.sas I have two temp datasets for this program base2000 and donor 2000. One problem is the macro wells well until Y resolves to 10 when x resolves to 9. The run before y resolves to 10 generates a data set base2009... sophiecs (12)

how to compound annual rate in SAS 3 126 (7/21/2007 1:50:17 PM) comp.soft-sys.sas I am projecting people's income forward to 2020 and 2030. Everyone has a historical real income change annual rate, a, and also have a macro variable, b, which stand for the overall real income change annual ra... sophiecs (12)