topic Re: read raw data without give them names in SAS Programming

read raw data without give them names

GeorgeSAS — Fri, 28 Dec 2018 21:23:30 GMT

Hello everyone,

I want infile a raw data with comma dlm, I don't want to name for each columns so want to use a simple way:

data readraw;
infile "c:\test\abc.txt" dsd dlm=',' MISSOVER LRECL=2000  firstobs=2;
INPUT var1 $ var2 $ var3 $ var4 var5 $ /*i have total 300 columns need to be read,,,,,,,,,,;*/;

RUN;

I have 300 columns need to be read, is there an simple way to do this? like input var1 $ -- var300 ??

I know numeric variable works in this way ,but character not....

Thanks!

Re: read raw data without give them names

novinosrin — Fri, 28 Dec 2018 21:41:02 GMT

Yes

input (var1 - var300) ($);

and if you want to specify length, just do so like

input (var1 - var300) (:$8.);

or using length statement

length var1-var300 $10;
input var1-var300;

Re: read raw data without give them names

novinosrin — Fri, 28 Dec 2018 21:31:48 GMT

Also, you could try this

array var{300} $;
input var{*} ;

and if you want to specify length, just do so like

array var{300} $8;
input var{*} ;

Re: read raw data without give them names

error_prone — Sat, 29 Dec 2018 11:07:21 GMT

If you don't need all variables as character, try using proc import:

proc import file="c:\test\abc.txt"  dbms=csv  out=work.class replace;
	getnames=no;
run;

Re: read raw data without give them names

GeorgeSAS — Thu, 03 Jan 2019 17:54:37 GMT

(var1 - var5) ($);

this is good answer