BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Nini1
Obsidian | Level 7

Hello everyone,

 

I'm new SAS user. I have such type of a problem. I have a data with individual identifier, number of days and payment. I want to create a new column for each individual in which there will be written a text something like this: Hello,  you have 3 days of overdue and please pay 20$ asap for the first individual, Hello,  you have 6 days of overdue and please pay 34$ asap for the second individual and so on.

Could you please help me to solve this problem?

Thank you in advance

individualoverduepayment
13 $   20.00
26 $   34.00
32 $   67.00
1 ACCEPTED SOLUTION

Accepted Solutions
novinosrin
Tourmaline | Level 20
data have;
input (individual	overdue	payment) ($);
cards;
1	3	 $20.00
2	6	 $34.00
3	2	 $67.00
;

data want;
 set have;
 descrip=catx(' ','Hello,  you have', overdue,'days of overdue and please pay',payment,'asap');
run;

View solution in original post

2 REPLIES 2
novinosrin
Tourmaline | Level 20
data have;
input (individual	overdue	payment) ($);
cards;
1	3	 $20.00
2	6	 $34.00
3	2	 $67.00
;

data want;
 set have;
 descrip=catx(' ','Hello,  you have', overdue,'days of overdue and please pay',payment,'asap');
run;
Nini1
Obsidian | Level 7
Thank you very much, it really helped

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 595 views
  • 3 likes
  • 2 in conversation