Lukket

SAS Text field with spaces help

I have a text file I want imported into SAS it contains lines similar to

: 2477 7 4 ment (there is a space ' ' after the ment)

: 2487 7 4 ment don

In SAS I have it imported with

filename indat 'C:\[url removed, login to view]';

data onecs(drop=fwidth);

infile indat delimiter=' ' missover length=reclen;

if line_id=':' then do;

input second

ms

mms

details

;

end;

I want it imported into SAS with different fields signalled by the '|'

Seconds| ms| mms | details

2477 | 7 | 4 | ment (space ' ' after the ment)

2487 | 7 | 4 | ment don

because the delimiter between the fields is a ' ', SAS does not pick up on the ' ' after the 'ment'. I need to import the fields and ' ' after the ment and put it into a new text file with a change to the seconds variable eg.

if line_id=':' then do;

PUT

line_id

seconds+600 ms mms details

;

end;

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

SAS 9.2 or SAS 9.1

Maybe this pdf will help?[A Macro to Word Wrap Long Text Strings into a SAS®][1]

<[url removed, login to view]>

Evner: SAS

Se mere: sas text, text sas, sas web, sas hire, it field, hire sas, in sas, sas, pdf file change to word, ment, http request length, change text file, 600 lines, word text form field, pdf form fields word, data input word 2010, macro word 2010, macro data pdf, field work, 2010 word macro

Om arbejdsgiveren:
( 32 bedømmelser ) Williamstown, Australia

Projekt ID: #3314999

2 freelancere byder i gennemsnit $223 på dette job

canlevw

See private message.

$425 USD in 10 dage
(0 bedømmelser)
0.0
vcdanht

See private message.

$21.25 USD in 10 dage
(0 bedømmelser)
0.0