When I look at this question, I thought the answer should be 4 variables including a new variable ``Group``. However, the correct the answer is 3. I am a bit confused about the IF statement, what is the result for this IF statement then? Thanks for help.
There's a stand-alone KEEP statement:
keep name height weight;
The stand-alone statement applies to the output, not the input. So the output data set contains only those three variables. It doesn't matter how many variables are part of the input, or how many variables get created along the way by programming statements.
There's a stand-alone KEEP statement:
keep name height weight;
The stand-alone statement applies to the output, not the input. So the output data set contains only those three variables. It doesn't matter how many variables are part of the input, or how many variables get created along the way by programming statements.
The IF statement is a pointless red herring.
It creates a value of GROUP for records with a value of AGE meeting a condition, but then noting is done with it. It's stupid and not anything you would write in real life.
Thanks for your reply. Is there something wrong this the IF statement? What if we do want to create a variable Group to set age >=13 to be "Teen". How would you write the programme to make it appear to the output? Thanks!
You would need to add a fourth variable to the list of those being kept:
keep name height weight group;
The rest of the program could remain unchanged.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.