Hi!
The following code prints one observation with 4 variables and I am trying to to find out why. So I tried printing the value of name, rate and capital for each iteration.
Please let me know how to find out values of such variables in data step.
data banks;
input name$ rate;
datalines;
FirstCapital 0.0718
DirectBank 0.0721
VirtualDirect 0.0728
;
run;
data newbank;
do year = 1 to 3;
set banks;
%put name rate capital;
capital + 5000;
end;
proc print;
run;
Thanks!
Is this what you are looking for?
data newbank;
do year = 1 to 3;
set banks;
put name = rate = capital =;
capital + 5000;
end;
run;
The use of
PUT _ALL_;
will display all variables in the Program Data Vector(PDV) which is held in memory while the data step is executed.
Instead of that %PUT statement use
PUT _ALL_ ;
Is this what you are looking for?
data newbank;
do year = 1 to 3;
set banks;
put name = rate = capital =;
capital + 5000;
end;
run;
The use of
PUT _ALL_;
will display all variables in the Program Data Vector(PDV) which is held in memory while the data step is executed.
Thanks, I was looking for name = option.
Please mark the question answered
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.