zilok Tracker

Re: weight of evidence for character variables

zilok — Fri, 21 Sep 2012 04:01:23 GMT

I would suggest to create proc format dynamically. Please read proc format into plain text and use %include.

I know this is not the to_the_point solution.

Re: Can we use proc univariate for getting a clue on group cut off lines

zilok — Thu, 12 Jul 2012 03:22:21 GMT

You can use proc univariate to create 20 groups/10 equal groups.

One way is to use proc rank with groups=10 option

SAS Code:

proc rank data = have groups = 10 out = out1;

var income;

ranks predgroup;

run;

Here out1 will have rank variable taking values 0 to 9. 10 equal groups.

Another way is to use proc univariate with output statement;

SAS Code:

proc univariate data = have;

var income;

output out=out1 pctlpts = 10 to 100 by 10 pctlpre = inc;

run;

This gives you 10%,20%...90% & 100% percentile points.

You can create proc format to create formats which can be easily used over the course of diff programs.

There are some advantages in using proc univariate:

1. Weight option is available in proc univariate(not available in proc rank)

2. You dont have to create the whole dataset again. It is simple

Thanks,

zilok

Re: When to use %IF and IF in Macros?

zilok — Thu, 12 Jul 2012 03:12:00 GMT

IF is used inside a datastep. %IF is used in open code. You can always use %IF instead of IF.

Re: Is there any more clever way to do it?

zilok — Sun, 19 Jun 2011 00:01:09 GMT

DATA work.check;
SET work.test;
FORMAT a valuefmt.;
FORMAT b valuefmt.;
RUN;

Re: compare colums to create new coloum

zilok — Sat, 18 Jun 2011 23:54:46 GMT

If this is your objective, a simple solution is to reverse sort the data and do the following:

format date1 ddmmyyyy10.;
if id = lag(id) then date1 = lag(date);

and sort back the data to its original form.
Use _N_ to reverse sort the data.

Thanks,
zilok