About Tom

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

Tom · ‎10-12-2011

You do not what to use HEADER option on the FILE statement to generate a CSV file. It will only work with the PRINT option but then it will also generate page breaks (formfeeds) and extra header lines.

Tom · ‎10-12-2011

Not sure I understand the differences you are trying to describe. Can you provide examples? I am not sure if it really matters as I suspect that the different methods might both end up doing the same underlying steps because PROC SQL optimizers your queries.

Tom · ‎10-12-2011

If you are using a macro then you can test the automatic macro variable SQLOBS that will tell you how many observations were generated. proc sql noprint ; create table x as select * from y where id = &id ; quit; %if &sqlobs %then %do; ... other steps ... %end; Otherwise I think we would need to know the details of the other steps to suggest solutions.

Tom · ‎10-12-2011

I do not know anything about SAS Enterprise Data Management & Integration, but if you want a data step to generate a macro variable use CALL SYMPUTX in place of your PUT statement. call symputx('vcid',case_id); call symputx('vtstamp',timestamp); Note that this will only work correctly when there is only one observation. If there are mulitple observations then only the last value will remain in the macro variable as the previous values will have been overwritten.

Tom · ‎10-12-2011

See the post below from data_null_ for a more complete program. The order of the variables in the COLUMN statement is important. BREAK should be the FIRST variable, not the last. Not sure why you would use GROUP instead of ORDER for the BREAK variable. You are not requesting any grouped output. proc report data=result nowd spanrows; column break region product subsidiary stores sales inventory returns ; define region / order order=formatted; define break / order noprint; break after break /page; run; You will also see in data_null_'s responce that he used define _all_ / display; This will prevent the PROC REPORT from treating the numeric variables as SUM variables.

Tom · ‎10-11-2011

You will need to read as a string and switch the year and month position. data want ; input cdate $7.; date = input(substr(cdate,5,3)||cdate,monyy7.); format date mmddyy10.; put date ; cards; 1999MAY 2001JAN 2002FEB 1979DEC run; 05/01/1999 01/01/2001 02/01/2002 12/01/1979

Tom · ‎10-11-2011

I like the improved usability of using a single parameter to specify the dataset name versus separate libname and membername fields. You are testing the value of the parameters before you have protected them with quoting functions. You should check all of the parameters you can before bailing out. You might want to test for existence of the input dataset. You might want to exclude &SUMVAR from the list of variables to include in the sum. For even more usability you can establish defaults for some parameters. To me the only required parameter here is the target variable name. The default to the input dataset could be &syslast. The default for the output dataset could be null string so that SAS will create DATAnn where nn is the next number after the last DATAnn that it created.

Online Status	Offline
Date Last Visited	yesterday