Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nirmalraj

    SAS Stored procedure

    How would I find one variable inside multiple programs situated inside a stored procedure
  2. nirmalraj

    Font Script

    Hi All, I am trying to use a SAS script font instead of regular font which will resemble like a signature. Does any one know how to write a script which is acceptable in SAS pdf output. I would like the font face to be scripted. I would really appreciate any suggestions. Thanks, Raj
  3. nirmalraj

    digital signature in pdf

    Hi, Does anyone know a method to write digital signature using pdf text and escape character.If not, is there atleast a list of fonts that SAS supports which will resemble like a signature. Your help is appreciated. Raj
  4. nirmalraj

    drill up/down in report using report studio -cog 8.3

    Hi Power users, Can anyone guide me how to use the drill up/down feature when creating chart using report studio. I am able to create prompt pages for different layers but down able to drill down. Can some body please guide me on this. Thanks, Raj
  5. nirmalraj

    proc report and sorting months

    By the way I am using proc report to output on excel, which I assume that excel automatically sorts by characters. Any suggestions. - Raj
  6. nirmalraj

    proc report and sorting months

    Hi, I have month variable which I initially taken in as 1,2,3,4...Later while doing proc report, I use proc format but while printing out the report, the values get sorted by alphabets and not by month order.Is there a way to fix this to make sure that Jan comes on top and Dec comes last. Any...
  7. nirmalraj

    tilde delimted output

    Lets assume the value variable X1 is numeric. I only want to write a file out in tilde limited format and the variables rolled up. 77777~Raj~Sub~~~ 77777~~84745834~~ 77777~~~~~sas say an output like this 77777~Raj~Sub~84745834~sas~ I think we have to use line hold specifier. Thanks, Raj
  8. nirmalraj

    tilde delimted output

    Hi I have a raw data which has 20 observations and 10 variables. These 20 observations actually contain the same id number, say repeats of 5, that is each id number occurs 5 times. Of the 10 variables only certain variables are present for each observation. Is it possible for me rollup the...
  9. nirmalraj

    ODS to Excel page size

    Thanks Chris. I did try using excel tagset and it did work.Also SAS institute gave me a similar code that you have here. So its all good as long as its working. Thanks!!! Raj
  10. nirmalraj

    ODS to Excel page size

    Thanks Chris.I do not use tagsets.I might try them in future but I like the "zoom =" option. let me try that and see what happens.
  11. nirmalraj

    ODS to Excel page size

    Hi All, Is there a way method to reduce the page size when creating output on excel using ODS.Say I have 10 columns and want to see all 10 columns. Can I reduce the percentage of page size driving from SAS. Any suggestions would be great. - Raj
  12. nirmalraj

    Macro Advice

    Well Chris, It was not that either.I did have to get around it and truncated the .txt in unix and later cat with the .txt in sas job. My assumption was no matter what is passed (put) in a string the macro variable to be able to return it when called but it does not happen so with a delimiter in...
  13. nirmalraj

    Macro Advice

    Hi All, I have worked with normal macros but here I am trying to resolve a macro with an extension. example: % let x = 1243.txt; Later down the program when I am trying to reference, it gives me an error stating syntax error. y = &x; Is there a way around it. Thanks in advance, Raj
  14. nirmalraj

    How many have each kind of test?

    try this just for checking.just a 2 way freq. proc freq data = mytest; tables patient*test_type /missing ; where test_type in ('A','B','C','D','E');run;
  15. nirmalraj

    Proc means Repetition

    ...to sum up by 2 variables , say gender and age but I am getting 4 age groups and same summed up value. I there a way to debug this. Thanks, Raj ********************************************************; proc freq data = A noprint; tables participants*sex*age_r/ list missing nocol norow...
  16. nirmalraj

    Populating one column in Excel Spread sheet using unixsas

    Hi, Instead of creating one column, Is it possible to create multiple spreadsheets using unix sas. Thanks Raj
  17. nirmalraj

    Populating one column in Excel Spread sheet using unixsas

    Hi, I have used ods techniques to create excel spreadsheets and everything seems fine.I am using Unix SAS. Is there a way of populating one column in a spreadsheet without having to overwrite other columns.If anyone has some idea on it, it would be great. Thanks, Raj
  18. nirmalraj

    using count along with select in PROC SQL

    Hi, Is there a possible way of performing a count when doing a PROC SQL. An example of what I am trying to calculate: /* proc sql; connect to db2 ; create table mylib.a as select * from connection to db2 ( SELECT abc as a ...
  19. nirmalraj

    Importing Data from Excel Using Unix/SAS

    Chris, Thanks, let me try the option.I was never aware of this.I'll post the outcome. Raj
  20. nirmalraj

    Importing Data from Excel Using Unix/SAS

    Hi All, Is there a method of importing data values from an excel worksheet(s) using unix SAS.I know we can do it using PC sas but wanted to find out for Unix Sas.I heard there is a trick for doing this.Dont know how, so just shooting across. btw I am using SAS version 9.1 Thanks, Raj

Part and Inventory Search

Back
Top