Hi everyone, I am trying to import a pipe delimited .txt file with 5000 observations and 89 variables into SAS. There are a couple of issues with this data that I am trying to work around: Between observations, there is no space or carriage return. This means that between the value for the last variable of a particular observation and the value for the first variable of the next observation, there is no space or carriage return to indicate that what follows is a new observation. SAS does import some of the observations correctly, however, there are a few cases where SAS is unable to parse the first variable and thus returns a missing observation. Is there a way I can work around this issue without going into the text file and manually adding a carriage return? There is no header line with variable names, therefore SAS imports the data with generic variable names (i.e. VAR1, VAR2, etc.). I have imported a list of variable names that I created in Excel based on a SQL query and assigned them to a macro variable. Is there a way I can use this macro variable of the variable names (with a single space between names) to assign the variable names? Here is the code that I am trying to work with: proc import out = data_import
datafile = "&filepath/2018_JAN_5000.txt"
dbms = DLM replace;
delimiter = "|";
getnames = NO;
DATAROW = 1;
run;
proc sql;
select sas_variable_name
into: variable_names separated by " "
from variable_order
;
quit;
%put &variable_names.;
data data_import_2;
set data_import;
retain &variable_names.;
run; Thanks in advance for your help! ap1994
... View more