BookmarkSubscribeRSS Feed
Stephane
Quartz | Level 8
Hi

Using SEG 4.1 thin client and a Zos server, I'd like to export a SAS table from my server to my PC as a .txt file. How do I do that ?
5 REPLIES 5
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
You can use PROC EXPORT to generate a delimited text file. Have a look at the SAS support http://support.sas.com/ website for DOC and supplemental technical papers on the topic of exporting SAS data to a text / delimited (external) file.

Scott Barry
SBBWorks, Inc.
Stephane
Quartz | Level 8
NOTE: The Import/Export facility is not supported on this operating system.

this is the answer...and this is why I ask. 😉
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Explore using ODS CSV to create a comma-delimited file (using FILENAME statement), generated by PROC PRINT.

Scott Barry
SBBWorks, Inc.
artmorlock
Fluorite | Level 6
Bit of a kludge, but you can create a code object and use ods to create a comma separated text file.

ods csv file='stephanie.txt';
run;
proc print data=zos.dataset;
run;
ods csv close;

> Hi
>
> Using SEG 4.1 thin client and a Zos server, I'd like
> to export a SAS table from my server to my PC as a
> .txt file. How do I do that ?
ChrisHemedinger
Community Manager
Sorry for coming late to this party, but have you tried File->Export from SAS EG? You should be able to export the SAS table on MVS to any of several formats on your local PC, including text, Excel, etc.

Chris
It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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
  • 5 replies
  • 1080 views
  • 0 likes
  • 4 in conversation