Date:         Mon, 29 Sep 2008 19:46:26 -0400
Reply-To:     Hari Nath <hari_s_nath@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Hari Nath <hari_s_nath@YAHOO.COM>
Subject:      Re: Warning: Truncated record

Hi all,
From the sas website (http://support.sas.com/kb/5/953.html), it says to
reduce the line length to less than 256 characters. I tried like option
pagesize = 255 and then in the file statement, used n=ps which didnt work
either....following is my log file........


**********my log file*************;

122        data _null_ ;
123          set data.model_current_retail ;
124          file "/c:/model_current_retail.csv" dlm = "|" dsd lrecl =
32767 ;
125
126          if _n_ = 1 then
127         do ;
128
WARNING: Truncated record.
129
 put 'CUSTOMER_KEY' '|' 'POINTS_AVAILABLE' '|' 'retailseg' '|' 'prio
r_pts' '|' 'prior_seg' '|' 'cell_pts' '|' 'cell_seg' '|' 'cell2_seg' '|' 'c
ardtype' '|' 'is_Blue' '|' 'is_Copper' '|' 'is_Gold' '|' 'is_Platinum' '|'
'pts_available_hun' '|'
129      ! 'points_cent'
130        '|' 'int_plat_pntsava_n' '|' 'LTD_REDEEM' '|' 'BLOCK_RECLASS_COD
E' '|' 'opendate' '|' 'vintage' '|' 'vintage_yr' '|' 'vintage_yr_squared' '
|' 'vintage_yr_cube' '|' 'dmaregion' '|' 'is_Region_missing' '|' 'is_10_Reg
ion' '|' 'is_20_Region' '|'
131        'is_30_Region' '|' 'is_40_Region' '|' 'is_50_Region' '|' 'delinq
uent_d' '|' 'ever_delinquent' '|' 'CARDMEMBER_AGE' '|' 'zip_region' '|' 'ca
rdmember_age_cat' '|' 'is_age_miss' '|' 'is_age_le30' '|' 'is_age_30_40' '|
' 'is_age_40_50' '|'
131      ! 'is_age_50_60' '|'
132        'is_age_60_70' '|' 'is_age_70_80' '|' 'is_age_gt80' '|' 'is_age_
gt70' '|' 'EVER_OWNED_OR_LEASED_GM_FLAG' '|' 'CURRENT_FLEET_LOYALTY_DESC' '
|' 'is_defectormixed' '|' 'is_gmmixed' '|' 'is_gmonly' '|' 'is_pureconquest
' '|' 'is_resloyalist' '|'
132      ! 'is_unknown'
133        '|' 'ever_owned_or_leased_gm_flag_new' '|' 'is_owned' ;
138
139         end ;
140
141         do ;
142          put CUSTOMER_KEY POINTS_AVAILABLE retailseg prior_pts
prior_seg cell_pts cell_seg cell2_seg cardtype is_Blue is_Copper is_Gold
is_Platinum pts_available_hun points_cent int_plat_pntsava_n LTD_REDEEM
BLOCK_RECLASS_CODE opendate vintage
142      ! vintage_yr
143        vintage_yr_squared vintage_yr_cube dmaregion is_Region_missing
is_10_Region is_20_Region is_30_Region is_40_Region is_50_Region
delinquent_d ever_delinquent CARDMEMBER_AGE zip_region cardmember_age_cat
is_age_miss is_age_le30 is_age_30_40
143      ! is_age_40_50
144        is_age_50_60 is_age_60_70 is_age_70_80 is_age_gt80 is_age_gt70
EVER_OWNED_OR_LEASED_GM_FLAG CURRENT_FLEET_LOYALTY_DESC is_defectormixed
is_gmmixed is_gmonly is_pureconquest is_resloyalist is_unknown
ever_owned_or_leased_gm_flag_new is_owned  ;
149         end ;
150        run ;

NOTE: 765 records were written to the file "/c:/model_current_retail.csv".
      The minimum record length was 0.
      The maximum record length was 1518.
NOTE: There were 513 observations read from the data set
DATA.MODEL_CURRENT_RETAIL.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.03 seconds


On Mon, 29 Sep 2008 17:21:44 -0400, Hari Nath <hari_s_nath@YAHOO.COM>
wrote:

>Sorry, I was wrong here. Now am not sure what the warning supposed to mean
>and what i should be aware of.
>
>On Mon, 29 Sep 2008 17:11:21 -0400, Hari Nath <hari_s_nath@YAHOO.COM>
>wrote:
>
>>Hi all,
>>Am writing out a delimited file and the first row contains the variable
>>names. One of the variable name is 32 in length, but when writing to the
>>flat file it puts only 28 characters, which is why i see the warning
>>message. Is there a way to avoid the warning or make sas to write without
>>truncating the records...sas unix, version 9.1.3
>>
>>Many thanks,
>>hari.