topic What to use instead of assignment? in SAS Programming

What to use instead of assignment?

torvin10 — Fri, 16 Nov 2018 08:04:41 GMT

I have to write a program that reads the data after datalines; in the code part. As you can see i use a assignment to remove the '',$ and the ** in the provided data. However i have to do the program without an assignment, which is quite troublesome. Any ideas on how to change it, so the program reads the code, but ignores "",$ and the **?

Cheers

data PERSONELL;
input @; 
  if not index(_infile_,'****');
  _infile_ = translate(_infile_,' ','$');
  length ID $ 4;
  length DEPT $ 1;
  input ID $ @1 DEPT $ BIRTHDAY date10. +(-5) YEAR :8. Salary comma8./;
  datalines;
A123  4Mar1989  8,6,00
***************
    A037 23Jun1957  21,450
**************
 M015 19Sep1977$17,500
***********
;
run;

Re: What to use instead of assignment?

andreas_lds — Fri, 16 Nov 2018 08:28:24 GMT

What was wrong with the solution provided in https://communities.sas.com/t5/SAS-Programming/How-to-handle-special-characters-in-data/m-p/512848?

Does the line with A037 start with blanks (or tab)?

Re: What to use instead of assignment?

Shmuel — Fri, 16 Nov 2018 08:32:31 GMT

What issues do you have?

1) why is '/' at the end of the INPUT statement ?

2) is it not your typo having two commas in first line salary ?

A123  4Mar1989  8,6,00

3) Your code is:

input ID $ @1 DEPT $ ......

did you mean:

input id $1. dept $3. .......

the @1 means to read fromthe 1st position of the row

Re: What to use instead of assignment?

torvin10 — Fri, 16 Nov 2018 09:02:32 GMT

Blanks. And the solution is good, however im trying to do it without assignment statements, and isn´t the

_infile_ = translate(_infile_,' ','$');

an assignment?

Re: What to use instead of assignment?

torvin10 — Fri, 16 Nov 2018 09:04:12 GMT

Sas studio(Mac user)

And the data is at was given to me, and the / from the INPUT statment had sneaked in, thanks.

Re: What to use instead of assignment?

Kurt_Bremser — Fri, 16 Nov 2018 09:16:03 GMT

From where do you get such an exercise? I hope it's not out of material that SAS provides for their courses.

Re: What to use instead of assignment?

Shmuel — Fri, 16 Nov 2018 09:21:41 GMT

Try next code:

data PERSONELL;
   infile datalines dlm='$' ; /* assuming the $ is the delimiter between vars */
    input ID $4. @;
    if ID = '****' then do; delete; input; end;
    else 
      input  +(-1)  DEPT $1.
            BIRTHDAY date10. +(-5) YEAR :8. Salary comma8.;
datalines;
A123  4Mar1989  8,600
***************
    A037 23Jun1957  21,450
**************
 M015 19Sep1977$17,500
***********
;
run;

Re: What to use instead of assignment?

Peter_C — Fri, 16 Nov 2018 11:08:58 GMT

To treat unwanted characters as blanks, put them into the DLM= option on an INFILE statement.

this only fails if you also need the DSD option ( not the case here)
Then your data step needs only
Data got it;
INFILE DATALINES dlm= '$ *' ;
Input id :$4. Birthday : date9. Salary :comma11. @1 dept :$1. ;
Datalines;
....And then your lines