Hello,   I am creating 3 tables using proc sql and I want to create a new column for each of them. I just know case when to create column based on different conditions. But here, I only want to create one to work like a lable: new column=secure the value would be Y   thank you. ... View more

APPLICATION NEW SAPPLICATION S1     S2     S3 3E+14 300000002035314 S4 3E+14 300000002227110 Hello, Above is a piece of my table, what I want to do is when New=blank, then new=sapplication; DATA want; SET have; IF NEW = '.' THEN DO; NEW= TRIM(PUT(SAPPLICATION,15.-L)) ; END; run;   but the new is still in the format of 3E+14. can someone help this? thank you. ... View more

Hi Professionals,   I created a simple sample for my tables. the original one is like: APPLICATION CODE1 CODE2 CODEB1 CODEB2 1111 F S F S 1112 N   N   1113 CF   CF   1114     B<40   1115     F S 1116     F   my goal is to create: APPLICATION CODE1 CODE2 1111 F S 1112 N   1113 CF   1114 B<40   1115 F S 1116 F   For each application, when code1 ='' and code2=''  let code1=codeb1 and code2=codeb2. for the rest code 1 or code2, just keep their original value. then delete codeb1 and codeb2.   How can I do the merge? data new; set origianl; if code1='' and code2='' then code1=codeb1 and code2=codeb2; else (here I dont' know how to describe let codes = original value); run;   thank you for anyone who helps. ... View more

Hello,   I want to combine two dataset: PL and PLC vertically, so I use the data all; set PL PLC; run;   I hope the output will show: a title for PL and a title for PLC in one dataset , does anyone know how and where can I add that please?   Thank you ... View more

Hello, I am trying to create table using proc transpose to generate the things below. I dont know how to just convert the CODE to horizen but still fits the application_number and action and also the appstatusdate will change with it.  If anyone could help, I will appreciate that. Thanks.       ... View more