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

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

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

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

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

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

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

Hi, Is there any possible way of splitting up a log of a program.I am using macros and generating 4 different reports for 4 different groups inside the same program.Since I am calling the variables inside the same program, the log is really huge.Does SAS 9.1.3 support in anyway so that we can...

Hi Is there a method of giving different colors to the cells within the excel, when the output is generated using ODS .Can it be done using some options that comes for generating html output.Is this possible. I would like to have a few cells within excel spreadsheet in different colors.Can...

Hi, Is there a method for generating sequential numbers 000001 000002 000003 . . . . . Since I did not know any specific method, I used excel and then saved it in formatted space delimited text and read the file to create a sequential dataset. I also want to combine this sequential dataset with...

hi, I have a field A in dataset 1 and field B in dataset 2.I want to compare the value of field A with field B and if it matches keep only field A values.Is there any method other than sort and merge and if statement because it is 2 different data sets even though in the same library.Can some...

hi, I have date 08/20/54 in the format MMDDYY8.I want to create a key which is a substring of other variables, for example lastname with the date variable. if I do a substr, all i get is a weird number -1960. /* key = substr(LAST_NAME,1,3)||substr(DATE,1,2)||substr(DATE,4,2)||substr(DATE,9,2)...

Hi all, Is there a way of importing or reading data from excel without converting the raw data into csv or text format.Does proc import have a solution for this.Can some one inform me of this. Thanks in advance, nirmal