About KarthikSrivasthav

KarthikSrivasthav · ‎01-07-2015

Hi all, I want to automate my process can any one help me to execute the VBA codes through SAS. Currently i am doing in three steps : 1) Executing SAS codes to get the data. 2) Exporting the datasets 3) Executing the VBA codes . I want to make it into one step.Please help me and i have one more doubt how a SAS in Unix system interacts with Windows(Excel) system. Thanks & Regards Karthik Srivasthav...

KarthikSrivasthav · ‎12-08-2014

Hi all, I have a large messy code but i want it in an ordered manner.Is there any short cut to get that.' ex: data x; set y; do i=1 to 10; j=i; end; run; i want the above code in the below manner data x; set y; do i=1 to 10; j=i; end; run; thanks & regards Karthik

KarthikSrivasthav · ‎12-05-2014

Hi , How to remove the difference from the variable2? Ex: var1="world cup" var2="Woorlld ccup" i want to make var2 as var1 thanks.... Regards Karthik.

KarthikSrivasthav · ‎01-14-2014

HI Apple, Try this ............... DATA want ; x=449; if substr(cats(x),1,2)='44' then want=1; run; Cheers, Karthik

KarthikSrivasthav · ‎01-14-2014

Hi robm, Year function will work to extract year from datetime/date variable: data want; format a datetime.; a=0; yr=year(a); run; I think u r variable might be in character format.Check once. Cheers, Karthik

KarthikSrivasthav · ‎12-23-2013

Hi All, I want to create a excel pivot with SAS by running VBA code . Regards Karthik

KarthikSrivasthav · ‎12-23-2013

Alternately u can use: Data want; set have; if x in ("a","b") then output; where y=1; run;

KarthikSrivasthav · ‎12-20-2013

Hi All, Pleas help me to export a data set into a pivot table. Thanks ... Regards Karthik

KarthikSrivasthav · ‎12-20-2013

Which word u want in the above example

KarthikSrivasthav · ‎03-15-2012

I want to know the options and the usage of a particular unix command being in sas environment So I am using this X 'man ls|/etl/have.txt'; But i am not getting the output in a readable Format So please help..

KarthikSrivasthav · ‎03-02-2012

Hi cynthia Sorry not proc report option i.e define option Ok But what u mentioned is we need to compute in previous dataset that is to be used in proc report but i am caluculating percentage according to zones If i use break after zone/summarize;the percent is is added up and giving more than 100%

KarthikSrivasthav · ‎03-02-2012

I want the descending order of values of a computed Column in proc report Please help Advance thanks

KarthikSrivasthav · ‎02-23-2012

Thanks Its working

KarthikSrivasthav · ‎02-22-2012

Hima i already tried that way i got the result But i need to send directly to a sas data set

KarthikSrivasthav · ‎02-22-2012

Bdf or df command will give details about data usage and the percent of data occupied in the server according to directory and file wise

Online Status	Offline
Date Last Visited	‎01-30-2025 11:20 AM

Executing VBA through SAS(Unix platform)

SAS code ordering

Re: Comparing two string variables and outputting the difference

Re: Prefix

Re: use of substr with date time data

Is it possible to run Excel VBA code using SAS

Re: Subset data based on Numeric & Character Variables

How to export dataset into a pivot table in specified sheet?

Re: how to extract perticular word.

x statement

Re: Subset data based on Numeric & Character Variables

Re: Prefix

Executing VBA through SAS(Unix platform)

SAS code ordering

Re: Comparing two string variables and outputting the difference

Re: Prefix

Re: use of substr with date time data

Is it possible to run Excel VBA code using SAS

Re: Subset data based on Numeric & Character Variables

How to export dataset into a pivot table in specified sheet?

Re: how to extract perticular word.

x statement

proc report order option

proc report order option

x statement output

x statement output

x statement output