Search results for query: *

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

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

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

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

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

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...

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

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...

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

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.

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

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...

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

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;

Hi all, I am getting multiple instances of same values when I use proc means 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...

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

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

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 ...

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

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