hi oh its difficult to understand ... View more

Hi ok csvfile 1 : data looks like when I open the Csv file in process flow in EG is "item","price","id","list" 1,24,"MAB123","Check" 2,34,"MAB324","Check2" ccsvfile 2 : data looks like when I open csv file in process flow in sas EG item,price,list,id 1,24,Check,MAB325 2,35,Birth,MAS434 so Csv file 1 is old file and Csv 2 is new file we shd get it look similar when import Csv file 1 and Csv file 2 pld file shd to be changed to new file 1. Formats and informat after impirtimg to sas shd be same 2. the variables shd be aligned in same manner 3. Shd remove quotations in old file to look same as new file ... View more

HHi tom , to age variable I used the syntax u gave me the result is +36 +02 +04 i am using SAS EG I  am exporting SAS dataset using export to in SaS EG and saving in my c drive as a Csv file ... View more

I Didn't understand what u you have said i have not used z3 because for EG 23 3 4 i want only 23 03 04 but if I use z3 the he output will be 023 003 004 but in I3 format one byte will be for sign and other two for digits  ... View more

FFirst age variable in dataset is numeric with length 8 then I changed like this data x (drop= age); set y; old_age= put( age,2.); run; then in another data step i converted to i have used  Newage= put(input(old_age,best2.),z2.); I whren I am exporting to Csv.    I don't c any leading zeros   And   in document.    AGe.   Format.  I3.    I3 = Integer 3 so what format new age should be numeric or character ... View more

I Opened it in text editor I don't find any leading zeros ... View more

No I am not seeing it . One of my collague is suggesting that everything in Csv shd be strings so I don't understand what to do ... View more

HHi i have used  Newage= put(input(old_age,best2.),z2.); I gave me leading zeros Old age 36 2 45 6 new age 36 02 45 06 but when I am exporting data to csv file I am missing leading zeros data in Csv file 36 2 45 6 can any one pls help me . ... View more

CCan we use subpad function  but I am confused of which length I can specify and which format I can specify in code when source has format $12. , length 12 and now result dataset format A25 . Thinking how to represent in code ... View more

HHi i have an alphanumeric field example : MM344 its format is $12. In properties now I need to add trailing blanks and length shd be 25 . and then export that dataset  as csv file ... View more