data original; input DETAILS $ TYPE $ DIS $ SE_EMG $ SU_EMG $ group; datalines; 1 THREATS jal Agri Crops 4 3 OPPORTUNITIES jal Agri Crops 5 2 THREATS jal Agri Crops 5 4 OPPORTUNITIES jal Agri Crops 6 6 WEAKNESS jal Agri Crops 6 5 OPPORTUNITIES jal Agri Crops 7 10 STRENGTHS jal Agri Crops 7 7 WEAKNESS jal Agri Crops 7 11 STRENGTHS jal Agri Crops 8 8 WEAKNESS jal Agri Crops 8 12 STRENGTHS jal Agri Crops 9 9 WEAKNESS jal Agri Crops 9 13 STRENGTHS jal Agri Crops 10 14 STRENGTHS jal Agri Crops 11 15 STRENGTHS jal Agri Crops 12 ; run; proc sort data=original; by group; run; proc transpose data=original out=transposed; by group; id type; var DETAILS; run; i want  group SE_EMG SU_EMG DIS THREATS OPPORTUNITIES WEAKNESS STRENGTHS 4 Agri Crops Jal 1 3 6 10 5 Agri Crops Jal 2 4 7 11 6 Agri Crops Jal   5 8 12 7 Agri Crops Jal     9 13 8 Agri Crops Jal       14 9 Agri Crops Jal       15 10 Agri Crops Jal         11 Agri Crops Jal         12 Agri Crops Jal         ... View more

data SampleData; input ID Name $ Age; datalines; 1 John 30 2 Alice 25 3 Bob 35 4 Carol 28 5 David 40 ; run; %macro create_sample_data; %let id=1; proc print data=SampleData; where id=&id; run; %mend create_sample_data; %create_sample_data; Can we connect sas studio to sas dashboard via paramere as button to automatically change , just like stored process  ... View more

  /* Enable ODS PDF output */ ods pdf file="output.pdf"; /* Create a sample dataset with the currency symbol */ data example; indian_currency_symbol = '₹'; run; /* Display the dataset in the PDF output */ proc print data=example; run; /* Close the ODS PDF output */ ods pdf close; The Indian currency symbol '₹' is not displayed in the PDF output.   output     ... View more

/* Enable the ODS MARKUP destination */ ods markup file="example.xlsx" style=sasweb; /* Your SAS code here */ data example; input Name $ Age Height Weight; datalines; John 25 175 70 Mary 30 160 55 Bob 28 180 80 ; /* First PROC REPORT */ ods text=" "; /* Insert a page break before the first PROC REPORT */ proc report data=example nowd; /* Define your first report here */ column Name Age Height Weight; define Name / display; define Age / display; define Height / display; define Weight / display; run; /* Insert another page break between reports */ ods text=" "; /* Insert a page break before the second PROC REPORT */ /* Second PROC REPORT */ proc report data=example nowd; /* Define your second report here */ column Name Age Height; define Name / display; define Age / display; define Height / display; run; /* Disable the ODS MARKUP destination */ ods markup close; ods text=" "; code Creating the box . i need to one proc report one page and second proc report on second page ... View more

  Pls help Code not properly work %let path=/desreports; ods tagsets.excelxp file="&path/temp.XLS" Style=my.style; data class; set sashelp.class; run; proc report data=class; run; ods tagsets.excelxp close; %convert_files(default=&path,ext=XLS); /*------------------------------Convert () to XLSX--------------------------------*/ options noxwait noxsync; %macro convert_files(default=,ext=); data _null_; file "'&default/temp.vbs'"; put "set xlapp = CreateObject(""Excel.Application"")"; put "set fso = CreateObject(""scripting.filesystemobject"")"; put "set myfolder = fso.GetFolder(""&default"")"; put "set myfiles = myfolder.Files"; put "xlapp.DisplayAlerts = False"; put " "; put "for each f in myfiles"; put " ExtName = fso.GetExtensionName(f)"; put " Filename= fso.GetBaseName(f)"; put " if ExtName=""&ext"" then"; put " set mybook = xlapp.Workbooks.Open(f.Path)"; put " xlapp.Visible = false"; put " mybook.SaveAs ""&default./"" & Filename & "".xlsx"", 51"; put " End If"; put " Next"; put " mybook.Close"; put " xlapp.DisplayAlerts = True"; /* Removes original files */ put " FSO.DeleteFile(""&default/*.&ext""), DeleteReadOnly"; put " xlapp.Quit"; put " Set xlapp = Nothing"; put " strScript = Wscript.ScriptFullName"; put " FSO.DeleteFile(strScript)"; run; x "cscript ""&default/temp.vbs"""; %mend;   ... View more

i have  proc report data=sashelp.class(obs=8) ; define sex / "Sex" order; compute before sex; line ' aaa '; endcomp; run; result  i want increase cell space          ... View more

i have this type of data i want  i have font name but my font not working on my sas eg . font is "DVOT-SurekhMR". PROC SQL; CREATE TABLE WORK.have AS SELECT t1.TOT_GOV_SCH, t1.TOT_GOV_SCH_GRL, t1.TOT_TCHR_GOV_SCH, t1.TOT_TCHR_GOV_SCH_GRL, t1.TOT_BOY_GOV_SCH, t1.TOT_BOY_GOV_SCH_GRL FROM Work.temp t1 ; QUIT; ods rtf file="report.rtf" style=styles.minimal bodytitle_aux ; proc report data= have; run;   ... View more