Author |
Message |
Topic: SAS Clarifications |
sameermn
Replies: 2
Views: 1584
|
Forum: Application Programming Posted: Fri Nov 04, 2005 5:39 pm Subject: SAS Clarifications |
Hi All,
How to convert date in YYYYMMDD format to DD-MMM-YYYY format in SAS?
Also how to prevent zero suppression in SAS?
i.e. iam getting o/p as
' 11111'
but i need it as
'0000011 ... |
Topic: Create VB file skipping some fields |
sameermn
Replies: 2
Views: 1589
|
Forum: Utilities Posted: Fri Sep 09, 2005 1:06 pm Subject: Create VB file skipping some fields |
Problem solved. Even though i was awre that we need to add 4 bytes for VB files i was not awre that we need to put them at first during outrec.
Thank you so much for your help. |
Topic: Create VB file skipping some fields |
sameermn
Replies: 2
Views: 1589
|
Forum: Utilities Posted: Fri Sep 09, 2005 11:10 am Subject: Create VB file skipping some fields |
Hi,
I have a 491 byte VB file as input.
I need to create an out put file of 487 bytes (in VB format) from input
by skipping values from input file in positions 264,265,266
The sort card i us ... |
Topic: Remove Trailer and Update the total count in Syncsort |
sameermn
Replies: 4
Views: 3005
|
Forum: Utilities Posted: Mon Aug 08, 2005 2:33 pm Subject: Small clarification |
Hi Kolusu,
Made a small mistake.
Header 1st 4 bytes = 9900
Detail 1st 4 bytes = 9901
Trailer 1st 4 Bytes = 9902
Regards |
Topic: Remove Trailer and Update the total count in Syncsort |
sameermn
Replies: 4
Views: 3005
|
Forum: Utilities Posted: Mon Aug 08, 2005 2:21 pm Subject: File details |
Hi Kolusu,
Thx for your response.
1. LRECL = 491 and RECFM = VB
2. Header = 1st 4 bytes 9901, Detail = 1st 4 bytes spaces,
Trailer = 1st 4 bytes 9902
3. Of the 2 Trailers, we can ha ... |
Topic: Remove Trailer and Update the total count in Syncsort |
sameermn
Replies: 4
Views: 3005
|
Forum: Utilities Posted: Mon Aug 08, 2005 1:37 pm Subject: Remove Trailer and Update the total count in Syncsort |
Hi,
I need to sort a file & create an output.
The input file is in this format
9901xxxx
1111
2222
3333
9902yyyy
9902zzzz
As you can see i have 2 trailers with ea ... |
|