topic Re: Catx or trim? Help with Problem in SAS Programming

Catx or trim? Help with Problem

IgawaKei29 — Tue, 18 Apr 2017 10:18:02 GMT

So I am trying to figure out how to take this string of data and seperate it out with a data step. I understand the concept, but I am not sure how to apply it to multiple results.

So I want to take the data and seperate it out:

Ac_Num = 12345

Fr_Nm = Harry

Ls_Nm = Crumb

Address = 123 Fake Street

City = Anytown

State = MA

Text = More of the Same

I know how to do this if there is 1 variable, so I am curious what I need to do to gather them all.

Ac_Num = substr(My_Data, 1, index(My_Data, '|') - 1);

Re: Catx or trim? Help with Problem

jessicaking — Tue, 18 Apr 2017 10:20:29 GMT

Is your raw data already in a sas table? If not what format is it in?

Re: Catx or trim? Help with Problem

IgawaKei29 — Tue, 18 Apr 2017 10:22:01 GMT

Yes it is all in 1 line on my table.

Re: Catx or trim? Help with Problem

jessicaking — Tue, 18 Apr 2017 10:29:47 GMT

Re: Catx or trim? Help with Problem

IgawaKei29 — Tue, 18 Apr 2017 10:35:07 GMT

Thanks so much 🙂 I haven't used the scan feature before, I am going to play around with that a little bit looks like it can help me in other programs as well.

Re: Catx or trim? Help with Problem

jessicaking — Tue, 18 Apr 2017 10:36:28 GMT

Its similar to the substring function but is a bit more flexible 🙂 I personally favor it. Good luck!

Re: Catx or trim? Help with Problem

atul_desh — Tue, 18 Apr 2017 11:29:40 GMT

proc print data=ds1;
run;

Re: Catx or trim? Help with Problem

RW9 — Tue, 18 Apr 2017 11:51:00 GMT

Where has this data come from? This is a key question here as it looks like your using delimited data, most likely from a delimited file. If so, then write a datastep import program to read the data correctly, avoiding the need for post-processing the data at all.

Re: Catx or trim? Help with Problem

IgawaKei29 — Tue, 18 Apr 2017 11:57:27 GMT

Its actually how one of our tables are built. Its an ugly process on how it is injested.