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!!!
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!
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.
Ready to level-up your skills? Choose your own adventure.