topic Re: Header in SAS Procedures

Header

deleted_user — Mon, 07 Mar 2011 18:54:21 GMT

Hi,

I need to export this dataset to a txt file. while running this code, the data got exported , but am not getting headers like v1,v2..please let me know hoew to include headers ..

data vishal;
input v1 $1. v2 v3 v4 test&$20.;
cards;
a 1 2 3 test^it
b 4 5 6 test this
c 7 8 9 none
;
run;

data _null_;
set vishal;
file 'C:\Documents and Settings\\Desktop\vishal.txt' DLM=',';
put ( _all_ ) (~);
run;

Thanks in Advance !!!

Re: Header

garybald — Mon, 07 Mar 2011 19:03:12 GMT

before your put statement, try this

if _n_ = 1 then do;
put 'v1' '~'
'v2' '~'
etc.
end;

Re: Header

deleted_user — Mon, 07 Mar 2011 19:12:13 GMT

Hi Gary ,

I tried as below.. its not working ..

data _null_;
set vishal;
file 'C:\Documents and Settings\Desktop\vishal.txt' DLM=',';
if _n_ = 1 then do;
put 'v1' '~' 'v2' '~';
put ( _all_ ) (~);
run;

Re: Header

deleted_user — Mon, 07 Mar 2011 19:21:13 GMT

Yes Gary Its worked out !!!
I missed the end statement ..

ThankYou !!

Re: Header

SPR — Mon, 07 Mar 2011 19:26:04 GMT

Hello Raveenat,

Try to use the proc EXPORT like this:
[pre]
proc export DATA=Vishal
OUTFILE='C:\Documents and Settings\\Desktop\vishal.xls'
DBMS=CSV REPLACE;
run;
[/pre]
Sincerely,
SPR

Re: Header

deleted_user — Mon, 07 Mar 2011 19:35:13 GMT

Yes SPR.. I tried proc export (need to export it as text file) too but am not getting variables on proper order.
Please suggest me how to get an variables on proper order ?

Re: Header

SPR — Mon, 07 Mar 2011 20:21:51 GMT

Hello Raveenat,

It looks like we move in circles. To order variables use a datastep with retain before set, then export. For example;
[pre]
data r;
retain A,B,C;
set i;
run;
[/pre]
Dataset r has variables in the order A, B, C irrelevant to their order in i.
Sincerely,
SPR

Re: Header

deleted_user — Mon, 07 Mar 2011 20:42:59 GMT

Thanks SPR !! Its perfect now !!