ProBBQ Excel 20 Bedienungsanleitung PDF herunterladen (Seite 71)

Can SAS Read the CSV File?

• The DSD INFILE option separates at the commas.

• FIRSTOBS= option can ignore the header line.

data softsale;

infile 'c:\temp\test.csv' dsd firstobs=2;

input Name $ Division $ Years Sales Expense State $;

run;

proc print data=softsale;

run;

Advantages:

• DSD does most of the work.

• and only Base SAS is needed.

Disadvantages:

• We have to code, specify column names, types, and lengths.

Choosing the Right Tool from Your SAS

and Microsoft Excel

Tool Belt

1 2 ... 66 67 68 69 70 71 72 73 74 75 76 ... 97 98

Keine Kommentare

ProBBQ Excel 20 Bedienungsanleitung Seite 71