ProBBQ Excel 20 Bedienungsanleitung PDF herunterladen (Seite 66)

Can We Copy and Paste to SAS DATALINES?

• COPY and Paste is about as simple as it gets.

• You can copy cells from Excel, paste after a DATALINES statement.

• Paste does not line the columns up (may be a way around).

• Perhaps use List input in our data step.

• Or we could insert spaces to line up the data in columns.

Advantages:

• Extremely simple.

Disadvantages:

• We have to code a data step.

• Would only work for small files.

• Columns may not line up.

Choosing the Right Tool from Your SAS

and Microsoft Excel

Tool Belt

1 2 ... 61 62 63 64 65 66 67 68 69 70 71 ... 97 98

Keine Kommentare

ProBBQ Excel 20 Bedienungsanleitung Seite 66