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
... View more