BookmarkSubscribeRSS Feed
mona4u
Lapis Lazuli | Level 10

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 

 

ObsVnameVvalue
1case_assigned5
2Time_points_read53
3Time_points_complete1360
4Readable_Time_Points15
5Time_Points_Pending15
6off_study0
7off_study_Total0

 

my desire data set 

 

1case_assigned5
2Time_points_read53
3Time_points_complete1360
4Readable_Time_Points15
5Time_Points_Pending15
6off_study0
7off_study_Total0
5 REPLIES 5
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

mona4u
Lapis Lazuli | Level 10

my destination will be in sas program . 

RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

mona4u
Lapis Lazuli | Level 10

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

ChrisNZ
Tourmaline | Level 20

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 1199 views
  • 3 likes
  • 3 in conversation