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 ;
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.