topic Re: Stuck with silly thing in SAS Programming

Stuck with silly thing

shahparth260 — Thu, 11 Apr 2019 16:41:34 GMT

Hello,

Every one

Have :

var1

-1

34.56

Zero

want

var1 var2

+2 +2

3+ 3+

-1 -1

4- 4-

34.56 .

Zero Zero

NA NA

I am converting character to numeric, I am using

input(strip(var1), ?? best.);

but problem is when use this syntx I am not able to get var2 correct for +3,+2, or such values but I am getting correct values for 3+,2+ ,zero, NA

my data has +3 and I need it +3 in to var2.

Thanks in advance

Re: Stuck with silly thing

PaigeMiller — Thu, 11 Apr 2019 16:45:25 GMT

Is the requirement that var2 has to be numeric? You don't specifically state that. Leaving var2 as character makes everything simple.

If so, then you would need to create a specific picture format for your situation.

Re: Stuck with silly thing

shahparth260 — Thu, 11 Apr 2019 16:48:24 GMT

Thanks for responding on the question. Yes I think I forget to mention about that.

Var1 is in Character

Var2 is also in Character I just dont want to see any Numeric values in to this such as 9,4.5, 8.937, so on

Thanks again.

Re: Stuck with silly thing

novinosrin — Thu, 11 Apr 2019 17:00:58 GMT

@shahparth260


data have;
input var1 $;
cards;
+2 
3+ 
-1
4-
34.56
Zero
NA
;

data want;
set have;
var2=ifc(notdigit(compress(strip(var1),'.')),var1,' ');
run;

Re: Stuck with silly thing

novinosrin — Thu, 11 Apr 2019 17:07:49 GMT

Less convoluted


data have;
input var1 $;
cards;
+2 
3+ 
-1
4-
34.56
Zero
NA
;

data want;
set have;
if notdigit(compress(strip(var1),'.')) then var2=var1;
run;

Re: Stuck with silly thing

shahparth260 — Thu, 11 Apr 2019 17:17:47 GMT

@novinosrin Thanks for posting solution on that. I really appreciated for simple version however I figured for IFC but may be it helps for novice. Thanks again keep helping 🙂 🙂