sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi,
I have a comma delimited input file in the following format,
Code: |
OP2,NORMALSTRAP: OP2MODLM,4,15,4,15,0,0,0,0,0,0,0,0
OP2,NORMALSTRAP: OP2PRODP,4,14,4,14,0,0,0,0,0,0,0,0
OP2,NORMALSTRAP: OP2WAREP,4,14,4,14,0,0,0,0,0,0,0,0
OP2,PICT COPY: ABDDEV AGSDTEST,16,14,0,0,0,0,16,14,0,0,0,0
OP2,PICT COPY: ABDDEV APPDATAP,19,66,0,0,0,0,19,66,0,0,0,0 |
Using the below SAS code, i am extracting only the data i need,
Code: |
//SASSTEP EXEC SAS
//IFILE DD DISP=SHR,DSN=HXSULL.TEST(SMR)
//OUTFILE DD DSN=HXSULL.BOBT1.MFSTORE.UL,
// DISP=(NEW,CATLG,DELETE),
// UNIT=TEST,
// SPACE=(CYL,(10,5),RLSE),
// DCB=(RECFM=FB,LRECL=70,BLKSIZE=0)
//SYSIN DD *
OPTIONS NOCENTER;
DATA INFILE;
INFILE IFILE DLM=',' ;
INPUT A $ B :$30. C D ;
PROC PRINT DATA=INFILE;
TITLE2 'DATA FILE';
DATA OFILE;
SET INFILE;
FILE OUTFILE;
PUT @1 A
@5 B
@40 C
@50 D
; |
Output of the above SAS code,
Code: |
The SAS System
DATA FILE
Obs A B C D
1 OP2 NORMALSTRAP: OP2MODLM 4 15
2 OP2 NORMALSTRAP: OP2PRODP 4 14
3 OP2 NORMALSTRAP: OP2WAREP 4 14
4 OP2 PICT COPY: ABDDEV AGSDTEST 16 14
5 OP2 PICT COPY: ABDDEV APPDATAP 19 66
|
Now, i want to split up column B into more columns like the following, help me i don't know how to proceed.
Code: |
OBS A B C D E F
1 OP2 NORMALSTRAP OP2MODLM 4 15
2 OP2 NORMALSTRAP OP2PRODP 4 14
3 OP2 NORMALSTRAP OP2WAREP 4 14
4 OP2 PICT COPY ABDDEV AGSDTEST 16 14
5 OP2 PICT COPY ABDDEV APPDATAP 19 66
|
Thank You in advance,
Sushanth |
|