Why cant I use proc format in a macro I call. I keep getting errors with this?
%macro R061_Key_Summary_output_Subseg(Datain=, Dataout=, Seg=, Subseg=, Provider=&ProviderText, ReportDateText=,);
Data &Datain;
Set &Datain;
PROC FORMAT;
VALUE picture p8r
low - < 5 = '0009.99%'
5 - high = '0009%';
;
%mend R061_Key_Summary_output_Subseg
Also I want to create a col in a dataset using a macro.
eg
&Seg=5
This works fine, but I cannot force &Seg to be a number format. I do all the usual stuff, format &seg 1.;
And last one:
I want to use macro vars in put statements for a dde link to excel. eg:
PUT '[open("c:\SASDatafile\TMPoutput.xls")]';
but I want something like
PUT "'[open("c:\SASDatafile\&output.xls")]'";
but it always justs pasts the above statement into a cell, instead of running the put statement.
Any help appreciated, its been a long day.
N
%macro R061_Key_Summary_output_Subseg(Datain=, Dataout=, Seg=, Subseg=, Provider=&ProviderText, ReportDateText=,);
Data &Datain;
Set &Datain;
PROC FORMAT;
VALUE picture p8r
low - < 5 = '0009.99%'
5 - high = '0009%';
;
%mend R061_Key_Summary_output_Subseg
Also I want to create a col in a dataset using a macro.
eg
&Seg=5
This works fine, but I cannot force &Seg to be a number format. I do all the usual stuff, format &seg 1.;
And last one:
I want to use macro vars in put statements for a dde link to excel. eg:
PUT '[open("c:\SASDatafile\TMPoutput.xls")]';
but I want something like
PUT "'[open("c:\SASDatafile\&output.xls")]'";
but it always justs pasts the above statement into a cell, instead of running the put statement.
Any help appreciated, its been a long day.
N