About ieva

ieva · ‎11-29-2011

This could be the solution you are looking for: proc sort data=table_1; by aid descending idcab; run; data table_2 (drop=idcab rename=idcab_mod=idcab); set table_1; by aid descending idcab; retain idcab_mod ; if first.aid then idcab_mod =idcab; run;

ieva · ‎11-28-2011

Hi, The closest format I could find was ddmmyyd10. It outputs date in form 15-09-10. Maybe it helps. Ieva

ieva · ‎11-28-2011

Thank you Rick and Ksharp for the explanations!

ieva · ‎11-25-2011

Try: data table_2 (drop=idcab rename=idcab_mod=idcab); set table_1; retain idcab_mod ; if idcab ne '' then idcab_mod =idcab; run;

ieva · ‎11-25-2011

Hi, You can specify dataset name which you want to print and after that name add option which variable you want to drop. proc print data=yourdata (drop=c); var _numeric_; run; Regards, Ieva

ieva · ‎11-25-2011

Hi, I am wondering how far SAS can be used for mathematical calculations. Is there some way to use SAS for such operations like: a) 1/0 = infinity 0/0 =NaN (not a number) b) Somehow solving formulas. For example like in MatLab finding differential: diff(X^3) ans=3X^2 Sometimes it seems that SAS is a super-tool with all included J Or maybe this is an area where SAS can’t be used? Ieva

ieva · ‎11-17-2011

I think you need to know the date. Otherwise you don’t know if ‘366’ is last day of a leap year or first day of next year. Other solution could be to have these day numbers starting from 1 every new year: 363 364 365 1 2 3 4 ..

ieva · ‎11-14-2011

Try after you get those results of PROC MEANS doing the following: * select the value of your macro variable; data _null_; set DS1; call symput('outvalue', mymedian); run; %Put outvalue is &outvalue; *keep only n-1 observations to DS1 data set; data DS1; set DS1 end=last; if last then delete; run;

ieva · ‎11-14-2011

Thank you! This seems as a good, simple aproach!

ieva · ‎11-08-2011

Hi, Sounds like you need to use PROC TRANSPOSE. In your data, do you have a variable indicating week number? data test; input product $ 1-9 price $ week $; datalines; Product A aPrice1 201101 Product A aPrice2 201102 Product A aPrice3 201103 Product A aPrice4 201104 Product A aPrice5 201105 Product B bPrice1 201101 Product B bPrice2 201102 Product B bPrice3 201103 Product B bPrice4 201104 Product B bPrice5 201105 ; run; proc sort data=test; by week; run; proc transpose data=test out=test_transposed (drop=_name_); by week; id product; var price; run;

ieva · ‎11-03-2011

Ah, then it is because device=activex.

ieva · ‎11-03-2011

Thank you for suggestion! I'm using SAS 9.1.3. When running your code I get labels for all observations. And when I try to change outlier_text to variable name (not height) also nothing is changing. Is my SAS version too old for this?

ieva · ‎11-02-2011

Hi, I would like to make a graph by 2 variables, create different colour labels for 3 different groups and be able to marke some specific observations (like outliers) in final graph. So my code: proc gplot data=mydata; plot var2*var1=groupname/frame cframe=ligr legend=legend1 vaxis=axis1 haxis=axis2; run; What I get what I need - values of those 2 variables by group names, but I can’t understand is there any possibility to mark in the graph which are those outlying observations? I would appreciate if somebody of you could help. Thank you, Ieva

ieva · ‎10-14-2011

Try using %test(list1); if you add & before that, macro variable is resulved already in this step, that is why it fails.

ieva · ‎10-11-2011

I think there are no strict rules for optimal number of clusters and as in all cluster analysis – there is a lot of room for variations and interpretation. Maybe someone can give more specific criteria, but the ones I would consider: * Use of graphical analysis to understand if your clusters are well separated, maybe some are very close and can be joined. I think also a tree (PROC TREE) is a very useful tool. There you can see how many groups (more separated tree branches) you have. * Most likely you wouldn’t like to have clusters with just 1 or few observations. * In some cases your data or task can give hint about number of clusters (e.g. maybe you want to separate items with high, low and middle level of something).

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

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

Marking outlier names on graph

Marking outlier names on graph

Marking outlier names on graph

Calling a Macro variable from a macro variable

Optimal number of clusters