About andrew0845

andrew0845 · ‎07-10-2015

I contacted SAS Tech Support and was asked to run Log Assistant...

andrew0845 · ‎07-08-2015

Tried to install SAS 9.3 also tried 9.4 on Windows 8.1 but after clicking the installer (setup.exe), got the following error: The parameter is incorrect. Never saw this kind of error before and no idea what is "the parameter". Please help! Thanks! Andrew

andrew0845 · ‎01-14-2015

Problem was solved by Xia's suggestion! Thanks for suggestions from others as well! Andrew

andrew0845 · ‎01-14-2015

I am looping symput in a macro with a list of selected variables. I have no problem run the symput command outside the macro; But when I put it in the macro, it always report error. %marcro( varlist=,…….) %let var1 = %qscan(&varlist, i) ……… %do %while(…….); data _null_; set a1 end=no_more; call symput( 'MU'||left(_N_), &var1._Mean); call symput( 'SD'||left(_N_), &var1._stdDev ); if no_more then call symput('count',_n_); run; …………….. %end; %mend; Error message like this : NOTE: Line generated by the macro variable "VAR1". 1 PDT_Vpp_Mean ----- 22 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR, ^=, |, ||, ~=. 253: LINE and COLUMN cannot be determined. ***************** Please advise me how to solve this problem. Thanks! Andrew

andrew0845 · ‎11-13-2011

In the existing data set, the order is Nh, Nt, Nc. I know in proc freq, one can use "order=data" but not in proc boxplot. I don't want to restructure the data set. How can I solve the problem?

andrew0845 · ‎11-13-2011

Sorry I didn't make it clear. First, I'd like to use proc boxplot. Second, I'd like to control the order of the boxes in the boxplots. Not necessarily Nh, Nt, Nc, but maybe Nt, Nc, Nh. Would you please tell me how to do that using proc boxplot? Thanks.

andrew0845 · ‎11-13-2011

I'd like to use boxplot to make comparisons between three variables, say, Nh, Nt, Nc. I'd like to see the three boxplots side by side in the order: Nh, Nt, Nc. But the output displayed the boxplots in the order: Nc, Nh, Nt (alphabetically). How can I change the order to the one I want? Thanks! Andrew

andrew0845 · ‎05-20-2011

The original code is as follows: proc format; picture agegrp 1-<([0-9])3='00 Youth' 13-<([0-9])0='00 Teen' 20-<([0-9])0='00 Adult' 70-high='000 Senior'; run; < is the symbol for "smaller than". That is the way I can input the original code, otherwise, the most of part will disappear mysteriously after it is posted. What does ([0-9])3 and ([0-9])0 mean in the picture definition? Besides, if I only use < not -<, what would happend? Inclusive for the lower limit or upper limit? Thanks!

andrew0845 · ‎05-20-2011

The original code is as follows: proc format; picture agegrp 1-<([0-9])3='00 Youth' 13-<([0-9])0='00 Teen' 20-<([0-9])0='00 Adult' 70-high='000 Senior'; run; < is the symbol for "smaller than". That is the way I can input the original code, otherwise, the most of part will disappear mysteriously after it is posted. What does ([0-9])3 and ([0-9])0 mean in the picture definition? Besides, if I only use < not -<, what would happend? Inclusive for the lower limit or upper limit? Thanks!

andrew0845 · ‎05-20-2011

It's just because I cannot "cut and paste" the whole code. I don't know where the wrong is. Whenever, I cut and paste the posted message is just part of the original message I intended to post! The part posted is the part I don't understand. The other part, you can imagine, is just like a normal definition for a proc format picture. I don't undertand the following way to express a range for a value in a picture definition. I just show the uplimit of a range for a value: ([0-9])3, say. Does that mean 0*3, 1*3..., 9*3 or 3, 4,..., 93? What does that really mean? Would you please tell me how I can understand that? Thanks!

andrew0845 · ‎05-20-2011

I forgot to mention that where I saw it. I saw it at the e-book for SAS Advanced Prep. Thanks!

andrew0845 · ‎05-20-2011

It's just because I cannot "cut and paste" the whole code. I don't know where the wrong is. Whenever, I cut and paste the posted message is just part of the original message I intended to post! The part posted is the part I don't understand. The other part, you can imagine, is just like a normal definition for a proc format picture. I don't undertand the following way to express a range for a value in a picture definition. I just show the uplimit of a range for a value: ([0-9])3, say. Would you please tell me how I can understand that? Thanks!

andrew0845 · ‎05-18-2011

proc format; picture agegrp 1-<([0-9])3='00 Youth' 13-<([0-9])0='00 Teen' run; I don't understand what "([0-9])3" and "([0-9])0" mean. Thanks. Andrew

andrew0845 · ‎05-17-2011

like 4<-<([0-9])0='xx' <-What does ([0-9])0 mean?

andrew0845 · ‎05-17-2011

I found some inconsistency in the SAS Certification Prep Guide. For the maximum number of underlying tables in an inner join, in some part, it is mentioned to be 32, in another part, it is 256. Which one is correct?

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Installing SAS 9.4 on windows 8.1

Installing SAS 9.4 on windows 8.1

Re: help on macro

help on macro

output order in boxplot

output order in boxplot

output order in boxplot

Re: In a proc format picture definition

Re: proc format;

Re: proc format;

Re: Installing SAS 9.4 on windows 8.1

Installing SAS 9.4 on windows 8.1

Re: help on macro

help on macro

output order in boxplot

output order in boxplot

output order in boxplot

Re: In a proc format picture definition

Re: proc format;

Re: proc format;

Re: In a proc format picture definition

Re: In a proc format picture definition

Re: proc format;

In a proc format picture definition

the number of underlying table