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.
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.