yyangca Tracker

Re: Column width changed after add %stpbegin and %stpend

yyangca — Tue, 23 Apr 2013 23:23:44 GMT

Hi Q,

You have raised a very interesting question. _ODSSTYLESHEET is stored in my computer. Is it possible the reason I have gotten the right result could be my computer has SAS EG installed? I am interested in seeing what will happen if I test it on a computer without SAS EG installed.

It's a good suggestion to view the source html. I compare it with the codes in SAS EG. The column width matches. This is an example of the column width in source html:

th class="l t rowheader" style=" font-size: x-small; width: 3.25in;" scope="row">STATEWIDE </th>

But no matter how I change the number of inches for column width, I got the same results. Thanks very much for your inputs!

Ying

Re: Column width changed after add %stpbegin and %stpend

yyangca — Tue, 23 Apr 2013 17:41:10 GMT

Hi Cynthia,

I have read several of your papers regarding ODS and stored process. I highly respect your knowledge and thought about to contact you. I am so happy to see your reply.

I run this stored process using "SAS Stored Process Web Application". I have submitted a ticket to SAS support for this issue. Thanks a lot!

Ying

Column width changed after add %stpbegin and %stpend

yyangca — Mon, 22 Apr 2013 23:58:23 GMT

I am working on a stored process which will be used as a web application for people query the data via website. Everything works perfect on SAS EG until we test on the website http://sas/.

I have defined the column width by using style=[outputwidth=3.25in] etc. in Proc tabulate (see teh code below). The columns look perfect when I run the Stored Process in SAS EG with default style “Ocean”.

Before moved to web application, I have added %stpbegin and %stpend. It seems that this overwrites the column width I defined in Proc Tabulate. The column width changed. My codes are below. Could anyone tell me how to keep my column width after use %stpbegin and %stpend? Thanks in advance for your help!

%global wantreg _odsdest _odsoptions _odsstyle _odsstylesheet;

%let _odsdest=html;

%let _odsoptions= rs=none;

%let _ODSSTYLE=Ocean;

%let _ODSSTYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/5.1/Styles/Ocean.css");

%stpbegin;

PROC TABULATE

DATA=VU_Statewide FORMAT =FREE12.;

VAR Vol_Uti;

CLASS Year / ORDER=UNFORMATTED MISSING ;

CLASS hospname / ORDER=UNFORMATTED MISSING;

CLASS Procedures / ORDER=UNFORMATTED MISSING ;

classlev hospname /style=[outputwidth=3.25in font_size=2 ];

classlev procedures /style=[outputwidth=1.25in font_size=2 ];

classlev Year /style=[font_size=2] ;

TABLE

hospname =' ' , Year=' ' *Procedures=' ' *(Vol_Uti=' ' * Sum=' ' )/box={label=' ' /*Style=[background=BURLYWOOD]*/};

RUN;

Quit;

%stpend;

Import string with double dash from Excel

yyangca — Mon, 27 Feb 2012 21:57:26 GMT

Replace DBMS=xls with DBMS=EXCEL in my original proc import. That way data are read in with "–" displayed correctly. I just marked the anwser from HIMA as correct answer. Thank you!

Import string with double dash from Excel

yyangca — Mon, 27 Feb 2012 21:16:57 GMT

Awesome. It works!! Thank you so much for your help.

Import string with double dash from Excel

yyangca — Mon, 27 Feb 2012 20:56:35 GMT

My SAS codes:

proc import datafile="Z:\project1\myfile.xls" out=hosp DBMS=xls replace:

run;

Samle data in Excel is like:

Hosp1	Hosp2
hospital name – sample 1	hospital name – sample 2

The data after read in SAS:

hospital name !! sample 1

hospital name !! sample 2

Thanks!

Import string with double dash from Excel

yyangca — Mon, 27 Feb 2012 19:06:18 GMT

Hello,

I try to use proc import to import charactor variables (length $80. ) including double dash (–) from Excel 97-2003 worksheet. I use SAS 9.2 version. The double dash becomes to !! after imported to SAS. Could you please help? Thanks in advance.

Ying