I am trying to format the header encased by Red below. Can you please guide?     Code:  proc sort data=temp_data ; By Specialist; run; %LET DATE = %sysfunc( putn( %sysfunc( date() ), MMDDYY10. )); %LET REPORT_DATESTAMP = %sysfunc(strip(&AUDIT_YEAR))-%sysfunc(strip(&AUDIT_MONTH));   /* ODS CODE */ ODS EXCEL file="/windows/Reporting/TEST_REPORT_Specilist- &REPORT_DATESTAMP..xlsx" STYLE=EXCEL options( sheet_interval="bygroup" EMBEDDED_TITLES = 'YES' EMBEDDED_FOOTNOTES = 'YES' sheet_label="#" FLOW = "Header,data" absolute_row_height = "23px" absolute_column_width = '17,32,20,20,20,10,10' EMBED_TITLES_ONCE= 'YES' EMBED_FOOTNOTES_ONCE = 'YES' start_at1='A,1' GRIDLINES = 'ON' FROZEN_HEADERS = 'OFF' ); TITLE1 j=left lspace=1 height=15pt font='Arial' BOX=2 bold color=black "Monthly Employee Scorecard"; TITLE2 j=left lspace=1 height=13pt font='Arial' color=BLACK "Reporting Period: &REPORT_DATESTAMP"; TITLE3 j=left lspace=1 height=13pt font='Arial' color=BLACK "Team : #byval(Team)"; TITLE4 j=left lspace=1 height=13pt font='Arial' color=BLACK "Team : #byval(Supervisor)"; FOOTNOTE J=RIGHT LSPACE=1 HEIGHT=10PT FONT='Times New Roman' COLOR=BLACK "Report Created On: &DATE";   PROC PRINT DATA=work.TEMP_DATA noobs style(header)=[font = ("Arial") fontsize=11pt just=center VERTICALALIGN=CENTER font_weight = bold backgroundcolor=white foreground=blue borderstyle=solid]  style (data) = [font_face='Arial' just=center VERTICALALIGN=CENTER bordertopstyle=solid bordertopwidth=0pt borderstyle=solid ]; By Specialist; Var 'Categories'n /Style(data) = {TAGATTR="Type:Sting Wrap:No" }; Var 'No_of_Random_Audited_Files'n /Style(data) = {TAGATTR="Type:Number Wrap:No"}; Var 'Total_File_Points'n /Style(data) = {TAGATTR="Type:Number Wrap:No"}; Var 'Minor_Error_Points'n /Style(data) = {TAGATTR="Type:Number Wrap:No"}; Var 'Major_Error_Points'n /Style(data) = {TAGATTR="Type:Number Wrap:No"}; Var 'Actual'n /Style(data) = {TAGATTR="Type:Number format:0.00% Wrap:No"}; Var 'Standard'n /Style(data) = {TAGATTR="Type:Number format:0.00% Wrap:No"}; RUN; ODS EXCEL CLOSE;   ... View more

Hello Friends,   I am working on a project where I have to read hundreds of html files stored as .xls into sas dataset so I can build the analytical process using that data. My initial proc import was unsuccessful. I was able to build import step in EG using File--> Import Data but can't do it for hundreds of files.   Alternately, I was successful in opening a source data file in excel(it spit a warning that file format and extension are not aligned; understandable as data is HTML and file extension is .xls) and save it as a true .xls file and then using proc import to bring the data into sas. Problem is I have hundreds of files so it is impossible to do this with all those files one by one.    I have looked for articles on importing HTML files far and wide but can't find any recent article, using which I could build my code. Latest one was 2009 but I could not replicate the method exampled in it.    Hoping community will be able to help me as always.    Thanks in advance. ... View more

Hello,   I am trying to use a legacy SQL Plus query as a step in my process where in I am trying to pass a column from my sas dataset as a constraint to the sql passthrough. This can make alot of legacy query work useful again.   Seeking advise if it is doable and how? I have trolled through the posts and haven't been able to find a plausable solution. I have in the past successfully passed single variable values as contraints to the sql passthrough queries.     Many Thanks in advance.   Example: sas dataset - work.test_ids   Passthrough query: proc sql;   connect to oracle (user=*** orapw=*** path=****);      create table work.temp as select * from connection to oracle          ( select * from oracle_schema.oracle_table where user_ids in (select distinct t1.test_users from work.test_ids t1));    disconnect from oracle; quit;         ... View more

How can I pass a table column as a parameter in a macro? Example of what I intend to do: data xyz;    input userid;    datalines; 1 2 ; run; %macro looper (userid); ... ... %mend looper; ... View more