topic how to a variable from another variable with some values leading blank space in SAS Programming

how to a variable from another variable with some values leading blank space

knveraraju91 — Thu, 13 Jun 2019 23:47:56 GMT

Dear,

I need to create a variable with some values containing leading values.

output needed in dataset 'two' for variable 'c'

all

aaa

bbb

ddd

In the above output, i need to have leading blanks for all except first value 'all'. Please suggest. Thank you


data one;
input a b$;
datalines;
1 all
2 aaa
3 bbb
4 ddd
;
data two;
set one;
if a=1 then c=a;
else c=  a;
run;

Re: how to a variable from another variable with some values leading blank space

heffo — Fri, 14 Jun 2019 00:52:22 GMT

If you just want a leading space I would use the cat function. I would also use strip to make sure that there are no spaces to begin with in the variable a.

data two;
set one;
if a=1 then c=a;
else c=  cat(" ",strip(a));
run;

Or am I missing something more?

Re: how to a variable from another variable with some values leading blank space

Reeza — Fri, 14 Jun 2019 02:11:39 GMT

What do you need the leading blanks for? PROC REPORT now has an indent option within the style or somewhere at least that can control indents.

Re: how to a variable from another variable with some values leading blank space

Kurt_Bremser — Fri, 14 Jun 2019 08:07:06 GMT

Blanks in code are never blanks in data. Blanks in code are just separators between code elements. To have blanks as data, you need to make that clear to the data step compiler by using quotes and the proper concatenation operator:

a = "  " || a;

Note that this may cause the truncation of the values in a.