Export as a SAS file

jorquec — Wed, 24 Jul 2019 08:18:42 GMT

Hi,

Could some one tell me how I could change this code on the STEP 3 to export as a SAS table instead of a txt file , keeping the same path to be exported I mean keeping this adress "OUTFILE='//SASCommon/jorquec/"

Many thanks ,

/*-----------------MACROS DE DATA ------------------*/

%let today=%sysfunc(today());

%let currdt=%sysfunc(datetime());

data _null_;

date2=intnx("month",&today.,-1,'end');

call symput('ONEDT2',"1"||substr(put(date2,DDMMYYN.),7,2)||substr(put(date2,DDMMYYN.),3,2)||substr(put(date2,DDMMYYN.),1,2));

%put &ONEDT2.;

%put ONEDT2= &ONEDT2.;

month_id = intck('month','01jan1990'd,today());

put month_id=;

call symputx('month_id',month_id);

%put month_id=&month_id;

run;

/*STEP 1 */

Proc SQL;

connect to teradata

(user=&teradata_user. password=&teradata_pwd. server = 'edwprod' database = 'nuc_pl_user_view');

Create table JORQUEC.TESTPAYG as select * from connection to teradata(

select a.ID, a.maxmargin_dt, b.maxmodelmart_d from

(

select

1 as ID,

max(month_end_dt) as maxmargin_dt

from nuc_pl_user_view.pg_margin_stack) as A

left join (

select

1 as ID,

max(month_id) as maxmodelmart_d

from Insights_rm.Consumer_Model_Mart) as B

on a.ID = b.ID

);

disconnect from teradata ;

QUIT;

/* STEP 2 */

DATA JORQUEC.TRIGGERPAYG;

SET JORQUEC.TESTPAYG;

IF (maxmargin_dt >= (&ONEDT2.)/100) and (maxmodelmart_d = &month_id.) then export_flag='Y';

else export_flag='N';

call symputx('export_flag', export_flag);

run;

*check value of macro variable;

%PUT Export_Flag = &export_flag;

/* STEP 3 - PROC EXPORT -*/

%macro test;

%if (&export_flag = 'Y') %then %do;

PROC EXPORT DATA=JORQUEC.TRIGGERPAYG

OUTFILE='//SASCommon/jorquec/TRIGGER_PAYGO.TXT'

DBMS=dlm

REPLACE;

delimiter='&';

RUN;

%end;

%mend;

%test;

Re: Export as a SAS file

Kurt_Bremser — Wed, 24 Jul 2019 14:21:53 GMT

libname export '//SASCommon/jorquec';

proc copy inlib=jorquec outlib=export memtype=data;
select triggerpayg;
run;

/* or very simple */

data export.triggerpayg;
set jorquec.triggerpayg;
run;

Re: Export as a SAS file

jorquec — Wed, 24 Jul 2019 09:44:58 GMT

Many thanks, sorry for my basic question I am still learning. You are very kind.

Re: Export as a SAS file

Kurt_Bremser — Wed, 24 Jul 2019 11:13:57 GMT

No problem. See it as "my job" here 😉

There are, as always with SAS, many more ways to create SAS tables in a given location. Proc sql, ODS output, to name just two.

For a single table, the data step is probably best (because of being simple), for a "bulk" operation proc copy is the tool of choice.

topic Re: Export as a SAS file in New SAS User

Export as a SAS file

Re: Export as a SAS file

Re: Export as a SAS file

Re: Export as a SAS file