Hi,   I have a very basic question about macros. I am trying to write a simple macro to merge two datasets. My code looks like this   %macro form_merge (form); proc sql; create table _%form as select a.%form,a.var1 from work.data1 as A left join work.data2 as B run; %mend form_merge;   %form_merge (X);   However, it is not working. For the 'create table' line, I get the warning "Apparent invocation of macro FORM not resolved", and the error "22-322: Syntax error, expecting one of the following (, '-'..."   When I run this as just regular code (i.e., substituting X for %form), it works fine. Can someone please tell me what I'm doing wrong?     ... View more

Hi,   I am trying to use the PUT function to convert a variable in z8 numeric format to a character format.   My code is as follows:   char_id = put(id,z8.);   where id is a numeric variable of format z8   However, when I run this the char_id variable is created, but is empty for every observations.   Thanks, Mark ... View more