topic Re: Import file with $ as delimeter in SAS Programming

Import file with $ as delimeter

sunayana67 — Mon, 31 May 2021 06:33:15 GMT

You are given a text file company.txt where dollar signs were used as delimiters. To indicate missing values, two dollars signs were entered. Values in this file represent last name, employee number, and annual salary.
Using this data file as input, create a SAS data set called Company with the variables LastName (character), EmpNo (character), and Salary (numeric).

I ran this program, in the log there is error while reading one of the records.

Code I used:

data Company;
infile "~/company.txt" dlm = '$';
input LastName $ EmpNo $ Salary;
run;

Can anyone help me out with how I can read that record?

Re: SAS Programming

Astounding — Sun, 30 May 2021 13:25:06 GMT

In addition to using dsm='$' on the INFILE statement, add one more option: dsd

That's what tells SAS that each $ delimits a separate variable.

Re: SAS Programming

ChrisNZ — Sun, 30 May 2021 22:51:37 GMT

Please change the title to something meaningful.

Re: Import file with $ as delimeter

Ksharp — Mon, 31 May 2021 12:47:53 GMT



data Company;
infile "c:\temp\company.txt" dlm = '$' dsd truncover termstr=lf;
input LastName $ EmpNo $ Salary;
run;