%let a=Peter; %let b=jhonson; %let peter_jhonson=salmon; %put &&a_&b; How to get salmon value ... View more

how to read date(ddmmyyd10.) in proc sql . I have tried below step but I didn't get any value...   proc sql ; create table ex1 (dob informat=ddmmyyd10. format=date9.) ; insert into ex1 values(10-12-2020) ; quit;   or     proc sql ; create table ex1 (dob informat=ddmmyyd10. format=date9.) ; insert into ex1 values('10-12-2020'd) ; quit;   how to take informats?     ... View more

data have ; input number ; cards ; 22.34 3.4 33 323.322 ; I have above data set Now how to keep right side alignment with data type is character . have...                 want 22.34                     22.34 3.4                             3.4 33                               33 323.322             323.322 How to create want variable? Note:Want is new character variable It should be in right side.   ... View more

data main ; input id score ; cards ; 101 200 102 355 ; proc sql ; select score into:rate1 from main where id=101 ; select score into:rate2 from main where id=102 ; select score into:rate3 from main where id=103 ; quit; %put &rate1 &rate2 ; data want ; set main ; var1=symgetn("rate1")*1 ; var2=symgetn("rate2")*1.5 ; var3=symgetn("rate3")*2 ; run;   I have one dataset like main in that only two id's there in future may be 3 id's there so I created 3 macro variables next I wrote One calculation I got var1 ,var2 results however for var3 I am getting error log window how to ignore that error. ... View more

I have sashelp.class and total 19 records . I have to create one more record it should be empty and record number is 6.   1.....values 2.....values 3....values 4....values 5.....values 6....empty record 7.....values..... ...... ... View more

data ex ; set sashelp.class ; if age=11 then new_age=age*1.1 ; else new_age=age*2 ; run; how to fix above program in particuar lines arrangement like see below arrangement example:   data ex ;     set sashelp.class ;     if age=11 then new_age=age*1.1 ;     else new_age=age*2 ; run;   ... View more

ods rtf file='D:\new\ss.rtf' ; options ps=3 ls=4 ; proc report data=sashelp.cars nowd ; column origin make type msrp ; run; ods rtf close ;   how to print 20 records for each page ... View more

ods rtf file='D:\new\testing.rtf' ; proc report data=sashelp.cars nowd style=[rules=none] ; column origin make type msrp ; define origin /order id; break after origin/page ; by origin ; run; ods rtf close ;   in testing file observe last page . Last page two records related but the origin column showing empty. So the order variable value should be print page start ... View more