About bnarang

bnarang · ‎12-27-2012

This might be useful http://support.sas.com/feedback Choose discussions cateogory

bnarang · ‎12-26-2012

Basically, it creates a composite index used in datastep. For the literature,, You can refer to this document http://www2.sas.com/proceedings/sugi29/123-29.pdf

bnarang · ‎12-20-2012

, Basically, By looking at the query, I assume that datset has some date format or informat applied since he talks about streamlining that is standardizing like applying the same set of formats. For character data, definitely , we need to know data and there can be no shortcuts.

bnarang · ‎12-20-2012

I think Date is numeric and there s no differentiator ( Correct me if I am wrong @all SAS Experts). To streamline dates, I would use Dictionary.columsn to list out all the possible date related variable and format them to streamlined them basically as per your objective. For example, you have data: data temp; input x report_date date9. deal_date ddmmyy10.; format report_date date9. deal_date ddmmyy10.; datalines; 1 22jan2001 01/04/08 2 15Mar2002 05/09/01 ; proc sql; select name into : list separated by ' ' from dictionary.columns where libname = "WORK" and memname = "TEMP" and format in ("DDMMYY10.","DATE9."); quit; data temp1; set temp; format &list. date9.; run; I listed out the possible date format, you can provide a complete list. Then with Format statement, I streamlined.

bnarang · ‎12-19-2012

Thank you so much Linlin. I did not know about call symputx. It's such a great place to learn.

bnarang · ‎12-19-2012

You can Create a custom format with Proc format and apply the same in your data. For example: proc format; value $rate 'AAA' = 1 'AA+' = 2 'A+' = 3 'BBB' = 4 ; run; Data want; set have; format variable-name rate.; run;

bnarang · ‎12-18-2012

So, you have more than 13 rows of data in your input file and they are delimited by "TAB" I believe. To read them, you need to give right options in infile statement which is clearly specifiying the dlm ='<options>'. In your case, for Tab delimited file, it should be '09'x and dsd option . so, code would be: data temp; infile "D:\example.dat" dlm ='09'x dsd; input x1 x2 x3 x4; run; Here, I just took only 1st four set of columns, you can include all of them and run.

bnarang · ‎12-16-2012

Yes, As Aurthur and Cynthia mentioned, Some information is required. You use a high enough value. or Just open some good editor like ultra editor and observe the maximum value that particular variable can have but again this is one time solution. Again, if you append your files in future, You might need to change.

bnarang · ‎12-16-2012

Data temp; input var1 var2 var3 :$25.; datalines; 1 2 akjdh 2 3 sjfkdsfjfdsg 4 5 kokdslfmf 6 4 kvkdjfgkl 9 10 mkdmsklnjvnvdhbvdth ;

bnarang · ‎12-16-2012

Yes, Data_null_ , you are right. that would make it fast.

bnarang · ‎12-15-2012

I would have done it this way. %Macro temp; Data _null_; Set Temp end = eof; count+1; if eof then call symput('c_yr', compress(count)); Run; Proc sql; select years into : yr1 - :yr&c_yr from temp; quit; %do i= 1 %to &c_yr; Data Y&&yr&i.; Set temp ; where years eq &&yr&i.; Run; %end; %Mend; %temp;

bnarang · ‎12-11-2012

Your sense of humour is great.

bnarang · ‎12-11-2012

Hi Cynthia Thank you so much for such detailed explanation. I am very thankful to you. Regards

bnarang · ‎12-09-2012

Hi All Is it possible to produce an Excel report from SAS with conditional formatting and be attached in email using sas?

bnarang · ‎12-09-2012

Hi Consider a Table: ID Var1 Var2 Var3 Var4 Var5 1 3 3 3 4 4 2 2 2 2 3 3 I would like to see, when is the first time value 3 has generated in var1 - var5 My Method to do it is following: Data Need; Set Have; Array check(*) Var1 - Var5 Do i = 1 to 5; if Check(i) = 3 then do; Flag = i; goto : en; output; end; en: Run; Goto statement helps me come out of the loop first time my condition satisties. It might not be a sophisticated way to write code but it works. Any suggestions how this can be improved or something alternative? Thanks

Online Status	Offline
Date Last Visited	‎09-15-2016 02:18 AM

Re: Retain and augment value basis criteria and event

Retain and augment value basis criteria and event

Re: Multiply rows base on values in field

Multiply rows base on values in field

Re: Creating a list of IPs from the range of IPS

Re: Creating a list of IPs from the range of IPS

Creating a list of IPs from the range of IPS

Re: Logic Help Required

Logic Help Required

Re: Estabilishing an Oracle DB connection in Base SAS

Re: %let using a database

Re: Create a macro variable for each unique value of a variable.

Re: How to replace the value..

Re: How to randomly select X no of obs randonly from a dataset?

Re: Replacing variables by their formatted values....?

Re: How can I import two parts from Excel file?

Re: Please help me with a conditional merge, I attached a file.

Re: %let using a database

Re: hi

Re: Understanding how to use index

Re: Streamline datepart for all dates

Re: Streamline datepart for all dates

Re: Splitting a database

Re: Please help me with a conditional merge, I attached a file.

Re: Can you help me in the SAS code?

Re: how to calculate the max length of an observarion and assign it th...

Re: how to calculate the max length of an observarion and assign it th...

Re: Splitting a database

Re: Splitting a database

Re: Datalines VS Cards.

Re: Excel Report ( Conditional formatted) as attachment in Email

Excel Report ( Conditional formatted) as attachment in Email

Recording an observation