Try adding an explicit informat to your input statement:

input order 1.;

SAS is seeing a '0D'x immediately following the 1. If you tell it to only read one byte, it will no longer be seen.

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Nicole Bibb Sent: Wednesday, February 16, 2005 3:38 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Invalid data with card statements

This program was written in V8 and we are now using V9.1 and the following message is causing the dataset to be create incorrectly. When I submit the code independently in PC SAS, I do not get any error message and the data set is correctly created. However, the UNIX server using V9.1 is reading the card statements invalid. I have another card statement in the same program which is getting the same message. Is there something new with V9.1 Pls Help!!!

Here is the code:

data total_disc_amt_wkly; set total_disc_amt_wkly; order=1 ; Run; proc sort data = total_disc_amt_wkly; by order; Run;

data total_disc_amt_ytd; set total_disc_amt_ytd; order=1 ; Run; proc sort data = total_disc_amt_ytd; by order; Run;

*** Create the summary template ***; data summary_records; length order 8.; input order; cards; 1 ; run;

/* jh title 'summary_records'; proc print data=summary_records; run; end jh */ proc sql; create table summary_template as select order, 0 as unique_order, 0 as trial_unt, 0 as trial_amt, 0 as simple_start_unt, 0 as simple_start_amt, 0 as basic_unt, 0 as basic_amt, 0 as pro_unt, 0 as pro_amt, 0 as pro5_unt, 0 as pro5_amt, 0 as mac_unt, 0 as mac_amt, 0 as premier_unt, 0 as premier_amt, 0 as premier_multi5_unt, 0 as premier_multi5_amt, 0 as accountant_unt, 0 as accountant_amt, 0 as contractor_unt, 0 as contractor_amt, /*8-26-04 0 as healthcare_unt, 0 as healthcare_amt,*/ 0 as nonprofit_unt, 0 as nonprofit_amt, 0 as professional_unt, 0 as professional_amt, 0 as mfgwholesale_unt, 0 as mfgwholesale_amt, 0 as cust_mgr_unt, 0 as cust_mgr_amt, /*8-26-04 0 as pos_unt, 0 as pos_amt,*/ 0 as posbasic_unt, 0 as posbasic_amt, 0 as pospro_unt, 0 as pospro_amt, 0 as posmultistore_unt, 0 as posmultistore_amt, 0 as poshardware_unt, 0 as poshardware_amt, 0 as retail_unt, 0 as retail_amt, 0 as fsr_unt, 0 as fsr_amt, 0 as qbes_unt, 0 as qbes_amt, 0 as qbes_vert_unt, 0 as qbes_vert_amt, 0 as sbss_unt, 0 as sbss_amt, 0 as diy_payroll_unt, 0 as diy_payroll_amt, 0 as total_no_demo_unt, 0 as total_no_demo_amt, 0 as total_unt, 0 as total_amt, 0 as total_disc_amt, 0 as disc_prom_amt, 0 as discount_promotion_amt, 0 as qbg_only_unt, 0 as qbg_only_amt, 0 as resp_rate_no_demos, 0 as resp_rate, 0 as resp_rate_qb_only, 0 as internet_pct, 0 as mail_pct, 0 as phone_pct, 0 as batch_pct, 0 as in_product_pct, 0 as other_channel_pct, 0 as internet_amt, 0 as mail_amt, 0 as phone_amt, 0 as batch_amt, 0 as in_product_amt, 0 as other_channel_amt, 0 as internet_unt, 0 as mail_unt, 0 as phone_unt, 0 as batch_unt, 0 as in_product_unt, 0 as other_channel_unt from summary_records ; quit;

Error MSG:

2059 2060 *** Create the summary template ***; 2061 data summary_records; 2062 length order 8.; 2063 input order; 2064 cards;

NOTE: Compression was disabled for data set WORK.SUMMARY_RECORDS because compression overhead would increase the size of the data set. NOTE: Invalid data for order in line 2065 1-2. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6---

2065CHAR 1. ZONE 302222222222222222222222222222222222222222222222222222222222222 NUMR 1D0000000000000000000000000000000000000000000000000000000000000 64 order=0 _ERROR_=1 _N_=1 NOTE: The data set WORK.SUMMARY_RECORDS has 1 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.29 seconds cpu time 0.01 seconds

2064! 2066 ; 2067 run; 2068