BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi!

If I have a text 'Cust name is john smith'. the second time when i process I find that there is some more information that can be added - ' Cust name is john smith . did some cash transaction' . Can I just append the last line 'did some cash transaction' to the initial text? Or will I have to replace the initial text?

The reason I am asking is there is a lot of pre-processing involved to come up with the text, say there are 100 triggers. Now when only one more trigger is added, I have to append this information. It would be easier to append information so that I will not have to collect the information corresponding to the first 100 triggers in addition to this new one. But if we cannot append text in SAS I will have to collect every single info again

Thanks!
3 REPLIES 3
deleted_user
Not applicable
Is this sas table column or title/footnote of the report ?
deleted_user
Not applicable
Sorry , forgot to mention that this MSG_txt will be a column of the table.
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Given your prior post, I suspect that this is a SAS CHARACTER type variable you are working with here - please confirm? If yes, look at using the CATT function (one of the concatenate functions) in a SAS assignment statement within a DATA step. You will likely use something like CATT or CATS and you will probably append your additional data to an existing SAS variable, based on some IF / THEN ; code.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:
cat function site:sas.com

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 717 views
  • 0 likes
  • 2 in conversation