topic Re: Import CSV file in certain order of variables in SAS Data Management

Import CSV file in certain order of variables

AZIQ1 — Fri, 30 Nov 2018 16:40:00 GMT

Hi,

I am trying to import a csv file in SAS using data step, but I want SAS read the variables as I order them

e.g.

Have:

Var3	Var2	Var1
Cat	44	Grade 1
Dog	22	Grade 3
Bird	5542	Grade 9

Want:

Var1	Var2	Var3
Grade 1	44	Cat
Grade 3	22	Dog
Grade 9	5542	Bird

When I tried to rearrange the order of variables , SAS is importing/reading it incorrectly - here is the output from SAS - Its putting the rows under different headers like this - Notice Var1 and Var3 :

Issue:

Var1	Var2	Var3
Cat	44	Grade 1
Dog	22	Grade 3
Bird	5542	Grade 9

How do I fix this without sorting the vars in the csv file

Thank you

Re: Import CSV file in certain order of variables

Kurt_Bremser — Fri, 30 Nov 2018 16:46:21 GMT

Please post your code.

Re: Import CSV file in certain order of variables

Tom — Fri, 30 Nov 2018 16:48:47 GMT

Just DEFINE the variables in a different order than you INPUT them.

data want ;
  infile 'myfile.csv' dsd truncover firstobs=2;
  length var1 $20 var2 8 Var3 $8 ;
  input var3 var2 var1;
run;

Re: Import CSV file in certain order of variables

AZIQ1 — Fri, 30 Nov 2018 16:49:21 GMT

Here is the code:

DATA &FILENEW_I;

INFILE "filepath\Test.CSV" DSD FIRSTOBS=2;

Length Var1 $6 ;

Length Var2 $8 ;

Length Var3 $6 ;

INPUT

Var1 $

Var2 $

Var3 $;

Run;

Re: Import CSV file in certain order of variables

AZIQ1 — Fri, 30 Nov 2018 16:50:59 GMT

Thank you,

Thats what I did, but its reading Var3 data in Var1 and Var1 data in Var3:

Here is my code

DATA &FILENEW_I;

INFILE "filepath\Test.CSV" DSD FIRSTOBS=2;

Length Var1 $6 ; Length Var2 $8 ; Length Var3 $6 ;

INPUT Var1 $ Var2 $ Var3 $;

Run;

Re: Import CSV file in certain order of variables

novinosrin — Fri, 30 Nov 2018 16:54:23 GMT

just follow the pattern for the compiler to get the order right

data have;
informat var1 $10. var2 8. var3 $10.;
input Var3	Var2	Var1 &;
cards;
Cat	44	Grade 1
Dog	22	Grade 3
Bird	5542	Grade 9
;