Attached data. what i need is if PDCTREAS(resons for withdrawal is present then add a row in desc and desc_fmt and value for treatment as 1 . i am trying the below code but it doesnt work.
if PDCTREAS ne "" then do;
desc= "ByPrim";
dsreas_num_trt= 1;
dsreas_fmt = " "||PDCTREAS;
sort1 = 88;
output;
end;
Without looking into the attached data set I believe what you're missing is an OUTPUT statement.
/* option 1 */
data old;
set old;
OUTPUT;
if <some condition> then
do;
varA=1;
...
OUTPUT;
end;
run;
/* option 2: "better" */
data new_stuff;
set old;
if <some condition> then
do;
varA=1;
...
OUTPUT;
end;
run;
proc append base=old data=new_stuff;
run;
If i use the condition
if PDCTREAS ne "" then do; then it removes everything which is missing but i need all the data and add new variables.
I am not able to find out a way
That's why you need a first OUTPUT statement right after the SET statement. This will write all observations from the input data set directly to the output data set.
Then comes your condition. Whenever the condition is TRUE you're doing additional variable assignments and then you're issuing an additional OUTPUT statements which writes another row to the output table.
... or even better: Just collect all new rows into a table and then append this table to your original data set (that's Option 2).
Your suggestion won't work. The inserts need to be conditioned on some comparison.
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.