topic Re: How to import this data in SAS by infile statement in New SAS User

How to import this data in SAS by infile statement

swatiN — Fri, 13 Mar 2020 04:39:21 GMT

HI,

How do I import this .txt into SAS with no titles using infile statement?

i.e I don't want ' INFORMATION ABOUT DEPTNO:10' & 'ENAME JOB SAL DEPTNO' into SAS dataset (i need only the observations)

Thanxs

INFORMATION ABOUT DEPTNO:10
'
ENAME JOB SAL DEPTNO
MILLER CLERK 2200.00 10
CLARK MANAGER 3350.00 10

'
INFORMATION ABOUT DEPTNO:20
'
ENAME JOB SAL DEPTNO
FORD ANALYST 4650.00 20
SCOTT ANALYST 4400.00 20

INFORMATION ABOUT DEPTNO:30
'
ENAME JOB SAL DEPTNO
JAMES CLERK 1587.50 30
BLAKE MANAGER 3962.50 30

Re: How to import this data in SAS by infile statement

Reeza — Fri, 13 Mar 2020 04:41:23 GMT

Here's some examples on how to do that

https://support.sas.com/documentation/cdl/en/basess/58133/HTML/default/viewer.htm#a002001051.htm

Re: How to import this data in SAS by infile statement

Patrick — Fri, 13 Mar 2020 05:31:23 GMT

If the link @Reeza shared doesn't provide you enough guidance then please post an exact sample of your source data as a .txt attachment - or at least post it into a text window using the {i} icon here. Reason: Ensure that we get the exact layout without the forum pages altering anything.

Also ensure that the sample data covers all possible cases. I.e. Is it possible that a source string for ENAME is made-up of more than one word like A. MILLER or MAC MILLER

Re: How to import this data in SAS by infile statement

Ksharp — Fri, 13 Mar 2020 07:11:41 GMT

data have;
infile cards truncover ;
input @;
if _infile_ in: (" " "'" "INFORMATION" "ENAME") then delete;
else input ENAME : $40. JOB : $40. SAL DEPTNO ;
cards;
INFORMATION ABOUT DEPTNO:10
'
ENAME JOB SAL DEPTNO
MILLER CLERK 2200.00 10
CLARK MANAGER 3350.00 10

'
INFORMATION ABOUT DEPTNO:20
'
ENAME JOB SAL DEPTNO
FORD ANALYST 4650.00 20
SCOTT ANALYST 4400.00 20

INFORMATION ABOUT DEPTNO:30
'
ENAME JOB SAL DEPTNO
JAMES CLERK 1587.50 30
BLAKE MANAGER 3962.50 30
;
proc print;run;

Re: How to import this data in SAS by infile statement

swatiN — Fri, 13 Mar 2020 21:03:02 GMT

Thank you so much for this info.

I really appreciate it.