About rawindar

rawindar · ‎08-08-2012

Hi all, We use datawarehouse to store historical data,we can store huge volumes of data.But it should have limit.I have read that in DWH once entered data can not be erased.Is it true? Thanks, rawindar

rawindar · ‎05-04-2012

Yes Peter its working iam looking for to solve this in data step.But i couldnt understand that above functions.

rawindar · ‎05-04-2012

Thanks Patrick.I already tried it, its working but iam looking for any data step method instead of proc step.

rawindar · ‎05-04-2012

Hi all, I just want to know can we get non matching observations using joins. Thanks&Regards rawindarreddy

rawindar · ‎05-02-2012

thanks sanjeev, But in case column contains values like 'abc@' means with out domain names we cant get values right.

rawindar · ‎05-02-2012

hi hai.kuo i didnt understand what that job of praxmatch.I didnt understand how it works and what happening here.Can you help me to understand this code. Thanks &Regards Rawindarreddy

rawindar · ‎05-01-2012

Hi all, i have a mailid dataset as follows with coloumn mail having mail id's and missing values and having invalid data. mail rawindar raw... rawindar@gmail.com a... abc@ymail.com ; Now i want to get valid mail id's and i want to delete all other invalid.How can i get it.Can anybody help me plz Thanks&Regards Rawindarreddy

rawindar · ‎04-30-2012

Hi all, Can anybody help me to clarify my doubt if possible with example. 1. Can we use %let statement in datastep. 2.Can we use symget function in macros. Thanks&Regards Rawindarreddy

rawindar · ‎04-28-2012

thank......u Cynthia.I got it

rawindar · ‎04-28-2012

thnks ksharp

rawindar · ‎04-28-2012

thanks patrick its working

rawindar · ‎04-28-2012

Hi all, Can any body help me to understand how it will executes %let one=two; %let two=three; %let three=Check; %put &one; %put &&one; %put &&&one; %put &&&&one; %put &&&&&one; %put &&&&&&one; %put &&&&&&&one; %put &&&&&&&&one; %put &&&&&&&&&one; %put &&&&&&&&&&one; what is the differnce between &,&& and &&& How can i understand this concept. Thanks &Regards Rawindarreddy

rawindar · ‎04-28-2012

hi all, I have two datasets as follows.Now i want to combine these boath datasets based on matching variable "no" and i want to get non matching observations from boath dataset in o/p .How can i get get it.Can anybody help me plz. data a; input no name$; datalines; 1 x 2 y 3 z ; data b; input no sal; datalines; 2 1000 4 2000 5 3000 ; i want o/p as follows no name sal 1 x . 3 z . 4 2000 5 3000 This is an interview question Thanks&Regards Rawindar

rawindar · ‎04-27-2012

Hi all i have a one dataset with two variables cost,vat as follows data x; input cost vat; datalines; 1000 100 5000 500 10000 . . . ; Now i want to add these two variables and addition of these two variables in new variable ADDITION and i dont want missing values in these variable. Thanks &Regards rawindarreddy

rawindar · ‎04-27-2012

Hi all, Is there any other way to create MACRO VARIABLES except %let and callsymput.This is an interview question. Thanks&Regards Rawindarreddy

Online Status	Offline
Date Last Visited	‎04-12-2018 08:40 AM

Re: First 3months transaction amount

Re: First 3months transaction amount

First 3months transaction amount

Re: How to convert char date to date in SQL SAS

Re: update master dataset with transact datset

update master dataset with transact datset

Re: Create a csv file in SFTP server

Create a csv file in SFTP server

Re: Changing title statement based on condition

Changing title statement based on condition

datawarehouse

Re: how to get valid mail ids from a coloumn

Re: how to get valid mail ids from a coloumn

joins

Re: how to get valid mail ids from a coloumn

Re: how to get valid data

how to get valid mail ids from a coloumn

%let & symget

Re: macro variables

Re: how to get non matching observations

Re: how to get non matching observations

macro variables

how to get non matching observations

avoiding missing values

creation of macro variables