@Rookie_123 wrote: Can you please show a sample code of datastep to change variable format, informat, length, type
If you run Proc Import on a CSV file the log will contain an example. That was how I generated the skeleton for this code which I modified slightly by changing the lengths of some variables to match the length of counterparts in another data set.
Not changing anything, reading as needed:
data lib.AddressRaw ;
infile Siradd delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
informat School_Name $80. ;
informat Type $8. ;
informat Title $16. ;
informat First_Name $17. ;
informat Last_Name $15. ;
informat Phone $12. ;
informat Fax $12. ;
informat Email $44. ;
informat District_Code $15. ;
informat District $26. ;
informat Address $32. ;
informat City $17. ;
informat County $10. ;
informat State $2. ;
informat Zip $5. ;
informat Principal_Title $35. ;
informat Principal_First_Name $14. ;
informat Principal_Last_Name $14. ;
input
School_Name $
Type $
Title $
First_Name $
Last_Name $
Phone $
Fax $
Email $
District_Code $
District $
Address $
City $
County $
State $
Zip $
Principal_Title $
Principal_First_Name $
Principal_Last_Name $
;
run;
The SIRADD is a file reference pointing to a CSV file. In this case I wanted everything to be character so things like district_code or ZIP that have only digits involved are read as character since I don't do any calculations on those.
An informat used in this manner will set the variable type and length. I had no need to assign any specific format to these values but could add a FORMAT statement if that were needed.
... View more