topic Re: Convert text file data into sas dataset in SAS Programming

Convert text file data into sas dataset

Rixile106 — Thu, 10 Mar 2022 10:21:25 GMT

good day expects

I have a text file that contains data that looks like below:-

But I want to convert the data into Sas dataset, used the below script

DATA F_FILES.MATURITY_INVEST;
	LENGTH
		'ACCOUNT NO|SERIAL|MATURITY D|OPE'n $ 47;
	LABEL
		'ACCOUNT NO|SERIAL|MATURITY D|OPE'n = "ACCOUNT NO|SERIAL|MATURITY D|OPENED DATE|CLOSED DATE";
	FORMAT
		'ACCOUNT NO|SERIAL|MATURITY D|OPE'n $CHAR47.;
	INFORMAT
		'ACCOUNT NO|SERIAL|MATURITY D|OPE'n $CHAR47.;
	INFILE '/SAS/data/RiskDataManagement/data/NWOW/data/VBM/Data/MATURITY_INVEST.TXT'
		LRECL=47
		ENCODING="LATIN1"
		TERMSTR=CRLF
		DLM='7F'x
		MISSOVER
		DSD;
	INPUT
		'ACCOUNT NO|SERIAL|MATURITY D|OPE'n : $CHAR47.;
RUN;

however am not getting the expected results. i can only see the headings from the output,

please assist

Re: Convert text file data into sas dataset

Sajid01 — Thu, 10 Mar 2022 12:57:45 GMT

Please post the sample data either in the code window or as a text file so that somebody can help.

Re: Convert text file data into sas dataset

Kurt_Bremser — Thu, 10 Mar 2022 14:33:14 GMT

Looks like you need this:

data f_filkes.maturity_invets;
infile
  '/SAS/data/RiskDataManagement/data/NWOW/data/VBM/Data/MATURITY_INVEST.TXT'
  dlm = '|'
  dsd
  truncover
  firstobs=2
;
length
  account_no $9
  serial $3
  maturity_d 4
  opened_date 4
  closed_date 4
;
informat maturity_d opened_date closed_date yymmdd10.;
format maturity_d opened_date closed_date yymmdd10.;
input
  account_no
  serial
  maturity_d
  opened_date
  closed_date
;
run;

Untested; for tested code, supply the text in a code box opened with this button:

or attach the file.