hi,iam trying to convert the data below to tranpose in SAS DI,but iam not getting what iam expecting.please help.   Sample data input to transpose:   Value NAME FILE1 Status SSSSS 567Q44104 DADA Not Applicable SSSSS 20726910   Accepted Banking 567Q44104 DADA Not Applicable AAG Portf 567Q44104 DADA Not Applicable AAG Portf S68855kl   Not Applicable Failed S68855kl   Not Applicable Cache S68855kl   Not Applicable AAG Txn 567Q44104 DADA Not Applicable AAG Txn S68855kl   Not Applicable AAG Txn 20726910   Accepted ADF 20718435   Accepted ADG 20726910   Accepted CXE S68855kl   Not Applicable   After transpose sample output as below :   NAME Value1 Value2 Value3 Value4 Value5 FILE1 Status 567Q44104 SSSSS Banking AAG Txn     DADA Not Applicable 20726910 SSSSS AAG Txn ADG       Accepted i was using below ,but not working as expected.please help. PROC SORT DATA=WORK.TEST OUT=WORK.SORTTempTableSorted ; BY NAME; RUN; PROC TRANSPOSE DATA=WORK.SORTTempTableSorted OUT=TRNSTRANSPOSED PREFIX=VALUE; BY NAME; VAR VALUE; COPY STATUS FILE1; RUN; QUIT;     ... View more

Hi,  i need to take backup for SAS dataset in one SAS DI job  only on sunday's.i was trying below code but not working.please help or kindly suggest if you have any other best suggestions please.getting error as below.but the below code is not running by checking the condition,it is just running irrespective of condition.please help 21 %if %eval(&day = 01) %then %do; ERROR: The %IF statement is not valid in open code. 22 data work.&source_table._&date1; 23 24 set &_input1; 25 26 %end; ERROR: The %END statement is not valid in open code.   %let _input1=sashelp.cars; %let source_table=cars; %let date1 = %sysfunc(putn(%sysfunc(date()), yymmddn8.)); data _null_ ; call symput('day', put(weekday(today()),z2.)); run; %if %eval(&day = 01) %then %do; data work.&source_table._&date1; set &_input1; run;   ... View more