I have a dataset named happy with only one variable.
It's like.
x
2019
New Year
Happy
Good
as x is the variable name, I want a new dataset with 2019 as the year variable, and New Year as the first line in x.
It would be like
x year
New Year 2019
Happy 2019
Good 2019
What I did was:
data new;
set happy;
retain year;
if first.x then year=y;
run;
Why doesn't that work, and how would I make it work?
data have;
input x & $10.;
cards;
2019
New Year
Happy
Good
;
data want;
set have;
retain year;
if _n_=1 then do;
year=x;
delete;
end;
run;
data have;
input x & $10.;
cards;
2019
New Year
Happy
Good
;
data want;
set have;
retain year;
if _n_=1 then do;
year=x;
delete;
end;
run;
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.
Ready to level-up your skills? Choose your own adventure.