SAS

putting data in the right format
Hello everybody I have an issue related to data extraction and putting it in the right format Usually, I can get stock market data in two formats (usually into excel): format 1 MF FP Equity DGFP FP Equity 2045Q FP Equity date PX_last date PX_last date PX_last 05/01/1998 23,9068 05/01/1998... 20 Mar 2010 18:50

SAS optmization
Hi I am trying to find the better function in SAS to do a nonlinear optimization function similar to the one using the optim function with the BFGS method for the R software which allows defining upper and lower bonds . ... 21 Mar 2010 06:05

Running PL/SQL through PROC DBLOAD
I'm trying to get some PL/SQL code to run in PROC DBLOAD - however the code has the syntax 'exit when tr_pk%NOTFOUND'. The presence of the % sign seems to cause some issues, as SAS is reading it as some kind of Macro language. Wondering if there is anything that can be invoked to have SAS ignore the % sign as any ... 19 Mar 2010 20:08

aggregate remaining obs /records SQL
I have the following sql code that groups records by yr, month and a few other classification variables and orders by descending sum of variable "amount". What I'd like to do is keep the top 3 records(equivalent to top 3 amts after ordering) in each category as individual records and group the remaining records ... 19 Mar 2010 21:14

Deleting files older then a certain age from a folder
Hi, I have made a macro to delete empty files from a folder, and wonder how it can be justified a bit to delete only those files that were created yesterday or earlier. It this task cannot be accomplished in this way, is there another way to do it? Here is the macro: %macro delete_empty_files_in_folder(folder... 20 Mar 2010 17:44

generate SAMPLE correlations
Hi, I have a random variable with 200 observations. I would like to generate a second random variable with 200 observations and a given correlation with the first random variable. Many of the solutions I've seen on the web seem geared towards calculating a population correlation statistic. Could someone break... 22 Mar 2010 11:51

create second random variable with 0 correlation
Hi; could someone suggest how to calculate a random variable with 0 correlation to a series of know observations? I have a dataset that consists of stock price returns for one stock on a dly basis. Total number of observations is 200. I need to create a random variable with 200 observations that has a correl... 23 Mar 2010 15:57

Siebel Business Analyst with Pharma -- Milpitas CA
(Please note: If you are interested in this position and you have all skills experience which mentioned in requirement, so please update your resume as per the requirement and reply me) Hi, Hope you are doing well, Please find this Requirement of our Direct Client, if it looks interested please reply me ASA... 19 Mar 2010 13:11

proc gplot question
Hi I am tring to draw a graph with following dataset. but because they are not in same scale, it just gives me 3 straight lines if I ovelay them together. Is there a way to improve my gplot logic to see actual movements on the lines ? Thanks data have; input n var1 var2 var3; datalines; 1 9.091894617 9.64406... 19 Mar 2010 08:10

reading xls without proc import or changing file type
I am trying to figure out a way to read an ods generated xls file from sas that has been manipulated back into sas without using a proc import or changing the file to csv or another file type. I am a can not use any sas interactive features such as dde. Additionally I am not sold on the output from sas to xls so ... 18 Mar 2010 17:46