About Zelazny7

LauraRK · ‎08-01-2017

This is really great. I got it up and working. Thanks so much for making this work.

Rick_SAS · ‎01-15-2016

One "design reason" is that many procedures have an OUTPUT statement that enables you to create an output data set that contains ALL the input variables AND the created variables. For example, in PROG REG, if you say OUTPUT out=MYOUT P=Pred R=Resid; then the output data set contains all input variables in addition to the predicted and residual variables from the regression. Because the output from one procedure is often used as the input to another procedure, this prevents doing a separate MERGE between procedure calls. Furthermore, PROC REG is an interactive procedure, so you can specify a model, then execute the RUN statement. After the model has run, you can specify the OUTPUT statement to get the output data set. In other words, the procedure does not know when it encounters the first RUN statement whether there will be an OUPUT statement later in the program.

AndrewZ · ‎11-02-2015

To use Generalized Boosted Regression (GBM) in SAS, please see the mlmeta package. After training the model in R, mlmeta converts the model to simple (but long) SAS code such that it can be used in Base SAS independently of R.

Zelazny7 · ‎05-22-2014

Thanks, that's a fairly obvious place for speed improvement. In production, I will have to apply both steps to the 1200 variable dataset. I suppose for testing I can use the much skinnier version.

data_null__ · ‎03-27-2014

The link is used in this program to keep _NAME_ unknown as the program is compiled, so that when PUT (_ALL_) (~); is compiled the _ALL_ "SAS variable list" contains only the variables from the data set named on the SET statement. Also the parenthesis around _ALL_ in the PUT statement are important to make _ALL_ a variable list and not the _ALL_ put statement directive. In other words there is a difference between put _all_; and put (_all_)(=); although they produce almost identical output.

jakarman · ‎10-03-2014

Base SAS(R) 9.3 Procedures Guide, Second Edition (insert append list applicable) SAS(R) 9.3 System Options: Reference, Second Edition (append=)

Reeza · ‎08-21-2013

Bad example data so hard to determine if this is correct or not: data have; example_field = "AX,EQ,XX,TY,M,GY,TS,Z,WP,DL"; output; run; data want1; set have; i=1; do while (scan(example_field, i, ",") ne ""); var_flip=scan(example_field, i, ","); value=1; output; i+1; end; run; proc transpose data=want1 out=want2 prefix=flag_; id var_flip; var value; run;

Zelazny7 · ‎01-13-2011

Very elegant solution, thank you!

Zelazny7 · ‎01-05-2011

I just received a reply from SAS Technical. Unfortunately, batch mode disables keyboard, mouse and monitor so it is not possible to accomplish what I was hoping. Thanks again for your responses.

Online Status	Offline
Date Last Visited	‎04-01-2016 10:35 AM

SAS Jupyter Notebook -nodms on Windows7

Why doesn't SAS keep only the variables needed for certain procedures?

Re: Help speeding up thousands of trees represented as if-then-else lo...

Re: Help speeding up thousands of trees represented as if-then-else lo...

Re: Help speeding up thousands of trees represented as if-then-else lo...

Help speeding up thousands of trees represented as if-then-else logic ...

Re: Generalized Boosted Regression (GBM)

Re: Write a line to a file that exceeds 32,767 characters

Write a line to a file that exceeds 32,767 characters

Test whether a macro located in SASAUTOS exists

Re: Why doesn't SAS keep only the variables needed for certain procedu...

Re: Test whether a macro located in SASAUTOS exists

Re: Test whether a macro located in SASAUTOS exists

Why doesn't SAS keep only the variables needed for certain procedures?

Re: SAS Jupyter Notebook -nodms on Windows7

Re: Why doesn't SAS keep only the variables needed for certain procedu...

Re: Generalized Boosted Regression (GBM)

Re: Help speeding up thousands of trees represented as if-then-else lo...

Re: Write a line to a file that exceeds 32,767 characters

Re: Test whether a macro located in SASAUTOS exists

Re: Dynamically create variables in the data step based on values of a...

Re: Reading specific field from .csv file

Re: Launch interactive Swing Application from SAS in batch mode?