About ieva

ieva · ‎10-11-2011

Agree with Tom that if you want to use these formated values, new variable should be created. variable2=put(variable, avg_mbr_chrg_zscore.); Then everything should work as you expected.

ieva · ‎10-05-2011

Could this help you? SYMBOL1 V=circle C=black; SYMBOL2 V=star C=red; SYMBOL3 V=diamond C=blue; proc gplot data=test; plot var2*var1=Cluster; run; More info about symbol statement on: http://www.psych.yorku.ca/lab/sas/sgsumry5.htm

ieva · ‎10-05-2011

You should add nway option: proc means data=data1 noprint nway ; class id; var x; output out=data2 mean=x_mean; run; The extra observation you create is mean of all observations you have. You can see that in variable _type_ which shows different levels of calculations.

ieva · ‎10-03-2011

Hi, Does it ignore all code? Maybe it could be some syntax error. For example, some if or %if condition that is not true so further code is not processed. Ieva

ieva · ‎08-25-2011

Can’t explain why it exactly happens, but I think it is that format/informat question. If you add “$” before format name, it will work. DATA GENDER; RETAIN FMTNAME '$GENDER'; SET GENDER end=last; RUN; PROC FORMAT LIBRARY=WORK CNTLIN=GENDER; RUN;

ieva · ‎08-23-2011

Code similar to the one from Art, just in case if for Sundays you want the date of previous (not next) Monday, this could help: data test; informat date date9.; format date date9.; input date; datalines; 10APR2011 11APR2011 13APR2011 17APR2011 ; run; data test2 (drop=dif); set test; format wantdate date9. wantdate2 date9.; *difference to Monday as value of weekday function for Monday is 2; dif=weekday(date)-2; wantdate=date-dif; if dif=-1 then wantdate=date-6; run;

ieva · ‎08-23-2011

What exactly do you want to get? Like for each observation mark if it is first day of week or not? Or instead of week number in all places to write date for Monday (like for this week 22AUG2011) or maybe Sunday? I think you should explore weekday function.

ieva · ‎08-16-2011

Look at this paper, it shows several ways how to do that: http://www2.sas.com/proceedings/forum2008/023-2008.pdf

ieva · ‎08-11-2011

Thank you Rick and Reeza for fast and useful answers! Now everything is working just great!

ieva · ‎08-11-2011

Hi, I want to calculate winsorized means for quite many (several thousands) of class variables and later use these results in other procedures so I need to get them in data set. With the following code it works fine for small number of class variables, but if there are many, log and listing just gets too crowded. ods trace on ; ods output winsorizedmeans=means (keep= classvar mean rename=mean=winsorized_mean) ; proc univariate winsorized = 0.10 data=mydata; class classvar; var var1 ; run ; ods trace off ; Could anyone please suggest me what to do? I know how to change so that there is no listing output, but that doesn't solve huge log problem. Maybe I'm just doing it in too complicated way and there is easier way to get winsorized mean values? Thank you, Ieva

ieva · ‎08-03-2011

Editor's note: This topic is very popular. Thanks to @ieva and @data_null__ for useful replies. We've consolidated those here to make it easier for future learners. I suppose, you want to change all numeric variables. Try this: data yourdata; set yourdata; array change _numeric_; do over change; if change=. then change=0; end; run ; @ieva's solution works well with Base SAS. If you have SAS/STAT (most users do), then you can use PROC STDIZE as shared by @data_null__: /* create test data set */ data missing; set sashelp.class; if mod(_n_,2) eq 1 then call missing(of _numeric_); run; proc print; run; proc stdize out=zeros reponly missing=0; run; proc print; run;

ieva · ‎07-29-2011

You mean you want to leave just unique combinations and with additional rule that store1 should not be the same for both stores? In case if it is the same, which store combination (with 2648 or 6453) you want to keep? This could work: *get unique combinations; proc sort nodupkey data=yourdata; by store store1; run; * keep each store1 just one time; proc sort nodupkey data=yourdata; by store1; run;

ieva · ‎07-28-2011

This should work as well: %macro combine; data final; set %do i=3 %to 10; d&i %end; ; run; %mend; %combine;

ieva · ‎07-15-2011

I think the easiet way would be just writing it together with variables like: %sort_it(B, var1 descending var2); %sort_id (AB, descending var1);

ieva · ‎07-15-2011

Not a single step, but a simple macro could make your code look nice %macro sort_it (name, variables); proc sort data=&name; by &variables; run; %mend; %sort_it(A, var1); %sort_it(B, var1 var2); %sort_id (AB, var1);

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

Please help me...

Reg:Date in DD-MMM-YY

Mathematical calculations

Please help me...

How to print all numeric values except 1 variable

Mathematical calculations

Output every 30 records

Proc means: can I use it in this manner?

Marking outlier names on graph

Creating new smaller dataset from a larger one

Any free/express edition

It's Monday

timeout on user id

Re: proc means by group

User written code had been ignore

How to set the significance level alpha?

How to set all missing values to zero for all variables?

Creating new smaller dataset from a larger one

Re: Help with Proc Format

cluster analysis

Re: proc means by group

User written code had been ignore

This range is repeated, or values overlap

Display first Day of week from Week Number

Display first Day of week from Week Number

how to display full path of SAS program in the editor?

winsorized mean

winsorized mean

How to set all missing values to zero for all variables?

Fetching records with unique value

Merging Files Automatically

Could any one let me know whether multiple datasets can be sorted in a...

Could any one let me know whether multiple datasets can be sorted in a...