import excel into sas and add fields

krisee — Wed, 10 Nov 2021 09:09:59 GMT

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

Re: import excel into sas and add fields

Kurt_Bremser — Wed, 10 Nov 2021 09:12:43 GMT

After the import, run

data want;
set sas_revisor;
table_alias = "TABLE_1";
/* and so on */
run;

krisee — Wed, 10 Nov 2021 09:19:02 GMT

Thank's a lot
Wish you a good day 🙂