- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
E g ,
Abdominal
No
Yes
Cardiovascular system
No
Yes
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Looks like stacking cols ... this is available as a point and click task in Studio under Tasks->Data->Stack/Split Columns.
Generates something like this:
data work.TestData;
input Col1$ Col2$ Col3 $;
datalines;
A B C
D E F
;
run;
data work.__tmp__;
set WORK.TESTDATA;
_Case_=_n_;
run;
proc transpose data=work.__tmp__ out=work.TestOut(drop=_Label_
rename=(col1=StackedCol)) name=_Level_;
var Col1 Col2;
by _Case_;
run;
proc delete data=WORK.__tmp__;
run;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
@Tejaswini3 wrote:
Without transpose statement, pls write code to solve
Why is that? Than you needed to detail your problem a bit. ... let's say just to motivate people. 😉
Err ... being with it: My observation is that you keep on asking the same questions over and over (e.g. here and here ). You got answered there, though you have neither marked these threads as solved nor detailed what was missing to an acceptable solution. ... sooo, could you help us a bit, please?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Should this be a report?
And do not post pictures of data. Ideally, post data step code (with DATALINES) to create a copy of your dataset.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
If you need someone to do your work for you, you should hire a consultant.
And you have neither answered my question, nor provided usable data.