topic Re: Displaying the sas dataset when right clicked and viewed in Excel in SAS Programming

Displaying the sas dataset when right clicked and viewed in Excel

Imroze — Thu, 23 Jan 2014 06:19:24 GMT

Hi,

I have a dataset with variable value containing Message information. When I read the Message from the text document I am appending the values from different observations and the complete text is comming in one line.

Is there any option in sas to display the message variable in (as in Excel we use alt + enter) more than one line as in header with split option.

The requirement is the data should be only in one variable and when right clicked should be able to view in excel in userfriendly format.

Please find the example below.

Input text document::::

x y z Message: This is a sample message,

where I have to read the information in

one single variable in sas data set.

When I read this dataset the variable message comes in one line. say like the below

Message Variable

Message: This is a sample message, where I have to read the information in one single variable in sas data set.

But the issue here is to split the dataset value or set the column width or set the height of the variable value for display purpose or when

viewed by client in excel.

I have used byte(10) and concatenated the observations but does not work.

Thanks in advance.

Re: Displaying the sas dataset when right clicked and viewed in Excel

Imroze — Fri, 24 Jan 2014 04:14:26 GMT

Guys can any one please help in the above problem. Please state wether it is possible or not.

Even if I have to export to Excel the solution will be helpful (alt + enter ) format.

Thanks in advance.

Re: Displaying the sas dataset when right clicked and viewed in Excel

RichardinOz — Sat, 25 Jan 2014 02:30:31 GMT

This is a question about how long data items in a SAS dataset can be displayed in multiple lines. It is not a question of how the data is stored 'under the covers' because it makes no sense in that context, either for SAS or Excel.

I doubt whether you can make the SAS data viewer behave in the way you describe but Proc report (and tabulate) can wrap data within fixed width cells. An example from the SAS documentation:

proc format ;

value questionf

1='This is an example of a description that is too long so it wraps down to the next line';

run;

data a;

input question rater $ avg;

datalines;

1 manager 3

1 staff 2

1 peer 3

;

run;

ods listing close;

ods escapechar='^';

options nodate nonumber orientation=portrait;

proc report data=a nowd spanrows;

column question rater avg;

define question / order

format=questionf.

style(column)={cellwidth=2.2in};

define rater / display;

define avg / display;

run;

(this comes from 9.2 documentation that describes an undesired side effect with ODS PDF:

45549 - Wrapped text strings in the first column cause unwanted white space in subsequent rows in PROC REPORT and PROC TABULATE output routed to ODS PDF)

Richard

Re: Displaying the sas dataset when right clicked and viewed in Excel

Imroze — Mon, 27 Jan 2014 05:19:16 GMT

Thanks Richard

your comment is helpful in finalizing my decission..

As I can clearly specify to my client that dataset cannot be viewed directly in desired format, I can give a desired output if needed (ODS, EXCEL, HTML...).

Thanks again.