hi .. another idea ...
data have;
input (ABC F1 F2 FDG)($);
cards;
ID Name Sex Country
1 ABC M IND
2 BCD F USA
3 CDE M GER
4 DGE M UK
;
filename nosee dummy;
data _null_;
file nosee;
set have (obs=1);
put (_all_) (=) @;
call symputx('rename',_file_);
run;
data have;
set have (firstobs=2 rename=(&rename));
run;
Wow! That is mighty clever.
PG
hi ... among the many things I have learned from Howard Schreier is neat stuff you can do with _FILE_ ...
http://www.listserv.uga.edu/cgi-bin/wa?A2=ind0811b&L=sas-l&P=23589
Hi Mike,
Thank you! I tried to help this OP to find a better solution: https://communities.sas.com/thread/34279
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.