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 1996, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Sun, 11 Feb 1996 08:39:12 EST
Reply-To:     marla@EMUVAX.EMICH.EDU
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         marla@EMUVAX.EMICH.EDU
Organization: Eastern Michigan University, Ypsilanti
Subject:      Efficient processing of external Datasets

I need to read a large file (~150 variables >600 LRECL >1 Million rows) containing different data types - packed/binary/float/character etc. (The input file is NOT a SAS dataset). Need to convert it to a CSV file with quotes around character variables and comma separated. We are using the QUOTE function to quote the character variables and inserting commas between the variables with a 'put +(-1) ','. This simple program is turning out to be a CPU hog. The program runs on the MVS mainframe and is a real bottleneck. The program only contains a single INPUT statement, a series of statement to QUOTE character variables, followed by a single PUT statement. Is there anyway I can speed up processing? Or, is SAS generally not good with external files? TIA.


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