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