https://communities.sas.com/t5/SAS-Procedures/Varaiables-and-observations-in-another-Text/m-p/47711#M12842 SAS can provide several different approaches, for example, use a DATA step (with INFILE and INPUT statements) to read each external file, generating a SAS member, and then use PROC IMPORT to input the Excel file, generating a second SAS member, and a third DATA step with a SET statement to combine the two SAS member together.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> <A href="http://support.sas.com/documentation/onlinedoc/base/index.html" target="_blank">http://support.sas.com/documentation/onlinedoc/base/index.html</A><BR /> <BR /> <BR /> SUGI/SGF papers on DATA STEP processing:<BR /> <A href="http://www2.sas.com/proceedings/sugi30/134-30.pdf" target="_blank">http://www2.sas.com/proceedings/sugi30/134-30.pdf</A><BR /> <BR /> <A href="http://support.sas.com/rnd/base/datastep/dsods-sugi.pdf" target="_blank">http://support.sas.com/rnd/base/datastep/dsods-sugi.pdf</A><BR /> <BR /> SUGI/SGF paper on PROC IMPORT:<BR /> <A href="http://www2.sas.com/proceedings/sugi26/p159-26.pdf" target="_blank">http://www2.sas.com/proceedings/sugi26/p159-26.pdf</A> Thu, 18 Sep 2008 13:22:30 GMT sbb 2008-09-18T13:22:30Z https://communities.sas.com/t5/SAS-Procedures/Varaiables-and-observations-in-another-Text/m-p/47710#M12841 I have a 300 variables in one text doument and the observations for this variables are in Excel how can i read both these variables in a single dataset. Thu, 18 Sep 2008 09:10:52 GMT https://communities.sas.com/t5/SAS-Procedures/Varaiables-and-observations-in-another-Text/m-p/47710#M12841 R_Win 2008-09-18T09:10:52Z https://communities.sas.com/t5/SAS-Procedures/Varaiables-and-observations-in-another-Text/m-p/47711#M12842 SAS can provide several different approaches, for example, use a DATA step (with INFILE and INPUT statements) to read each external file, generating a SAS member, and then use PROC IMPORT to input the Excel file, generating a second SAS member, and a third DATA step with a SET statement to combine the two SAS member together.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> <A href="http://support.sas.com/documentation/onlinedoc/base/index.html" target="_blank">http://support.sas.com/documentation/onlinedoc/base/index.html</A><BR /> <BR /> <BR /> SUGI/SGF papers on DATA STEP processing:<BR /> <A href="http://www2.sas.com/proceedings/sugi30/134-30.pdf" target="_blank">http://www2.sas.com/proceedings/sugi30/134-30.pdf</A><BR /> <BR /> <A href="http://support.sas.com/rnd/base/datastep/dsods-sugi.pdf" target="_blank">http://support.sas.com/rnd/base/datastep/dsods-sugi.pdf</A><BR /> <BR /> SUGI/SGF paper on PROC IMPORT:<BR /> <A href="http://www2.sas.com/proceedings/sugi26/p159-26.pdf" target="_blank">http://www2.sas.com/proceedings/sugi26/p159-26.pdf</A> Thu, 18 Sep 2008 13:22:30 GMT https://communities.sas.com/t5/SAS-Procedures/Varaiables-and-observations-in-another-Text/m-p/47711#M12842 sbb 2008-09-18T13:22:30Z