https://communities.sas.com/t5/SAS-Procedures/Populate-observation/m-p/29048#M6795 Check the CATX function, it may be a solution to your problem.<BR /> [pre]<BR /> address = CATX("\n", var1, var2, var3) ;<BR /> [/pre] Thu, 03 Jul 2008 11:37:32 GMT Olivier 2008-07-03T11:37:32Z https://communities.sas.com/t5/SAS-Procedures/Populate-observation/m-p/29047#M6794 We have a requirement to populate an address field from database observation, please help.<BR /> <BR /> The values will be extracted with more than one variable, <BR /> like VAR1 = #1C, RMG CAMPUS,<BR /> VAR2 = MG STREET, <BR /> VAR3 = TN. <BR /> <BR /> Format should be like below:<BR /> Name Contact_no Address<BR /> Shan 999999999 <B> #1C, RMG CAMPUS,\n<BR /> MG STREET,\n<BR /> TN.</B>\n Thu, 03 Jul 2008 09:12:00 GMT https://communities.sas.com/t5/SAS-Procedures/Populate-observation/m-p/29047#M6794 deleted_user 2008-07-03T09:12:00Z https://communities.sas.com/t5/SAS-Procedures/Populate-observation/m-p/29048#M6795 Check the CATX function, it may be a solution to your problem.<BR /> [pre]<BR /> address = CATX("\n", var1, var2, var3) ;<BR /> [/pre] Thu, 03 Jul 2008 11:37:32 GMT https://communities.sas.com/t5/SAS-Procedures/Populate-observation/m-p/29048#M6795 Olivier 2008-07-03T11:37:32Z