topic Re: Import and Export procedure in EG in SAS Enterprise Guide

Import and Export procedure in EG

deleted_user — Tue, 08 Jan 2008 15:22:21 GMT

Hi,
May i know why dont we have Import and Export of data in EG by coding( automatically).
i know the way of exporting or importing like File -> Import wizard (or) Export Wizard.
But i want to know the way of coding in EG for import & export the data.

Re: Import and Export procedure in EG

deleted_user — Tue, 08 Jan 2008 15:42:45 GMT

I am not quite sure of what you mean - you can create a new code and run a PROC IMPORT procedure (or any other SAS code).

Re: Import and Export procedure in EG

deleted_user — Tue, 08 Jan 2008 15:49:01 GMT

Use Help, SAS Online Documentation to find the Base SAS documentation for your version of SAS.

Then look up within that documentation the PROC IMPORT and PROC EXPORT procedures.

Re: Import and Export procedure in EG

deleted_user — Wed, 09 Jan 2008 12:15:18 GMT

I am not able to import or export the data by using Code but i can export or impot data by using import wizard. My questation is, i want to know whether we have option in the EG, import or exporting data by coding.

Re: Import and Export procedure in EG

deleted_user — Wed, 09 Jan 2008 12:16:27 GMT

Re: Import and Export procedure in EG

deleted_user — Wed, 09 Jan 2008 13:13:08 GMT

YES

Re: Import and Export procedure in EG

MohamedS — Wed, 09 Jan 2008 13:47:02 GMT

Hi Basu,

to type a code in enterprise guide:
1- select file --> new --> code.
once the Editor open. use the following example code. it is to import dlimited text file. file name is "delimiter.txt" you can make any sample file from your side. the delimiter between columns is semi colon.

the data will be imported to SAS data set called mydata in work library.

proc import datafile="x:\myfiles\delimiter.txt"

out=mydata

dbms=dlm

replace;

delimiter=';';

getnames=yes;
run;

options nodate ps=60 ls=80;

proc print data=mydata;
run;

I wish it is helpful for you.

Re: Import and Export procedure in EG

deleted_user — Fri, 11 Jan 2008 20:00:45 GMT

Hello,

Has anyone had issues importing and Exporting DBase (5) files? We're trying to import a file with boolean expressions. When imported, the boolean expressions (yes or No) values are converted to SAS boolean values (0 or 1). But when we update the file and try to export it again, the boolean columns retain their integer formats and are now "1.0000" instead of YES in the resulting dbase file. I know that we can get around this by coding in Character Yes/No values but is there an option that can be set somewhere to retain the boolean format without the additional intervention?

Has anyone come across this?