About eagles_dare13

eagles_dare13 · ‎08-28-2015

What is the use of a SAS stored process? What can a stored process do that a normal sas program / macro cannot? It seems like a stored process is an unnecessary wrapper around a simple SAS program. In my company, the stored process is the first layer on the server side that intercepts web requests and sends back response in the form of JSON. Can a web request not directly interact with a SAS server side macro? IS that what the stored process is for? Some kind of a Mid Tier controller that acts as the gateway between web client and the SAS server side code?

eagles_dare13 · ‎08-28-2015

Am I correct to say that simple learning algorithms like linear and logistic regression can be done in sas enterprise guide using proc reg, but advanced algorithms like SVM and neural networks require enterprise miner?

eagles_dare13 · ‎08-05-2015

I have 2 jobs in DI studio. In job 1, I need to define some variables that I need to use in job2. So in job 1, I do: proc sql ; select col1 into :new_col from table1 where 1 = 1; quit; %global new_col; In job 2: I try to use the macro variable new_col, but the variable name cannot be resolved. How to solve this?

eagles_dare13 · ‎06-24-2015

How to achieve this in SAS? DATA TEST; A=1; B=2; IF A IN (LIST_OF_VALUES) THEN B = 5; OUTPUT; RUN; LIST_OF_VALUES is a column in a lookup table. Ideally, Iwould like something like: DATA TEST; A=1; B=2; IF A IN (select LIST_OF_VALUES from TABLE_TEST) THEN B = 5; OUTPUT; RUN; But this syntax is not allowed. How to achieve this?

eagles_dare13 · ‎06-11-2015

Thank you. I copied your code but am getting: ERROR: Invocation of unresolved module RANDFUN

eagles_dare13 · ‎06-11-2015

Thanks. How to get the plot of the distribution? I am looking for something like xyplot(x, p);

eagles_dare13 · ‎06-11-2015

Is there a way to simulate data points that have been drawn from a Geometric Brownian Motion (Weiner Process)? I am looking at this function:SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition But I don't see an option for a Weiner process. I know the Black Scholes internally simulates a Weiner process but is it possible to see what a set of 10,000 numbers drawn from a Weiner process looks like?

eagles_dare13 · ‎06-11-2015

Thanks. How come the probplot does not represent a bell curve but more like a 45 degree straight line?

eagles_dare13 · ‎06-10-2015

I wish to simulate(generate) a list of random numbers, where I specify the number of observations that I wish, the underlying distribution(normal,lognormal), the mean, the std. deviation and I want as output a list of random numbers from this distribution. Further I wish to draw a probability plot of these numbers, conforming to stathe distribution that they were drawn from. How to do it in SAS?

eagles_dare13 · ‎03-06-2015

Sorry, but 3.10 is coming as 3.1, the last 0 is getting dropped. data have; num=3; output; num=3.01; output; num=3.10; output; run; data want; set have; length text $10.; text=strip(put(num,best7.2)); run;

eagles_dare13 · ‎03-06-2015

Hello, I have a numeric variable x and i tried to convert to character using: put (x, best32.). Now, x can have values like 3, 3.0, 3.02 etc...upto 2 decimal places. How to keep the format as is..i.e 3 -->3, 3.0 --> 3.0 and so on? Currently, with my code, it is outputting everything as 1 decimal places...and dropping the second decimal. Thanks very much

eagles_dare13 · ‎01-30-2015

Thanks. This seems to work, but is it correct? In SAS, how can I do the equivalent of: data a; set b; if (somecondition = true) then do; drop col2; end;/*col2 is a column included in b*/ run;

eagles_dare13 · ‎01-30-2015

In SAS, how can I do the equivalent of: data a; set b; if (somecondition = true) drop col2; /*col2 is a column included in b*/ run;

eagles_dare13 · ‎01-29-2015

Thanks. Can you show with example what you mean by recoding with SELECT statement.

eagles_dare13 · ‎01-29-2015

Why is this code giving error: data test; length a: $5; a='2'; if a = '1' then a ='a' ; else ( a= 'b'); run; ERROR: Undeclared array referenced: else. I realise removing the parentheses will solve the issue, but i want to keep the parentheses for ease of understanding. Ultimately the else box will have many if else if conditions and the parentheses helps greatly.

Online Status	Offline
Date Last Visited	‎11-27-2015 06:07 PM

What can a stored process do that a normal SAS program cannot

What ML algorithms are part of base SAS

SAS global macro variable not being resolved

How to use a sql statement ina DATA step

Re: How to simulate a Weiner process in SAS

Re: How to generate a list of random numbers in SAS

How to simulate a Weiner process in SAS

Re: How to generate a list of random numbers in SAS

How to generate a list of random numbers in SAS

Re: How to convert to char from numeric without losing decimals

Re: SCD Type 2 Loader vs Change Data Capture

Re: SCD Type 2 Loader vs Change Data Capture

Re: What is the use of 'Propagate Columns' feature in SAS DI studio

machine learning using base SAS

How to send SAS email to multiple people

What can a stored process do that a normal SAS program cannot

What ML algorithms are part of base SAS

SAS global macro variable not being resolved

How to use a sql statement ina DATA step

Re: How to simulate a Weiner process in SAS

Re: How to generate a list of random numbers in SAS

How to simulate a Weiner process in SAS

Re: How to generate a list of random numbers in SAS

How to generate a list of random numbers in SAS

Re: How to convert to char from numeric without losing decimals

How to convert to char from numeric without losing decimals

Re: drop variables from a data set conditionally

drop variables from a data set conditionally

Re: sas if else not working when using parentheses

sas if else not working when using parentheses