Adding Leading Blank to specific Observation

[mgowtham24]

How can I add a leading blank to selected observation of a variable.

[Ksharp]

As long as your variable's length is long enough, you can use :

have='  '||have;

Otherwise you need expand its length long enough.

length want $ 200;
want='  '||have;

[ad123123]

Hi,

You can align it to Right so that it will have leading blanks. But will it solve your query.Could you please elaborate your exact problem with more details. Following code can align value of selected variable to right.

data person;
infile datalines delimiter=',';
input name $ dept $ value value1;
datalines;
John,Sales,-200,200
Mary,Accounts,-500,300
Johny,Sales,-200,200
Mak,Accounts,-100,100
;
run;

data person;
set person;
name=right(name);
dept=right(dept);
run;