topic Re: How to write text by using variables in New SAS User

How to write text by using variables

Nini1 — Fri, 04 Sep 2020 23:16:07 GMT

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

individual	overdue	payment
1	3	$ 20.00
2	6	$ 34.00
3	2	$ 67.00

Re: How to write text by using variables

novinosrin — Fri, 04 Sep 2020 23:23:25 GMT

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;

Re: How to write text by using variables

Nini1 — Sat, 05 Sep 2020 10:02:44 GMT

Thank you very much, it really helped