topic problems reading datalines in SAS Procedures

problems reading datalines

podarum — Wed, 09 Nov 2011 03:44:03 GMT

I received a code from an outside source and can't get in my own format: I got (HAVE) and I want it to look like (WANT):

HAVE:

data temp1;

infile cards dlm=',' missover

;

input

COL1

COL2

COL3

COL4

COL5;

rename

COL1=Ref_Date;

rename

COL2=GEO;

rename

COL3=AREA;

rename

COL4=STR;

rename

COL5=Value;

datalines

;

199001,"Canada","All areas","Residential (x 1000)",2400224

199602,"Newfoundland and Labrador","All areas","Residential (x 1,000)",16567

run;

WANT it cleaned up, you know what I mean once you run it. Thanks.. Also I don't know why I can't just insert the sas code neatly in this post..

art297 — Wed, 09 Nov 2011 03:54:39 GMT

data temp1;

infile cards dsd dlm=',' missover;

informat GEO area str $20.;

input Ref_Date GEO AREA STR Value;

datalines;

199001,"Canada","All areas","Residential (x 1000)",2400224

199602,"Newfoundland and Labrador","All areas","Residential (x 1,000)",16567

;

podarum — Wed, 09 Nov 2011 04:26:07 GMT

Thanks art, I knew I can count on you