BookmarkSubscribeRSS Feed
arpi
Fluorite | Level 6

consider three files:

 

grade.txt

67 F 97 A 91
. M 62 F 67
35 F 77 C- 77
49 M 59 C 81

 

grade2.txt

21 M 80 B- 82
. F 90 A 93
35 M 87 B+ 85

 

grade3.txt

48 F . . 76
59 F 95 A+ 97
15 M 88 . 93

 

data combined;
infile "C:\Users\sachin\Desktop\SAS\DataSet\Learning\grades?.txt" truncover;
input age 1-2
gender $ 3-4
Mark1 5-7
Grade $ 8-10
Mark2 11-13
;
run;

This can be easily done using wildcard character (?).

 

I hope this helps!!!

rvsidhu035
Quartz | Level 8
filename fn pipe 'dir h:\temp\*.txt /s /b';
What is mean /s /b here

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 16 replies
  • 14199 views
  • 5 likes
  • 8 in conversation