Hi all, I it possible to provide a url to my spanned headers on proc report . A sample code is as below proc report data = sashelp.class; columns ("character" name sex) ("numeric" age height weight); run; i want a url to be added to the heders "character" & "numeric". is this possible. Please do guide. ... View more

Guys, Is it possible for a computed variable in proc report to have the concatenated values of two other variables. DATA A; XC='XXX'; XB='YYY'; RUN; PROC REPORT DATA=A; COLUMN XC XB NAME; DEFINE XC / DISPLAY; DEFINE XB / DISPLAY; define xcc / computed; define xbb / computed; DEFINE NAME / COMPUTED; COMPUTE NAME; NAME = XC || XB; ENDCOMP; RUN; What i am looking for is that my vaible NAME should be "XXX YYY". in the report. PLZ suggest ... View more

Guys, My stored process is one where my user enters his user name and password to be used in a pass through query. I have blocked the error log for the user and so. My problem is that there could be a connection issue because of which an error can occur or The user might have entered an incorrect password. Will i be able to customise and print an error message on each situation. I.e. will i be able to identify that my error was due to an incorrect password or due to a connectivty issues. Please Guide ... View more

Guys i was trying to save my graph output to a specified path. I wanted the output to be a .png file. I tried using the below code but the PNG file gets created in the work library and not in the defined my_folder path. Any suggestions... would be helpful Thanks filename graphout "/my_folder/"; goptions reset=all device=png gsfname=graphout; PROC GPLOT DATA = sashelp.class; PLOT Age * Name / name="mychart2" VAXIS=AXIS1 HAXIS=AXIS2 FRAME; RUN; QUIT; ... View more

Hi, In sas9.2 we have the option to specify the smtp to use to send our email during a session. With the emailhost emailport etc: options. When i try to use this i get the following error ERROR: No email identity, specify -EMAILID=userid in config file or on command line. I have specified the EMAILID="myloginid" in the options statement. If someone could please guide on this. Thanks ... View more

Guys, Is it possible to have two or more reports one below the other when defining them in tabs using the tableeditor tagset. The following link http://support.sas.com/kb/40/264.html gave some info but here the reports are panelled and not one below the other. If some one could guide as to how i could achieve this. The code i am trying is below ods tagsets.tableeditor file="temp.html" options(pagebreak = "2" web_tabs="part1,hide,part2,hide") style=statistical; proc means data=sashelp.class; run; proc gchart data=sashelp.class; vbar age; run; quit; proc freq data=sashelp.class; run; proc report data=sashelp.orsales nowd; run; ods tagsets.tableeditor close; ... View more

Guys, I was trying to create a dashboad on portal. My concern is , why is it that the portlet only takes up one fourth of the page size no matter how many KPI's i add to the dashboard. Any Help in understanding this ... View more

Guys , in the below macro i want my put statement to run 10 times if condition= a is satisfied and just once if condition = b is satisfied. My problem is that i donot wish write the put statement twice in my query %macro test(condition =); %put "this is just a test"; %mend; %test(condition = a) %test(condition = b) i donot wish to do this::::: %macro test(condition =); %if "&condition" = "a" %then %do i=1 %to 10; %put "this is just a test"; %end; %if "&condition" = "b" %then %do i=1 %to 1; %put "this is just a test"; %end; %mend; %test(condition = a) %test(condition = b) can someone help with this.. ... View more