How can I add a leading blank to selected observation of a variable.
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;
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.