Hi, I am new and really out of idea about the way to put the macro variable created as one number into a column in data set. Hope you all can give me some tips on it.
I have created a variable with one number, 'all_tabs'=2130.
I have a data set name gigantic, 3 column and 23 rows. Data set is created using proc sql, how can I insert the value of macro into the gigantic dataset as new variable "all_tabs_sums"?
Here is the command:
proc sql;
select *, sum(total_sales) format= 16.2 into :all_tabs
from data_info_interview;
create table gigantic as
select *
from Hall_sum ;
Just guessing.
proc sql;
select sum(total_sales) format= 16.2 into : all_tabs
from data_info_interview;
create table gigantic as
select *, &all_tabs as all_tabs_sums
from Hall_sum ;
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 25. Read more here about why you should contribute and what is in it for you!
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.