SAS

Easy Project Management
Top-Rated, Web Project Management Software Project Drive provides all tools, charts, reporting functions and a customizable dashboard for efficient project management and objective- oriented productivity http://www.project-drive.net ... 5 Jul 2010 08:51

data merge query
Hi, Recently I was trying to merge 2 datasets as below. My objective to get the values of 'pop' by 'num' in the dataset 'sur'. This works, but zip 11 is being replaced by 1. Can somebody explain why it so?? I thought using 'if a;' will ignore 'zip' in the second dataset. Thanks, Regi DATA sur; INPUT ... 7 Jul 2010 04:42

Longitudinal data selection help
Dear all: I have this data that has many undesirable repetitions of the variables. I want to select one row of data per subject or delete the other rows. I tried proc sort with nodup but it does not seem to work. Data have; input subid survey meandose; datalines; 311 36 0.90909 311 ... 5 Jul 2010 04:33

Energy Saving Tips
1. Reduce heater's room temperature For each extra degree (Celsius) of temperature, your heater will consume 7 to 11% more energy. Adjust it to 18degrees which is also better for your health. 2. Install a programmable thermostat You will be able to control the heater's temperature during specific hours every day... 4 Jul 2010 05:47

Exporting from ODS in SAS to Word
Hi, I use the code :- ods html on; title 'Stepwise Regression method'; proc reg data=review1 outest = est4; model Z = X Y / SELECTION = rsquare cp aic sbc b best=3; RUN; quit; ods html close; i want to open the table that i get in the output data set 'est4' into Word . I get the log as - 98 ods ... 4 Jul 2010 12:15

execute formula in macrovar
how can I store the result of the calculating in a macrovar NOT using a datastep? %let now_day = "20jun10"d ; %let prev_year = intnx('year',&now_day,-1,'E'); /***THIS WORKS**/ data a; v1=&prev_year; format v1 date9. ; run; /***THIS DOES NOT WORK***/ %put >>>>PREVIOUS YEAR : %SYSFUNC(&prev_year,date9.)... 4 Jul 2010 07:55

Convert SAS dataset to an Oracle table
Hi, is there a way to convert a sas dataset into an Oracle or an Sqlite database table? What I am doing now is exporting the sas dataset into a flat text delimited file and then import that file into a relational database table, but this is not very ideal and if someone can point to a more direct way I'd be gratefu... 3 Jul 2010 23:20

Scorecard : Probabailities
Hi I have the results from Proc logisitic in probabailities form and my final list of varibales are as follows: age_18_27 Gender_M income_27_45K 1.How can i convert probabailities to some form of points , which are easy to interepret( 20 , 40 etc ) 2. How can i assign points to all the groups with age & ... 3 Jul 2010 01:33

Difficulty with large dataset and "normalizing" variables Proc Univariate & Proc Means
Hi- First, sorry for the long post. I don't want to annoy any of you, especially since I am in desperate need of your help. I've noticed that a lot of questions get answered effectively only after the OP states what the "big picture" is, so I am going to try to do that. I have an unbalanced (Different start an... 2 Jul 2010 23:24

data step over proc sql
Hi All, Can somebody explain me the advantages of using data step over proc sql in SAS? thank you ... 5 Jul 2010 19:58