Defining the format

m1986MM — Fri, 30 Jan 2015 00:39:12 GMT

Hello everyone;

I tried to import a dataset and set the guessing row equal to 20,000. However, formats of the variables are nor what they should be. So I need to define formats of the variables. The following in my primary code.

proc import datafile="F:\Address of the file.txt"

dbms=dlm

out=test

replace;

delimiter='|';

getnames=yes;

Guessingrows=20000;

run;

I used the following code to define variable's format, but it didn't work.

proc import datafile="E:\Mobina\wo23370_LSU\Deposits\depositRateData_1998_03.txt"

dbms=dlm

out=depositRateData_1998_03

replace;

format rate 5.3;

format apy 5.3;

format datesurveyed yyyymmdd10.;

format comment $30;

delimiter='|';

getnames=yes;

run;

I appreciate any suggestion.

Re: Defining the format

Reeza — Fri, 30 Jan 2015 01:17:27 GMT

You need to write a data step to import the file instead.

Your proc import will create the code in the log. Copy and paste that from the log into the editor and edit it as needed.

topic Re: Defining the format in SAS Procedures

Defining the format

Re: Defining the format