@Dataminer wrote: Hi all   I have a problem with SAS Guide - it reads data formats incorrectly - numeric data (values from 0 to 9) format is character/string. Can you suggest any code expression which converts variable format with values from 0 to 9 to numeric in the whole table?   Many thanks Do you mean Enterprise Guide?  That is a tool for running SAS code. SAS has two variable types, floating point numbers and fixed length character strings. The format attached to a variable is just instructions for how to display to values as text.    If you are reading an existing SAS dataset then it will NOT change the type of the variable (or the format attached to it either).    Did you convert some other file type into a SAS dateset?  If so what type of file?  If you asked EG to import a text file it will guess how to define each variable based on what it sees in that field of the text file.  If you asked EG to import a spreadsheet then any character value in any cell in the column will force SAS to treat that variable as text. ... View more

Generally, Y axis starts from non –zero is not suggested, especially for bar chart. Because it often brings us an illusion vision. ... View more

Thanks for your help. That quit helpful! ... View more

Two ways can get R square into a data set. For most of Stats model, OUTEST is a very useful option ODS OUTPUT statement A demo code as follows: ods output  FitStatistics=FitStat; proc reg data=sashelp.class outest=aa RSQUARE ;     model weight=age height; quit; Good luck! Hongqiu ... View more

Thanks Chris. You got exact what I mean. Editor abbreviations is a kind of choice, but may not the best choice, Since Macro I defined may have lots of  positional parameters. Auto-completion can also give some hints of what these parameters means  when I 'm typing in EG, but Editor abbreviations will not. Macro Auto-completion  can only be done in the some code node in EG.  If EG can do this in different code nodes, that would be better. Thanks. Hongqiu. ... View more

If that's the case then Tom's suggestion to use TERMSTR=CRLF should be the solution. ... View more