BookmarkSubscribeRSS Feed
lloraine
Calcite | Level 5
For some reason I couldn't reply to my other post. I hope this is OK.


I tried the following:
ods msoffice2k file='N:\admin\Linda\SAS\CHM_ClientLevel.xls' style=minimal;
proc print data=WORK.CHM_CLient_Level label noobs;

var CL_N / style(data)={htmlstyle='vnd.ms-excel.numberformat:@'};
var CL_EFF_FRM_DT / style (data)={htmlstyle='mso-number-format:mm\/dd\/yy'};
var CL_NM CL_EFF_FRM_DT CL_EFF_TO_DT CL_CAN_DT CL_REIN_DT CHM_ENROLLMENT_TYPE CHM_ENROLLMENT_IDENTIFIER CLIENT_STATUS
ACTIVEC1 CANCELC1 ACTIVEM1 CANCELL1;
format CL_EFF_FRM_DT MMDDYY8.;
run;
ods _all_ close;
ods listing;

I got errors after the ODS statement - ERROR 180-322: Statement is not valid or it is used out of proper order.
1 REPLY 1
Cynthia_sas
SAS Super FREQ
Hi:
Are you running SAS 8, still??? MSOFFICE2K destination was first available in SAS 9. If you are still SAS 8, then you'll have to change the ODS invocation to:
[pre]
ODS HTML ...
[/pre]

That's the only thing I can think of. Otherwise, if that doesn't work, your best bet for help is to contact Tech Support.

cynthia

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 619 views
  • 0 likes
  • 2 in conversation