Help using Base SAS procedures

problems reading datalines

Reply
Super Contributor
Posts: 395

problems reading datalines

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..

PROC Star
Posts: 7,363

problems reading datalines

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

;

Super Contributor
Posts: 395

problems reading datalines

Thanks art, I knew I can count on you

Ask a Question
Discussion stats
  • 2 replies
  • 128 views
  • 0 likes
  • 2 in conversation