LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (February 2011, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 9 Feb 2011 15:21:28 -0500
Reply-To:     Gabriel Rosas <rosas.gabe@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gabriel Rosas <rosas.gabe@GMAIL.COM>
Subject:      Re: Exporting into CSV woes...help!

Hi Rieza,

You could try this, to get the one huge CSV file you wanted in the first place.

proc sql noprint; select name into :txtHeader separated by ',' from dictionary.columns where lowcase(libname)='work' and lowcase(memname)='nhbsmsm' order by varnum; select name into :txtPut separated by ' ' from dictionary.columns where lowcase(libname)='work' and lowcase(memname)='nhbsmsm' order by varnum; quit;

data _null_; set nhbsmsm; file 'whatever the file is.csv' dlm=',' lrecl=/*what it needs to be*/ ; if _n_=1 then put "&txtHeader"; put &txtPut; run;


Back to: Top of message | Previous page | Main SAS-L page