topic delete or hide variables row in SAS Programming

delete or hide variables row

mona4u — Tue, 03 Apr 2018 13:16:43 GMT

I have this data set and I need to hide or delete the variables row in data step or proc report

my current data set

Obs	Vname	Vvalue
1	case_assigned	5
2	Time_points_read	53
3	Time_points_complete	1360
4	Readable_Time_Points	15
5	Time_Points_Pending	15
6	off_study	0
7	off_study_Total	0

my desire data set

1	case_assigned	5
2	Time_points_read	53
3	Time_points_complete	1360
4	Readable_Time_Points	15
5	Time_Points_Pending	15
6	off_study	0
7	off_study_Total	0

Re: delete or hide variables row

RW9 — Tue, 03 Apr 2018 13:41:59 GMT

You can only hide column names or labels in output files. Datasets when viewed in SAS always have names, and also possibly labels. Hiding names/labels isn't straight forward in output either. What is your output destination? The simplest method I can think of is that you dump the data out as plain text:

data _null_;
  set have;
  file "want.txt";
  put obs vname vvalue;
run;

Without specifying what you want further (i.e. be specific, e.g. my rtf file should show this data formatted without variable names/labels) its quite hard to say.

Re: delete or hide variables row

mona4u — Tue, 03 Apr 2018 14:11:34 GMT

my destination will be in sas program .

Re: delete or hide variables row

RW9 — Tue, 03 Apr 2018 14:36:22 GMT

A SAS program is not a destination. Saved files such as text files, CSV, Excel, RTF etc. are destinations. Datasets are datasets. SAS programs are text files which get compiled into computer runnable code. Post examples of what you mean, test data etc. so we can see.

Re: delete or hide variables row

mona4u — Tue, 03 Apr 2018 17:00:25 GMT

I just want to create a data set I don't need to output it any where

Re: delete or hide variables row

ChrisNZ — Wed, 04 Apr 2018 02:18:40 GMT

You can't have a data set without column names.