Delimited file and variables of Interest

[SASPhile]

I have a pipe (|) delimited file and it doesnt have variable names.There are twenty columns.How can I read just a few say for instance column1, column7, cloum11?

[jwsquillace]

You can use PROC IMPORT  to read all the variables, then KEEP the ones you want.

PROC IMPORT OUT= WORK.test   /* your SAS data set */

            DATAFILE= "C:\temp\test.csv"   /* replace with your input data set name */

            DBMS=CSV REPLACE;

     GETNAMES=NO;

     DATAROW=1;

RUN;

data test;

  set test (keep=var1 var7 var11);

run;

VAR is the default variable name prefix when the first row is not variable names.

Jan