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..
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
;
Thanks art, I knew I can count on you
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: