HI JBaily, HYG..   SAS App Server: OS: Red Hat Enterprise Linux Server release 7.6 (Maipo) SAS: SAS 9.4 Rev. 940_18w47   DSN: [PGS] Driver=/sas/sashome/SASODBCDriversfortheWebInfrastructurePlatformDataServer/9.4/Driver/psqlodbcw.so ServerName=sasem.servers.gov schema=public username=dcmdb password=Passw0rd db=dcmdb port=10482 UseServerSidePrepare=1     LIB Stmnt: LIBNAME PGLIB odbc DSN=PGS schema=public;   Log: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 LIBNAME PGLIB odbc DSN=PGS schema=public; NOTE: Libref PGLIB was successfully assigned as follows: Engine: ODBC Physical Name: PGS 74 75 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 87   NOTE: (Susing SAS Studio) After lib definition, I can see all table names listed on the lift panel!     Then, I'm trying to access the tables metadata by metalib, or proc sql connect, or even simple proc contents (below), and it's throwing the CLI error:   Example: PROC SQL; connect using PGLIB; select * from connection to PGLIB (select 1); quit;   Log: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 PROC SQL; 74 connect using PGLIB; 75 select * from connection to PGLIB 76 (select 1); ERROR: CLI describe error: E NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 77 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds   78 79 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;     ... View more

yes I need to preserve the blank space,    I even executed below query, and found the space is trimmed!   Proc SQL; Select Length(string) From test; Quit;   Results in 3, 4, 3 ... View more

Thanks buddy anyways, i got stuck and I think I should handle it out of SAS, on the data level. ... View more

Thanks man, but if you add extra space after row#3, you'll get my point exactly. spaces are trimmed, and I need to preserve them!   data test; infile datalines dlm="," dsd; input number string:$char12.; test_of_string = put(string,$hex24.); datalines4; 1,ABC 2, ABC 3,ABC    ;;;; proc print data=test noobs; %PUT ... View more

What if data looks like:   ABC   DEF XYZ  (two trailing spaces)   How to handle this? ... View more

Thanks for welcoming me aboard:)   I tried dataset as well, and same issue, for two days i'm exploring the internet for a solution, so I decided to ask here..   below is my code,    sample data "ABDCEF" that got processed normally, but like "ABCDEF " (with trailing space) it got trimmed.   data IMPORT; infile "/folders/myfolders/ecsql193/DM.csv" delimiter = ',' missover firstobs = 2 DSD lrecl = 32767; Length File_Name $12.; Length Worksheet_Name $12.; Length Start_Position $2.; Length End_Position $4.; Length Structure $8; Length File_Process_Flag $8; Length KPI_Process_Flag $31; Length Fact_Name $103; Length F_DIM_Category $35; Length F_DIM_Product_Group $6; Length F_DIM_Product $21; Length F_DIM_Subject_Area $22; Length DIM_Month $1; Length DIM_RatePlan_Type $1; Length DIM_Cust_Seg $1; Length DIM_Traffic_Type $1; Length DIM_BB_Spd $1; Length DIM_BB_Technology $1; Length DIM_TER_NW__FLAG_Y_N_ $1; Length DIM_USG_TIME__Flag_Y_N_ $1; Length DIM_BNDL_Flag__PAYG_Flag_Y_N_ $1; Length DIM_REV_CAT $1; Length DIM_ROAM_CNTY $1; Length DIM_DATA_BUNDLE $1; Length Measures $26; Length Conditions $17; input File_Name Worksheet_Name Start_Position End_Position Structure File_Process_Flag KPI_Process_Flag Fact_Name F_DIM_Category F_DIM_Product_Group F_DIM_Product F_DIM_Subject_Area DIM_Month DIM_RatePlan_Type DIM_Cust_Seg DIM_Traffic_Type DIM_BB_Spd DIM_BB_Technology DIM_TER_NW__FLAG_Y_N_ DIM_USG_TIME__Flag_Y_N_ DIM_BNDL_Flag__PAYG_Flag_Y_N_ DIM_REV_CAT DIM_ROAM_CNTY DIM_DATA_BUNDLE Measures Conditions ; Run; ... View more