topic Re: Tilte behavior in SAS Programming

Tilde behavior

nirupama1 — Sun, 11 Nov 2018 23:36:43 GMT

Hi All,

I used below codes i.e. with Tilde and without tilde(~). And getting the same result . Can yo explain why is it so?

case1-

Data student;
infile cards dsd dlm=',';
Input id team $25.;
Cards;
1,"Green House,NCSS"
2,"Green House,ABPS"
3,"Green House,JKLM"
;
proc print;
Run;

case 2-

Data student;
infile cards dsd dlm=',';
Input id team ~ $25.;
Cards;
1,"Green House,NCSS"
2,"Green House,ABPS"
3,"Green House,JKLM"
;
proc print;
Run;

same outputfor both cases-

id team

1	"Green House,NCSS"
2	"Green House,ABPS"
3	"Green House,JKLM"

While I expect to not receive quotes in output for case 1 scenario, as per the DSD fuctionality.

PLease explain Why getting same output.

Thanks,

Nirupama

Re: Tilte behavior

novinosrin — Sat, 10 Nov 2018 19:29:37 GMT

Data student;
infile cards dsd ;
Input id team : $25.;
Cards;
1,"Green House,NCSS"
2,"Green House,ABPS"
3,"Green House,JKLM"
;

Data student1;
infile cards dsd ;
Input id team ~ :$25.;
Cards;
1,"Green House,NCSS"
2,"Green House,ABPS"
3,"Green House,JKLM"
;

EDIT: Applies only when you use list input and not formatted input (this is the reason)

Re: Tilte behavior

VDD — Sat, 10 Nov 2018 19:18:15 GMT

that is because the , is within a quoted string. DLM works with the cards not the quoted strings you have.

Re: Tilte behavior

novinosrin — Sat, 10 Nov 2018 19:33:24 GMT

No,

run and see

Data student;
infile cards dsd dlm=',' ;
Input id team : $25.;
Cards;
1,"Green House,NCSS"
2,"Green House,ABPS"
3,"Green House,JKLM"
;

Data student1;
infile cards dsd  dlm=',';
Input id team ~ :$25.;
Cards;
1,"Green House,NCSS"
2,"Green House,ABPS"
3,"Green House,JKLM"
;

The only change I did was using a colon format modifier to read team with a list input