CODEWITHSUNDEEP
importsasdelimiter
AnkP
AnkP

Reputation: 651

Import file with two delimiter in SAS

I have a .scores file with two delimiters space and comma. I need to import it sas and not able to do it with regular import command. The format is as follows

832783_9399 973299,03200 238003

Thanks!

Upvotes: 1

Views: 484

Answers (1)

Kiran
Kiran

Reputation: 3315

you can use multiple delimiters in dlm as show below

 data want;
 infile datalines dlm=' ,'  ;
 informat var1 var2 var3 var4 $60.;
input var1  $ var2 $ var3 $ var4 $;
datalines;
832783_9399 973299,03200 238003
;

Upvotes: 4

Related Questions