Data formatting

deleted_user — Thu, 19 Aug 2010 19:40:07 GMT

Hi !

I do not know how to access it ?

Thanks! Message was edited by: sasnewbee

Re: Data formatting

art297 — Thu, 19 Aug 2010 21:59:50 GMT

You have to be more specific. From what you have provided one can only guess. My guess is that you want to export your data to a text file. If that is correct, you can either use proc export or, if you need more control, take a look at:

http://kb.iu.edu/data/acxh.html

HTH,
Art

Re: Data formatting

Cynthia_sas — Thu, 19 Aug 2010 22:09:29 GMT

Hi:
Poor JOHN SMITH is really getting a workout! Is this data and task at all related to your previous posts? Like these??
http://support.sas.com/forums/message.jspa?messageID=40884#40884
http://support.sas.com/forums/thread.jspa?messageID=39405駭
http://support.sas.com/forums/thread.jspa?messageID=39561骉
http://support.sas.com/forums/thread.jspa?messageID=39972鰤
http://support.sas.com/forums/thread.jspa?messageID=40211鴓

You ask this question in your post:

Basically, T_LST table is a work table that is created, So I do not know how to access it ?

You would access T_LST by either a ONE-level or TWO-level name in a DATA step program. Either WORK.T_LST or just T_LST. If you mean that your SAS session ends and you need to get to T_LST in a new session, then you would either have to run your SQL step again or create T_LST in a permanent library. Something like:
[pre]
libname KEEPABIT 'c:\temp\mydata';

proc sql;
create table KEEPABIT.T_LST as select
a.Cust_ID, a.S_ID, a.fld_txt
from Pty_nm
group by 1, 2;
quit;

*** OR;

proc sort data=work.t_lst out=keepabit.t_lst;
by ...;
run;
[/pre]

About your code:
[pre]
If first.s_id then lngname = ' ';
Some kind of loop - Trim(fld_txt) ||
If last.s_id then Output;
[/pre]

I believe that "Some kind of loop - Trim(fld_txt) || " has been explained or discussed in some of the answers to your previous posts.

cynthia

topic Data formatting in SAS Programming

Data formatting

Re: Data formatting

Re: Data formatting