topic Re: PUT FUNCTION in SAS Programming

PUT FUNCTION

robertrao — Wed, 26 Apr 2017 14:45:32 GMT

Hello,

How can i remove leading or trailing blanks from variable VAR and at the same time convert to a charecter variable VAR1

data want;

set have;

var1=PUT(strip(var),best.);

run;

Re: PUT FUNCTION

PaigeMiller — Wed, 26 Apr 2017 14:48:21 GMT

Give us a clear example of a value of var that you want to convert to var1.

The question doesn't make sense because if you want to convert to a character value, then var must be numeric and numerics don't have trailing or leading blanks.

Re: PUT FUNCTION

robertrao — Wed, 26 Apr 2017 14:55:07 GMT

THE VAR value is something like 0123456, 3456789 etc etc

This is giving me results .. Is this correct usage?

data want;

set have;

VAR1=STRIP(put(VAR,best.));

run;

Re: PUT FUNCTION

RW9 — Wed, 26 Apr 2017 15:01:42 GMT

This: 0123456

Is not a number. Hence I would assume from the that var is character, in which case you need to use string parsing functions or convert to numeric like:

var=strip(put(input(var,best.),best.));

Which highlights again why posting test data in the form of a datastep is so vital to acurately answering a question.

Re: PUT FUNCTION

robertrao — Wed, 26 Apr 2017 15:17:32 GMT

Thanks RW9.

Learnt two things here.

If my VAR is a number then this will suffice to convert to a charecter variable..

data want;

set have;

VAR1=STRIP(put(VAR,best.));

run;

If my VAR is a charecter then first convert to a numeric using INPUT?..

Then again convert to a charecter variable using PUT function and then only can I use STRIP to remove any spaces?

var=strip(put(input(var,best.),best.));

CANT I USE JUST THE BELOW TO CONVERT STRING TO NUMERIC:

data want;

set have;

VAR1=STRIP(input(var,best.));

run;

run;

Re: PUT FUNCTION

RW9 — Wed, 26 Apr 2017 15:22:45 GMT

I am quite confused with what you are asking, post some examples in a datastep of what you mean as:

If you have a character variable with spaces:
var=strip(var);

Will remove all spaces.

If you have a numeric variable and you want a character variable, then you need to put it first into a new variable:

newvar=strip(put(var,best.));

The strip() is needed as it will pad out the number to fit the best format.

Numeric variables do not have "spaces" in them, so no problem..

Re: PUT FUNCTION

ballardw — Wed, 26 Apr 2017 15:38:16 GMT

STRIP is going to tell SAS that you want a character result as STRIP is a character function.

To convert character to numeric use INPUT.

VAR1=input(var,best.);

If that doesn't do what you want then you'll have to post example data that you have and what you actually want.

Re: PUT FUNCTION

Astounding — Wed, 26 Apr 2017 15:53:23 GMT

The techniques are different, depending on whether VAR is character or numeric. You will need to know that, to apply the proper code. If you don't know, PROC CONTENTS will tell you.

For a character variable:

VAR1 = left(VAR);

There will still might be trailing blanks, but that is not avoidable. If VAR has a length of 10, there is no way to change that with a function. Even if you strip out leading and trailing blanks, SAS adds the trailing blanks back when it stores the variable using a length of 10.

For converting a numeric variable:

VAR1 = left(put(var, best.));

If you know something about the values to be found in your numeric variable, it might be better to assign a length to VAR1 before applying the PUT function:

length VAR1 $ 10;

Re: PUT FUNCTION

Tom — Wed, 26 Apr 2017 16:47:00 GMT

You can just add the -L modifier onto the format to remove the leading spaces.

If you know your numbers are intergers then no need to use the BEST format. You should include a width in your format.

char = put(intval,F17.-L);