About Tom

Tom · ‎10-14-2011

The problem is getting the commas past the macro call. You can quote them. %test(%str(&list1)); You should also just test whether you need the commas at all. You do not need them for the IN operator in normal SAS, but they might be required by MYSQL. In SAS code you can write : data new; set old; where id in (101 102 103); run;

Tom · ‎10-13-2011

You will have to read the file more than once. data length / view=length ; infile &fileRef delimiter='09'x dsd end=eof truncover ; length x1-x10 $200 ; input x1-x10; array var x1-x10; array len len1-len10; do over x; len = lengthm(x); end; run; proc summary data=length; var len1-len10; output out=lengths max= ; run;

Tom · ‎10-13-2011

Why? Have you considered just using the compress=yes option so that SAS will not waste space storing the extra blanks. You can either use: options compress=yes; To apply it to all future datasets. Or use it as a dataset option. data new (compress=yes); infile ...; input ... ; run;

Tom · ‎10-13-2011

Two things that you could try. 1) Check what you are setting for your helphost. Perhaps you need a more fully qualified name for your host? Try referencing that host from an independent firefox session and see if you get the same DNS error message. 2) Check if your machine is blocking ranges of ports? Check both the listen port that you specify in the rbrowser setup (and in the helpport setting in SAS) and the port that you see in the error message. (56253 in your first screen shot above for example.) I have no idea how to check this, but someone must.

Tom · ‎10-13-2011

SAS stores time in seconds. Use 15*60 to get 15 minutes.

Tom · ‎10-13-2011

Not sure what you want exactly, but perhaps using SUM will work. proc sql noprint ; create table counts as select distinct A,count(*) as count,sum(b=1) as countb1 from x group by a ; quit; Obs a count countb1 1 2 1 0 2 4 1 0 3 5 2 1 4 6 2 1 5 8 1 0 6 9 1 0

Tom · ‎10-13-2011

You do not need to count in advance when selecting values into what some people call a macro "array". Just set the upperbound to some value that is larger than the maximum you could find or process. proc sql noprint; select Warehouse , ItemCode into :Warehouse1 - :Warehouse99999 , :ItemCode1 - :ItemCode99999 from etllib.TempStoreDistinctINVNMV ; %let Whs=&sqlobs; quit;

Tom · ‎10-13-2011

Thanks. I have played with the HTML, but I am frustrated that it puts in so many redundant <font> and <span> tags. Perhaps if I start with the HTML editor I could prevent that.

Tom · ‎10-13-2011

What is a syntax box? How did you create it?

Tom · ‎10-13-2011

Did you mean to request that you want to delete the groups that only have one observation? If your data is sorted by VARIABLE1 (is it an ID variable perhaps) and there are not duplicate identical rows then you can just use FIRST./LAST. processing. data want; set have; by id; if first.id and last.id then delete; run;

Tom · ‎10-13-2011

Actually that is not true. It could be true if you were using a select statement without either an INTO or a CREATE, but that is not a real world situation where you would want to count the observations.

Tom · ‎10-13-2011

If you are really reading them from raw data then use trailing @@ on the input statement. data temp; input id @@; cards; 1 2 3 5 6 6 7 run;

Tom · ‎10-13-2011

You can use %DO to loop in macro language. Say you want the macro to loop over the variables specified in the input parameter. %macro m1 (varlist); %local i next ; %let i=1; %do i=1 %to %sysfunc(countw(&varlist)); %let next=%scan(&varlist,&i); proc freq data=data1; tables &next; run; *other commands; %end; %mend m1; %m1(age sex race);

Tom · ‎10-13-2011

With that format you should not have missing values of ZSCORE being convert to missing values of WEIGHT. What values of ZSCORE are generating missing values? Why are you sure that the values of ZSCORE are rounded to two decimal places? As you noticed with the problem that started this thread just appying a format will not change the values. What command did you use to create the value? If you read them from a text string that only included 2 decimal places then it should be ok. Otherwise you can use the round function. x=round(x, 0.01);

Tom · ‎10-12-2011

Not sure what test you want. Here is how to do a CHISQ test. data have ; input year utd count; cards; 2011 0 30 2011 1 80 2010 0 50 2010 1 75 run; proc freq ; weight count; tables year*utd / chisq; run; The FREQ Procedure Table of year by utd year utd Frequency| Percent | Row Pct | Col Pct | 0| 1| Total ---------+--------+--------+ 2010 | 50 | 75 | 125 | 21.28 | 31.91 | 53.19 | 40.00 | 60.00 | | 62.50 | 48.39 | ---------+--------+--------+ 2011 | 30 | 80 | 110 | 12.77 | 34.04 | 46.81 | 27.27 | 72.73 | | 37.50 | 51.61 | ---------+--------+--------+ Total 80 155 235 34.04 65.96 100.00 Statistics for Table of year by utd Statistic DF Value Prob ------------------------------------------------------ Chi-Square 1 4.2210 0.0399 Likelihood Ratio Chi-Square 1 4.2567 0.0391 Continuity Adj. Chi-Square 1 3.6732 0.0553 Mantel-Haenszel Chi-Square 1 4.2031 0.0404 Phi Coefficient 0.1340 Contingency Coefficient 0.1328 Cramer's V 0.1340 Fisher's Exact Test ---------------------------------- Cell (1,1) Frequency (F) 50 Left-sided Pr <= F 0.9861 Right-sided Pr >= F 0.0273 Table Probability (P) 0.0134 Two-sided Pr <= P 0.0531 Sample Size = 235

Online Status	Online
Date Last Visited	Monday