Delimited file and variables of Interest

SASPhile — Thu, 06 Dec 2012 19:20:23 GMT

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?

Re: Delimited file and variables of Interest

jwsquillace — Thu, 06 Dec 2012 19:34:37 GMT

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

topic Delimited file and variables of Interest in SAS Programming

Delimited file and variables of Interest

Re: Delimited file and variables of Interest