topic Re: How to create .csv sas dataset on mainframe with column headings? in SAS Procedures

How to create .csv sas dataset on mainframe with column headings?

renjithr — Wed, 25 Jul 2012 21:22:13 GMT

Hi,

I am trying to create a .csv sas dataset on mainframe with column headings.

DATA _NULL_;

SET DATAOT1.NRI;

IF MCA = "&MCA1" THEN DO;

CALL SYMPUT('TEXT_FLG', 'Y');

FILE &FNME1 DSD DLM=',' LRECL=8000 TITLES;

IF _N_ EQ 1 THEN

PUT @1 'MCA,MN1,ADMDT,DISDT,ADMTYPE_NM,ADMSRC_NM,DISP_NM,AGE,

ED_IND,PAT_ENC_CSN_ID,MDC,SCHED,EXPIRED,BASECLASS,SEX,

LOS,V_ALL_BARI,CANCER,BMI35,HSP_ACCOUNT_ID,

ADT_PATIENT_STAT_C,PAT_CLASS,INP_ADM_DT';

PUT MCA MRN1 ADMDT DISDT ADMTYPE_NM ADMSRC_NM DISP_NM AGE

ED_IND PAT_ENC_CSN_ID MDC SCHED EXPIRED BASECLASS SEX

LOS V_ALL_BARI CANCER BMI35 HSP_ACCOUNT_ID

ADT_PATIENT_STAT_C PAT_CLASS INP_ADM_DT

;

end;

run;

but this code is not writing the column headings.Also in the sas log I see the note that the quouted string(put @1) exceeded 256 characters.

Please share your thoughts.

Thanks

Re: How to create .csv sas dataset on mainframe with column headings?

renjithr — Wed, 25 Jul 2012 21:32:41 GMT

Forgot to mention the above code is in a macro.

Re: How to create .csv sas dataset on mainframe with column headings?

ballardw — Wed, 25 Jul 2012 22:57:36 GMT

I think the culprit might be the

IF MCA = "&MCA1" THEN DO;

If this condition is not true for the very first record you won't get your headings.

It looks like you are trying to only export the records where this value holds true. If that is so instead of the If statement use a where clause on the set statement to subset the data.

SET DATAOT1.NRI (where =( MCA = "&MCA1" ));

and remove the IF THEN DO; and END; statements.

Re: How to create .csv sas dataset on mainframe with column headings?

Ksharp — Thu, 26 Jul 2012 04:02:12 GMT

How about using proc export ?

proc export data=sashelp.class(where=(sex='F')) dbms=csv outfile='c:\x.csv' replace;

putnames=yes;

run;

ods _all_ close;

ods csv file='c:\x.csv' ;

proc print data=sashelp.class(where=(sex='F')) noobs;

run;

ods csv close;

ods listing;

Ksharp

Re: How to create .csv sas dataset on mainframe with column headings?

Amir — Thu, 26 Jul 2012 11:30:07 GMT

Hi,

Can you use the %ds2csv macro? It puts out the column headings by default:

http://support.sas.com/documentation/cdl/en/lebaseutilref/63492/HTML/default/viewer.htm#n0yo3bszlrh0byn1j4fxh4ndei8u.htm

Regards,

Amir.

Re: How to create .csv sas dataset on mainframe with column headings?

NYSPhil — Fri, 27 Jul 2012 19:32:24 GMT

What I use when creating a CSV file on the mainframe is ODS CSVALL. I use with a formatted output proc like PROC PRINT. Example:

ODS CSVALL FILE = CSVFILE RS=NONE;

PROC PRINT DATA=PRTDATA NOOBS LABEL SPLIT='*';

VAR DATA1 DATA2 ETC.

ODS CSVALL CLOSE;

Don't know how it would work with DATA _NULL_ output

Re: How to create .csv sas dataset on mainframe with column headings?

Tom — Sat, 28 Jul 2012 20:00:11 GMT

You can just use a data step. See this thread:

https://communities.sas.com/message/116724#116724

Or on SAS-L

http://listserv.uga.edu/cgi-bin/wa?A2=ind1202C&L=sas-l&D=0&F=P&P=11485&F=