topic Creating text in sas and exporting it to the XL in Graphics Programming

Creating text in sas and exporting it to the XL

JaneS — Mon, 12 Apr 2021 18:53:55 GMT

I created a couple of data sets in sas that export to excel. I need to create a description tab that describe my data sets. I was tying to find out a code sample for SAS, where I could put some text in that code and it would create a tab in XL file with that text in it.

Thank you!

Re: Creating text in sas and exporting it to the XL

Reeza — Mon, 12 Apr 2021 21:13:59 GMT

Pipe the results from SASHELP.VTABLE or VCOLUMNS to an excel file within and ODS EXCEL?

ods excel file = "/folders/myfolders/demo.xlsx" style=meadow;

proc print data=sashelp.vcolumn;
where libname = 'SASHELP' and memname = 'CLASS';
var libname memname name type length format;
run;

ods excel options(sheet_interval="NOW");

proc print data=sashelp.class;
run;

ods excel close;

Conceptually, I think you're looking for something like that. You can also use PROC ODSTEXT to pipe text directly to the report.

@JaneS wrote:

I created a couple of data sets in sas that export to excel. I need to create a description tab that describe my data sets. I was tying to find out a code sample for SAS, where I could put some text in that code and it would create a tab in XL file with that text in it.

Thank you!

Re: Creating text in sas and exporting it to the XL

ballardw — Mon, 12 Apr 2021 22:30:19 GMT

Possibly just Proc Contents for the data sets of interest?

Re: Creating text in sas and exporting it to the XL

Reeza — Mon, 12 Apr 2021 22:50:21 GMT

Probably a better example! But I suspect they may also want the PROC ODSTEXT part based on this statement "where I could put some text in that code and it would create a tab in XL file with that text in it."

But using a data set label or extra metadata on data sets could also be a good option.

Re: Creating text in sas and exporting it to the XL

GraphGuy — Tue, 13 Apr 2021 11:10:24 GMT

Assuming your datasets have labels, you could do something like this using sashelp.vtable (which is a table that exists behind-the-scenes, storing summary info about the datasets):

proc sql noprint;
create table summary as
select unique memname, memlabel
from sashelp.vtable
where libname='MAPSGFK'
and memname in ('FRANCE' 'GERMANY' 'EGYPT');
quit; run;

title "Datasets in this spreadsheet";
proc print data=summary label noobs;
run;

Re: Creating text in sas and exporting it to the XL

JaneS — Tue, 13 Apr 2021 14:14:11 GMT

Thank you so much for everyone's reply! I am a little confused about this code, as where would I paste text. Just as an example, if I have this text:

Filter 1: Step-by-step instructions

Locate your water filter cover in the upper right-hand corner inside your refrigerator or in the base grille.
Lift the filter door up.
Pull the filter out and discard it.
Open your new filter and remove the protective coverings from the O-rings. Make sure the O-rings are still in place after the cover has been removed.
When inserting the new filter into the slot, make sure the arrow is pointing upward. Do not force the water filter. If it does not slide in easily, rotate it until the notches are properly aligned with the grooves.
Push the filter door closed so it snaps into place.
Once your filter is replaced, run four gallons of water through the line to properly flush the new filter.

where/how should I paste it in SAS code so that it would populate in the XL for me?

Thank you!

Re: Creating text in sas and exporting it to the XL

Reeza — Tue, 13 Apr 2021 15:11:45 GMT

Did you look into PROC ODSTEXT?

Or just save it to a data set and use PROC PRINT or PROC REPORT?

data have;
text = 'Filter 1: Step by step instructions'; indent = 0;output;
text = '1. Locate your water filter....'; indent = 1; output;
run;

proc print data=have;
run;