Read Text File with DSL (from Fraktal SAS Programming): Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
K |
K |
||
| Zeile 16: | Zeile 16: | ||
When intending to read from a plain text file, you simply specify path and filename along with a description of the record structure. The text file shall look like this: | When intending to read from a plain text file, you simply specify path and filename along with a description of the record structure. The text file shall look like this: | ||
| − | Royal Inn#King's Suite#4#540 | + | Royal Inn#King's Suite#4#540 |
| − | The European#Standard#1#120 | + | The European#Standard#1#120 |
| − | St.Peter's#Business#2#333 | + | St.Peter's#Business#2#333 |
== Documented Code Example == | == Documented Code Example == | ||
| Zeile 37: | Zeile 37: | ||
| | | | ||
length hotel $16 category $16 no_of_beds rate_in_GBP 8; | length hotel $16 category $16 no_of_beds rate_in_GBP 8; | ||
| − | | ''' | + | | '''Allocate field space by supplying length in bytes and data type''' |
|- | |- | ||
| | | | ||
input hotel $ category $ no_of_beds rate_in_GBP; | input hotel $ category $ no_of_beds rate_in_GBP; | ||
| − | | ''' | + | | '''Specify data structure on text file''' |
|- | |- | ||
| | | | ||
Version vom 8. Juli 2014, 13:21 Uhr
|
|
|
|
What is this?
SAS can read directly from any text file. Moreover SAS can read directly from any data source that has text file properties, such as FTP, HTTP, XML or named pipes and up to DDE hotlinks.
When intending to read from a plain text file, you simply specify path and filename along with a description of the record structure. The text file shall look like this:
Royal Inn#King's Suite#4#540 The European#Standard#1#120 St.Peter's#Business#2#333
Documented Code Example
| Code executed | Function performed |
|---|---|
data plaintext; |
Initiate data step processing with a DATA statement |
infile source "&PATH.\&FILENAME." dlm = '#'; |
Specify text file's location and name and introduce the number sign '#' as delimiter |
length hotel $16 category $16 no_of_beds rate_in_GBP 8; |
Allocate field space by supplying length in bytes and data type |
input hotel $ category $ no_of_beds rate_in_GBP; |
Specify data structure on text file |
run; |
Terminate the data step |
|
|
|
|
