how to input data file with semicolon and add variable name

fighting123 — Fri, 23 Oct 2020 08:18:35 GMT

PROC IMPORT DATAFILE = 'C:\Users\TSE\s208034\Vegas_edit.dat'
OUT = Vegas DBMS =  TAB REPLACE;
DATAROWS=1;
DELIMITER=' ; ';
GETNAMES=NO;
INPUT country $  review $  hotel_review $ help_vote $ score $ stay $ type $ pool $ gym $ tennis $  spa $  casino $ internet $ name $ stars $ rooms $ user $
member $  date $ month $  weekday;
RUN;

I want to input the dataset that is dat file with semicolon and add variable name

can someone tell me where is wrong and teach me pls

Re: how to input data file with semicolon and add variable name

Kurt_Bremser — Fri, 23 Oct 2020 08:31:17 GMT

Use

dbms=dlm

in the PROC IMPORT statement. TAB forces a tabulation character ('09'x) as delimiter.

In the long run you will be better off to copy the data step code created by PROC IMPORT from the log, adapt it to your needs and use that in the future for consistency.

topic Re: how to input data file with semicolon and add variable name in New SAS User

how to input data file with semicolon and add variable name

Re: how to input data file with semicolon and add variable name