Import txt file in a column to a sas data set with multiple columns

Machan69 — Sat, 11 Mar 2023 00:23:48 GMT

Hello,

Sorry I'm a beginner to sas I was hoping you can help me. I was trying to create a data set with the following columns:

name

sport

gender

weight

height

from this txt file format:

Eugene,Basketball
M_52.50_120.33
Vincent,Football
M_43.25_115.15
Chichi,Football
F_35.75_090.50
Videl,Football
F_32.65_085.50
Hanamichi,Basketball
M_69.15_145.55
Alfred,Basketball
M_52.25_135.25
Dennis,Basketball
M_55.15_123.45
Alice,Softball
F_35.30_070.50
Michael,Softball
M_72.43_111.12
Rodrigo,Softball
M_66.15_075.92
Ara,Football
F_92.88_089.99
Karla,Football
F_52.13_078.98

I was able to easily do the name and sport but having trouble with gender/weight/height since they are in the next row in the txt file.

Re: Import txt file in a column to a sas data set with multiple columns

AMSAS — Tue, 14 Mar 2023 11:35:08 GMT

The following code makes use of the INFILE and INPUT (list) statements and the INFILE DELIMITER option (DLM).
There are good examples in the documentation for further reading

Thanks

/*
	Create sample data
*/

data _null_ ;
	file "have.txt" ;
	infile cards ;
	input ;
	put _infile_ ;
cards ;
Eugene,Basketball
M_52.50_120.33
Vincent,Football
M_43.25_115.15
Chichi,Football
F_35.75_090.50
Videl,Football
F_32.65_085.50
Hanamichi,Basketball
M_69.15_145.55
Alfred,Basketball
M_52.25_135.25
Dennis,Basketball
M_55.15_123.45
Alice,Softball
F_35.30_070.50
Michael,Softball
M_72.43_111.12
Rodrigo,Softball
M_66.15_075.92
Ara,Football
F_92.88_089.99
Karla,Football
F_52.13_078.98
;
run ;

/*
	Read sample data into SAS Dataset
*/

data work.want ;
	
	infile "have.txt" dlm=",_";    /* Point to our source data, set the delimiter to comma and underscore */
	input name $ sport $ ;         /* Read the first line */
	input gender $ weight height ; /* Read the second line */
	output work.want ; 			   /* output to SAS dataset */
run ;

topic Re: Import txt file in a column to a sas data set with multiple columns in SAS Enterprise Guide

Import txt file in a column to a sas data set with multiple columns

Re: Import txt file in a column to a sas data set with multiple columns