🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 09-02-2016 07:55 AM
(22482 views)
I have a syntax like below. I what to add a space between two variable. Please help me on this
text2 = cats('"/user/path`',&year,put(lastmonth,nlstrmon.),'filename.txt','"');for example I am expecting a output like below
"/user/path/2016 AUGUST filename.txt"
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Might resort to the old school way:
%let year=2016;
data test;
lastmonth=8;
text2 = cats('"/user/path/',&year,' ',put(lastmonth,nlstrmon.),'filename.txt','"');
text_want='"/user/path/'||strip(&year)||' '||put(lastmonth,nlstrmon.)||' '||'filename.txt'||'"';
run;
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Add a space before filename.txt?
Otherwise switch from the CATS() function to a different version of the CAT family of functions that honours spaces.
You can use the || operator as well.
Edit: CATT trims trailing blanks, but keeps leading blanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Might resort to the old school way:
%let year=2016;
data test;
lastmonth=8;
text2 = cats('"/user/path/',&year,' ',put(lastmonth,nlstrmon.),'filename.txt','"');
text_want='"/user/path/'||strip(&year)||' '||put(lastmonth,nlstrmon.)||' '||'filename.txt'||'"';
run;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks a lot. It works great