About learningsas101

learningsas101 · ‎09-08-2020

Proc freq won't work for what I want. Two others have already posted solutions that will likely work. I'll test them out today or tomorrow and let everyone know.

learningsas101 · ‎09-08-2020

This one will likely work as well and includes setting the values to 0 if missing and 1 if not.

learningsas101 · ‎09-08-2020

I think this might work. I'll give it a go and let you know.

learningsas101 · ‎09-08-2020

I tried, but for whatever reason, it would allow it. I'm trying to create counters for a data set. I've tried proc transpose, but it doesn't seem to get me where I want to be. I'm trying to avoid having to write 50 if/then statements. Perhaps something with Proc Transpose and then a do loop of some sort?

learningsas101 · ‎09-08-2020

I have a variable that has about 50 potential values which have no prefix/suffix or any pattern in them. I need to create a variable named that value and set the new variable to 1 with the other 49 new variables in that row to be set to 0. Here is a small sample of my current data set. Here is what I want.

Online Status	Offline
Date Last Visited	‎09-08-2020 03:16 PM

Re: Adding a new variable for each value of variable

Re: Adding a new variable for each value of variable

Re: Adding a new variable for each value of variable

Re: Adding a new variable for each value of variable

Adding a new variable for each value of variable

Re: Adding a new variable for each value of variable

Re: Adding a new variable for each value of variable

Re: Adding a new variable for each value of variable

Re: Adding a new variable for each value of variable

Re: Adding a new variable for each value of variable

Re: Adding a new variable for each value of variable

Adding a new variable for each value of variable