showing specific columns from loaded from CSV file in SAS
<p>i have a question to ask,
i'm dealing with a small csv database where i need to perform some calculations with SAS, i have exported an excel file to CSV format and i want to load some columns in SAS to work with, the problem i have encountered is the order of column mismatch after loading: here is the code :</p>

<pre><code>cars6.txt
AMC,Concord,22,2930,4099
AMC,Concord,22,2930,4099
AMC,Pacer,17,3350,4749
AMC,Spirit,22,2640,3799
Buick,Century,20,3250,4816
Buick,Electra,15,4080,7827 
</code></pre>

<p>code to output data:</p>

<pre><code>DATA cars6;
  INFILE "/folders/myfolders/hbv1/cars6.txt" delimiter=',';
  INPUT  make $ model $ mpg $ weight price;
RUN;

TITLE "cars5 data";
PROC PRINT DATA=cars5(OBS=5);
RUN;
</code></pre>

<p>but i want to show only the columns: Make , weight, price ?
so how to print selected columns ?
and how to do that if i have named columns (the example differs from this one only by column names 'variables' at the beginning) but i have tried to call the columns y name , it printed them but with bad data ( the sas is taking ordered column data and ignoring the column data based on column name :</p>

<pre><code>input make $ model $ price $; 
</code></pre>

<p>thank You.</p>