Hi Wong/Tom/Reeza, Thanks for the response. You gave me very good learnig information. Reeza's response have worked for me as well. Thank you all!! Tom, My problem is not the data type conversion from Numeric to Character, but it is the length of the columns. For example, the first column is PRODUCT_NAME_ABBR. Now, in this column only 8 characters from the input file is displayed i.e. if the value in the input file is "ORUDIS 50MG CAPSULES", the value stored in the SAS data set is "ORUDIS 5". This (8) is the default value set for all the columns when running through SAS Enterprise guide. Later, I checked the SAS enterprise guide and it had an import data function. When I used it, it generated code for me as well and it is also a solution for this issue. ONE QUESTION THOUGH, is this correct to have both the Informat and Format defined for same variable? Thanks for your help and time. DATA WORK.Ops_study_Query;
LENGTH
PRODUCT_NAME_ABBR $ 39
SIMS_UPC $ 27
WIC_NBR $ 12
OPS_STUDY_DEPT_NBR $ 12
BILLING_NDC $ 13
PACKAGE_SIZE $ 13
PACKAGE_QTY $ 13
Total_Pack_Size $ 13
DRUG_WAREHOUSE_IND $ 5
DRUG_TYPE_CD $ 5
DRUG_CLASS $ 3
;
FORMAT
PRODUCT_NAME_ABBR $CHAR39.
SIMS_UPC $CHAR27.
WIC_NBR $CHAR12.
OPS_STUDY_DEPT_NBR $CHAR12.
BILLING_NDC $CHAR13.
PACKAGE_SIZE $CHAR13.
PACKAGE_QTY $CHAR13.
Total_Pack_Size $CHAR13.
DRUG_WAREHOUSE_IND $CHAR5.
DRUG_TYPE_CD $CHAR5.
DRUG_CLASS $CHAR3.
;
INFORMAT
PRODUCT_NAME_ABBR $CHAR39.
SIMS_UPC $CHAR27.
WIC_NBR $CHAR12.
OPS_STUDY_DEPT_NBR $CHAR12.
BILLING_NDC $CHAR13.
PACKAGE_SIZE $CHAR13.
PACKAGE_QTY $CHAR13.
Total_Pack_Size $CHAR13.
DRUG_WAREHOUSE_IND $CHAR5.
DRUG_TYPE_CD $CHAR5.
DRUG_CLASS $CHAR3.
;
INFILE '/usr/local/#LN00015'
LRECL=32767
FIRSTOBS=2
ENCODING="LATIN1"
DLM='2c'x
MISSOVER
DSD ;
INPUT
PRODUCT_NAME_ABBR : $CHAR39.
SIMS_UPC : $CHAR27.
WIC_NBR : $CHAR12.
OPS_STUDY_DEPT_NBR : $CHAR12.
BILLING_NDC : $CHAR13.
PACKAGE_SIZE : $CHAR13.
PACKAGE_QTY : $CHAR13.
Total_Pack_Size : $CHAR13.
DRUG_WAREHOUSE_IND : $CHAR5.
DRUG_TYPE_CD : $CHAR5.
DRUG_CLASS : $CHAR3.
;
RUN;
... View more