thanks alot for the reply I'll try it ...it is different function I ever seen it some hard understand can you explain little it helps me ...
... View more
can someone explain prxchange function I didn't understand it..It really good function I ever used this way. Could someone suggest please....
... View more
Example: I'm having a variable with this value I need to split every variable with 20 length for suppose no variable value split with like "bother" ------both in one variable and ther into other variable ("But I don't see why you need to bother won't the consumer of your XPORT file just glue the cut up text back together in one variable. You could even supply the program.") Required Output: every vairble with 20 length no split words col1 -----But I don't see why you need to bother col2------won't the consumer of your XPORT col3---------file just glue the cut up text back together in col4-----one variable. You could even supply the program.")
... View more
If data contains UN----it should replace with -----01 if data contains UNK------it should replace with -----jan if data contains UN-UNK-UNKY------ it should be missing.... data have; input dt $15.; cards; 23-jan-2000 un-feb-2001 un-unk-2002 un-unk-unky un-may-1999 un-mar-2002 un-unk-2010 run; Required Output: 23-jan-2000 01-feb-2001 01-jan-2002 01-may-1999 01-mar-2002 01-jan-2010
... View more
data have; input name $30. ; if substr(reverse(strip(name)),1,1)='+' then a=reverse(substr(reverse(strip(name)),2)); else a=name; datalines; aaaaa+ bbb+aa+ dd+cc fff+aa+dd+ gg+d ; run;
... View more
data have; input name $30. ; a=compress(name,' ','ka'); datalines; aaaaa+ bbb+aa+ dd+cc fff+aa+dd+ gg+d ; run; by using compress function with keep only alphabetics we can remove '+' from the given data
... View more
How do we separate numeric variables and charcter variables from a dataset to other tow dataset one with numeric and one with character variables?
... View more
