Hello,   There might be possibilities in the stat procedure itself, but if you want to do it (centering) beforehand, submit below code and check if that is what you want : proc stdize data=sashelp.class method=mean out=work.abc_xyz; var _NUMERIC_; run; proc means data=work.abc_xyz; var _NUMERIC_; run; /* end of program */ Koen ... View more

Even for procedures that do not support the CLASS statement, there is no need to generate dummy variables yourself. Several SAS procedures support methods to generate dummy variables and output them to a data set for analysis. Consider using the GLMSELECT procedure, as described in the article, "The best way to generate dummy variables in SAS." ... View more

The last ERROR is always the least important. The first ERROR or WARNING is most important. And before you start making code dynamic, make sure that it works. Run your import code without any macro variables, and post the complete log of the step if it fails. Use a window opened with </> to post the log. ... View more

When referencing an error please copy from the log the entire procedure along with all the messages for the step that throws the error. Then paste into a code box on the forum opened using the {I} icon. The code box will preserve formatting of the error messages and many will generate an underscore or two showing where the syntax issue was encountered.   For instance in your case I suspect you have a more complete log entry similar to : 39 proc freq data=gene env; --- 22 202 ERROR: File USER.GENE.DATA does not exist. ERROR 22-322: Syntax error, expecting one of the following: ;, (, COMPRESS, DATA, FC, FORMCHAR, NLEVELS, NOPRINT, ORDER, PAGE. ERROR 202-322: The option or parameter is not recognized and will be ignored. This indicates that you have a space in the middle of your data set name, whether it was supposed to GENEENV or GENE_ENV or similar. Fix the data set name. ENV by itself is not an option of Proc Freq hence the wording of : ERROR 22-322: Syntax error, expecting one of the following: ;, (, COMPRESS, DATA, FC, FORMCHAR, NLEVELS, NOPRINT, ORDER, PAGE. Please notice that there are 3 underscore characters under the word ENV in the error message. Which is pretty clear about indicating that is not a valid option.   The Entire procedure or data step is needed because sometimes the error cause actually can come from something missing in lines above the reported location.  ... View more

The first code line of code is not valid SAS syntax. If you intend it as a comment, it should start with an asterisk (*). Moreover, the code should be part of a data step, i.e. it should start with a data statement. You must also tell SAS where to get the value for LENFOL, likely with a set statement.   data myNewDataset; set myOldDataset; * Rescale time variable from days to years; years = lenfol / 365.25; run; ... View more