Hello from Switzerland
I want to create a temp table importing some fields from an excel file and some other with fixed values:
Those are the fields:
TABLE_ALIAS, TABLE_KEY, FIELD_ALIAS, FIELD_VALUE, TASK_TYP, INSTANCE_NAME
the red ones should be fix values for all imported blue one from the excel.
the only part i could do is to import the excel file:
proc import datafile = 'sas_revisor.xlsx'
out = sas_revisor
dbms = xlsx
replace
;
run;
can someone tell me how to insert the following fix values:
TABLE_ALIAS: TABLE_1
FIELD_ALIAS: FIELD_2
TASK_TYPE:M
Kind regards
After the import, run
data want;
set sas_revisor;
table_alias = "TABLE_1";
/* and so on */
run;
After the import, run
data want;
set sas_revisor;
table_alias = "TABLE_1";
/* and so on */
run;
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.