topic Re: Adding Leading Blank to specific Observation in SAS Programming

Adding Leading Blank to specific Observation

mgowtham24 — Wed, 30 Dec 2015 06:20:56 GMT

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

Re: Adding Leading Blank to specific Observation

Ksharp — Wed, 30 Dec 2015 06:56:21 GMT

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;

Re: Adding Leading Blank to specific Observation

ad123123 — Wed, 30 Dec 2015 07:27:06 GMT

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;