https://communities.sas.com/t5/SAS-Procedures/Variables-in-Excel-and-Data-in-Text-File/m-p/43262#M11280 Hi<BR /> <BR /> I am having variables in Excel sheet and the dataset was created and i have the data in txt file now i want to create the dataset with variables in excel and data in csv.<BR /> <BR /> Excel Variable:<BR /> name age<BR /> <BR /> <BR /> Data in Text.<BR /> sas,23<BR /> bi,45<BR /> Nani,90<BR /> kool,89<BR /> <BR /> output should be <BR /> <BR /> name age<BR /> sas 23<BR /> bi 45<BR /> Nani 90<BR /> kool 89 Wed, 20 Jan 2010 05:32:30 GMT R_Win 2010-01-20T05:32:30Z https://communities.sas.com/t5/SAS-Procedures/Variables-in-Excel-and-Data-in-Text-File/m-p/43262#M11280 Hi<BR /> <BR /> I am having variables in Excel sheet and the dataset was created and i have the data in txt file now i want to create the dataset with variables in excel and data in csv.<BR /> <BR /> Excel Variable:<BR /> name age<BR /> <BR /> <BR /> Data in Text.<BR /> sas,23<BR /> bi,45<BR /> Nani,90<BR /> kool,89<BR /> <BR /> output should be <BR /> <BR /> name age<BR /> sas 23<BR /> bi 45<BR /> Nani 90<BR /> kool 89 Wed, 20 Jan 2010 05:32:30 GMT https://communities.sas.com/t5/SAS-Procedures/Variables-in-Excel-and-Data-in-Text-File/m-p/43262#M11280 R_Win 2010-01-20T05:32:30Z https://communities.sas.com/t5/SAS-Procedures/Variables-in-Excel-and-Data-in-Text-File/m-p/43263#M11281 No need to replicate your questions through multiple sections.<BR /> <BR /> You've got your answer here:<BR /> <A href="http://support.sas.com/forums/thread.jspa?threadID=8322&amp;tstart=0" target="_blank">http://support.sas.com/forums/thread.jspa?threadID=8322&amp;tstart=0</A><BR /> <BR /> Cheers from Portugal.<BR /> <BR /> Daniel Santos @ <A href="http://www.cgd.pt" target="_blank">www.cgd.pt</A> Wed, 20 Jan 2010 09:13:56 GMT https://communities.sas.com/t5/SAS-Procedures/Variables-in-Excel-and-Data-in-Text-File/m-p/43263#M11281 DanielSantos 2010-01-20T09:13:56Z