hi all i am new to sas we have our sas servers on Linux. is it possible for me using sas enterprise guide to use DDE funtionality     ... View more

hi all i use filezilla to put a excel onto the server in my program i bring in the file as follows x cp /users_ac/amardeep.singh/Daily_Results_Template.xlsx %sysfunc(pathname(work))/Daily_Results_Template.xlsx; then import some data into that excel tab is there a way to then convert that into a pdf or its not possible in sas eg   ... View more

hi all  i am new to sas and using SAS EG i am trying to do two things using proc report my data is following h1 | rgu sales | 700 wow | .5 what i want to do is format alignment of h1 column that if value is sales then align to right, if value is wow then align h1 column to left. also i am able to change the wow rgu value to percent but how do i color it to red if negative and green if positive. any suggestions would help ... View more

hi all i am new to sas i have been trying to create a report using this code but its not working properly proc report data=work.test; columns product state city; define product /group; define state /across define city /across; run; results come out as                               california     new jersey       los angeles     trenton product 1 whereas i want the output to look like this                               california           new jersey                               los angeles         trenton product 1 any idea how i achieve that i want the across one underneath the other so it looks like grouping and not one after the other ... View more