About sambasiva_ravuri_tcs_com

sambasiva_ravuri_tcs_com · ‎03-21-2012

Hi, Here am seeing one of the column ID is Alphanumeric and even the length of ID also not fixed. Please confirm the length of Id once. Regards, S Ravuri.

sambasiva_ravuri_tcs_com · ‎03-21-2012

Thanks for quick response Ballardw. I got some of Automatic Variables info and am just sharing for the same. _ALL_ Lists the values of all macro variables.specifies all variables that are currently defined in the current DATA step. _AUTOMATIC_ Lists the values of all automatic macro variables _USER_ Lists the values of all user-defined macro variables _NUMERIC_ specifies all numeric variables that are already defined in the current DATA step. _CHARACTER_ specifies all character variables that are currently defined in the current DATA step. Regards, S Ravuri.

sambasiva_ravuri_tcs_com · ‎03-21-2012

Dear All, Please help me that whether it is possible to write a program in such a way that some new observations can be written to freed space in compressed SAS Datasets ? If yes, kindly share the info. Regards, S Ravuri.

sambasiva_ravuri_tcs_com · ‎03-16-2012

Haikuo, Am already did that. Thanks for suggestion. Am between couple of meetings.So that is the reason am not able to do it on time and am sorry for that. Regards, S Ravuri.

sambasiva_ravuri_tcs_com · ‎03-16-2012

Hello Ksharp, Codes are worked very well and i really appreciate for your help. If you don't mind, what is the significance of "_numeric_ " Automatic variable which you used in the code ? Can you please share if you have a list of Automatic variables in SAS with explanations and that will be really helpful going forward. Regards, S Ravuri.

sambasiva_ravuri_tcs_com · ‎03-16-2012

Dear All, Day by day when we are working with SAS, coming to know so many Automatic Variables. I just want to know whether we can find list of all Automatic variables available in SAS ? If anyone is having URL, that will be really helpful before you want to use any of the Automatic variables (Except Macro Automatic variables). Thanks a lot in advance for help. Regards, S Ravuri.

sambasiva_ravuri_tcs_com · ‎03-16-2012

Dear All, I would like to write a program to read a file set all empty variables to missing values. Is it possible in SAS ? Thanks a lot in advace for help and appreciate for the same. Regards, S Ravuri.

sambasiva_ravuri_tcs_com · ‎03-16-2012

Dear All, Is it possible, to write a program that converts missing values to zero and values of zero to missing for numeric variables using array statement? Appreciate and thanks a lot for help. Regards, S Ravuri.

sambasiva_ravuri_tcs_com · ‎03-16-2012

Dear All, Is it possible to concatnate Datasets by using Macro? If yes, can some one explain by using an example please ? Thanks a lot in advance for help. Regards, S Ravuri.

sambasiva_ravuri_tcs_com · ‎03-16-2012

Dear All, Is it possible to write a SAS Program to read the nth observation from a dataset by Direct Access ? Thanks a lot in advance for help. Regards, S Ravuri.

sambasiva_ravuri_tcs_com · ‎03-16-2012

Keith, Code worked Well. Thanks a lot and appreciate for your great help. Regards, S Ravuri.

sambasiva_ravuri_tcs_com · ‎03-15-2012

Thanks Keith for the reply. Am getting the values for difference in days, months, and years in between. Can you please help me how can we get the no.of days for prior month to the current month. Thanks a lot in advance for help. Regards, S Ravuri.

sambasiva_ravuri_tcs_com · ‎03-15-2012

Dear All, I would like to write a SAS program to get the current date and determine number of days in the month prior to current month. Find difference in days, months, and years between. Is it possible using SAS ? Thanks a lot for help. Regards, S Ravuri.

sambasiva_ravuri_tcs_com · ‎03-15-2012

Dear All, Am having the date of Births as Input and i would like to write using DATE Functions, the no.of days between Birth Date and Today's Date in output dataset ? 11/12/87 12/04/56 03/06/79 04/05/94 03/07/99 03/07/99 Kindly help me. Regards, S Ravuri.

sambasiva_ravuri_tcs_com · ‎03-15-2012

SET statement is used to read Input/Records. APPEND is A proc in SAS. PROC APPEND BASE=SAS-data-set DATA=SAS-data-set; RUN; where BASE=SAS-data-set names the data set to which you want to add observations. DATA=SAS-data-set names the SAS data set containing observations that you want to append to the end of the SAS data set specified in the BASE= argument. PROC APPEND reads only the data in the DATA= SAS data set, not the BASE= SAS data set. PROC APPEND concatenates data sets even though there may be variables in the BASE= data set that do not exist in the DATA= data set. When the BASE= data set contains more variables than the DATA= data set, missing values for the additional variables are assigned to the observations that are read in from the DATA= data set and a warning message is written to the SAS log. Let me know if you have any questions. Regards, S Ravuri.

Online Status	Offline
Date Last Visited	‎03-04-2019 12:28 PM

Re: 3 FAQs on date calculations in SAS Visual Analytics

Converting txt file into SAS Dataset

Out Parameter in PROC FREQ

Re: Invalid Logical Name

Invalid Logical Name

Need to find how many distict values along with count ?

Need to find whether the field is populated or not in SAS File.

Need to fetch a single value from the existing dataset

New Observations can be written to freed space in compressed SAS Datas...

Need to fetch a single value from the existing dataset

difference between SET and APPEND

how to read in really messy data like this?

List of Autiomatic variables in SAS ?

New Observations can be written to freed space in compressed SAS Datas...

Re: Converts Missing values to Zero in SAS using Array statement?

Converts Missing values to Zero in SAS using Array statement?

List of Autiomatic variables in SAS ?

Set all Empty variables to Missing Values ?

Converts Missing values to Zero in SAS using Array statement?

Using Macro, How we can concatenate datasets ?

SAS program to read the nth observation from a dataset by direct acces...

Using Dates Functions find days in the month prior to current month

Using Dates Functions find days in the month prior to current month

Using Dates Functions find days in the month prior to current month

No.of days between birth date and today's date

difference between SET and APPEND