SAS

Deleting all worksheets in an Excel workbook
Hi, Is there a better way to "clear out" an Excel workbook than deleting the existing file? This works, and is my desired output, although not my desired approach: libname xl "c:\temp\test.xls"; data one two three; x=1; run; proc copy in=work out=xl; select one three; run; libname xl; * ... 23 Dec 2009 20:44

scientific notation
You will get a better response if you provide an example data file. One possibility is that 7.4 isn't large enough to put your data unless it is written in scientific notation. For example: data have; input x; cards; 504E9 505E10 506E11 ; filename stuff "k:\art\test.txt"; data _null_; set have;... 23 Dec 2009 17:23

scientific notation
I have some numeric data that I want to output to a text file. Some of the data display as scientific notation in when I go to the table viewer in SAS. I would like to format these as 7.4. I have tried: put varname 7.4 ; to reformat the data but it still appears as scientific notation in the text file. ... 23 Dec 2009 17:23

missing numerical values = - infinity?
Going into rant mode... I discovered a feature of SAS that I wish I had known earlier: SAS will assign a value of *negative infinity* to missing numerical values in logical statements. So in the following code: if birth_weight<2500 then low_birth_weight=1; else if birth_weight>=2500 then low_birth_weight=0; ... 23 Dec 2009 16:15

Pega PRPC with CPM -- NJ,IL,PA
Hi, Please find this hot requirement on Pega PRPC mentioned below. Role: Pega PRPC (Developer/ Sr Developer/ Lead/ Architect) Location: NJ, PA, IL Requirement: Our Client is Looking for Pega PRPC (Developer/ Sr Developer/ Lead/ Architect) with CPM experienced, please reply me with resume and contact deta... 23 Dec 2009 16:15

Can PROC GENMOD models be scored via PROC SCORE?
Yes, you can do PROC SCORING using ODS output parameter estimate data set fairly simple. transpose the Estimate data with 'var estimate'; add two variables: _TYPE_ 'parms' _NAME_ whatever you like then load this one with PROC SCORE On Wed, 23 Dec 2009 14:51:12 -0500, Talbot Michael Katz <topkatz(a)MSN.COM> wr... 23 Dec 2009 16:15

Can PROC GENMOD models be scored via PROC SCORE?
Hi. I've built some models with PROC GENMOD. The only way I could see to produce a data set with parameters was through the ODS table ParameterEstimates. However, the format of this table does not appear appropriate to use as the SCORE= data set input for PROC SCORE. Can PROC GENMOD models be scored with PROC... 23 Dec 2009 16:15

How to run a procedure multiple times?
Yusuf, One way would be to wrap your code in a SAS macro and then simply run the macro. E.g.,: %macro runit; %do i = 1 %to 181; proc reg data = in; model y = x&i.; quit; %end; %mend; %runit HTH, Art ------- On Wed, 23 Dec 2009 13:03:06 -0500, Yusuf Mohamedshah <zulsdad(a)GMAIL.COM... 23 Dec 2009 15:10

data step rename
On Dec 23, 11:50 am, shakespeare_1...(a)HOTMAIL.COM (William Shakespeare) wrote: Say I have a data set with 3 variables, all numeric.  I need to convert the second to character and maintain the original order of the variables. I can do this, but with two data steps, on to convert the variable in question and... 29 Dec 2009 02:07

data step rename
Say I have a data set with 3 variables, all numeric. I need to convert the second to character and maintain the original order of the variables. I can do this, but with two data steps, on to convert the variable in question and drop the old variable, and another to reorder the variables. Is there a way to do this ... 23 Dec 2009 13:44