proc stdize data=EMWS1.VarClus_TRAIN method=RANGE pstat;
var NO_TRX_POS_NORM NO_TRX_12M_ONL_NORM IMP_AGE BASKET_QTY_NET_12M SUM_VAL_12M_NORM
SUM_VAL_NORM SUM_QTY_NORM;
run;
Hey everyone,
before I run the cluster node I want to make a standardization of these variables shown in the code.
However, it doesn't work unfortunately. Do I have to name a dataaset output to overwrite the variables?
Thanks a lot!
@SAS_ASS wrote:
proc stdize data=EMWS1.VarClus_TRAIN method=RANGE pstat; var NO_TRX_POS_NORM NO_TRX_12M_ONL_NORM IMP_AGE BASKET_QTY_NET_12M SUM_VAL_12M_NORM SUM_VAL_NORM SUM_QTY_NORM; run;
Hey everyone,
before I run the cluster node I want to make a standardization of these variables shown in the code.
However, it doesn't work unfortunately. Do I have to name a dataaset output to overwrite the variables?
Thanks a lot!
You really want an OUT= data set to send the output to. It would be a very bad idea to replace your existing data= data set.
Doesn't work is awful vague.
Are there errors in the log?: Post the code and log in a code box opened with the {i} to maintain formatting of error messages.
No output? Post any log in a code box.
Unexpected output? Provide input data in the form of data step code pasted into a code box, the actual results and the expected results. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.
Well I want to have the variables standardized in the output data set which is delivered to the cluster node. I'm not really interested in the parameters that are shown in the output....at all there are no errors, but mainly only one or no variables are standardized. Thanks a lot!
If you don't tell it what dataset to create it it will just choose a dataset name on its own. SAS creates datasets named DATA1, DATA2, ....
344 proc stdize data=sashelp.class; 345 run; NOTE: No VAR statement is given. All numerical variables not named elsewhere make up the first set of variables. NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: The data set WORK.DATA1 has 19 observations and 5 variables.
Use the OUT= option on the PROC statement to tell it what dataset to create.
proc stdize data=EMWS1.VarClus_TRAIN method=RANGE pstat
out=varclus_train_stdize
;
var NO_TRX_POS_NORM NO_TRX_12M_ONL_NORM IMP_AGE BASKET_QTY_NET_12M SUM_VAL_12M_NORM
SUM_VAL_NORM SUM_QTY_NORM
;
run;
proc cluster data=varclus_train_stdize ....
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.