About archana

archana · ‎11-05-2014

proc append base=db.acct (TPT=YES MULTISTMT=YES TPT_PACKMAXIMUM=YES keep=x y z) data=curr_acct; run; I am getting the below error- NOTE: Appending WORK.CURR_ACCT to db.acct. NOTE: BASE data set does not exist. DATA file is being copied to BASE file. NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables. WARNING: Engine TERADATA does not support SORTEDBY operations. SORTEDBY information cannot be copied.

archana · ‎09-02-2014

Thank you Tom. Another question. I am trying to pass the above value - yrqtr to an oracle query but not working. proc sql exec; CREATE TABLE test AS select * from connection to oracle ( select id,id1 from table where x = '&yrqtr.'); quit;

archana · ‎09-02-2014

even by removing %let it is throwing an error

archana · ‎09-02-2014

Hi I am trying the below and it is not working. I need to pass this variable yrqtr to oracle query. data _null_; %let yy = %sysfunc(intnx(month,%sysfunc(today()),-12),yymmdd2.); qtr=qtr(today()-30); yrqtr=compress('Q'||qtr||yy||'Partner details'); call symput('yrqtr',yrqtr); run; I am trying to make Q32013 Partner Details and pass it to Oracle query.

archana · ‎08-06-2014

Hi, I am currently manually creating a pivot table using an XLS file and sent it to users. I need to automate it and looking for suggestions. I am using PC SAS. Thanks,

archana · ‎05-27-2014

Does the above code work in Unix SAS?

archana · ‎05-27-2014

Hello Reeza, This is the code from the discussion you have attached. /* Tell SAS to open Excel */ options noxwait noxsync; data _null_; rc=system('start excel'); rc=sleep(10); run; /* Execute VBA code via SAS DDE - open file, select sheet with pivot, put cursor on pivot table and refresh pivot table */ filename cmds dde 'excel|system'; data _null_; file cmds; put "[open(""\\&path\&f_name..xlsx"")]"; put '[workbook.activate("Pivot")]'; put '[select("R1C1")]'; put '[pivot.refresh()]'; put "[save()]"; put "[quit()]"; run; quit; Could you please explain the above code or point me any link where i can get better explanation.

archana · ‎05-27-2014

My SAS program generates an excel with 1 year of data and i manually paste the data into a pivot table (excel) and send it to users. We need to automate it and looking if it can be done in SAS.

archana · ‎05-27-2014

My SAS program generates an excel with 1 year of data and i manually paste the data into a pivot table (excel) and send it to users. We need to automate it and looking if it can be done in SAS.

archana · ‎05-12-2014

I have a table which has the below contents email_addr date_enrolled x@gmail.com 05/10/2008 x@gmail.com 01/01/2014 x@gmail.com 05/05/2014 I need the latest record of 05/05/2014 by leaving the other records. Can i use first function ? Is there any easy way? Thanks,

archana · ‎05-07-2014

HI, I am trying to sort a large dataset with 367538640 rows . Sort is getting failed because of the space issue. Tried using options compress =yes and tagsort . Tagsort is taking very long time. Please suggest any alternatives. Thanks,

archana · ‎05-07-2014

HI, I am trying to sort a large dataset with 367538640 rows . Sort is getting failed because of the space issue. Tried using options compress =yes and tagsort . Tagsort is taking very long time. Please suggest any alternatives. Thanks,

archana · ‎05-02-2014

It is not working. i am getting the same error.

archana · ‎05-02-2014

Old query Data x ; set y; where Offer_St_dt >= '01OCT2011'd; run; I am trying to replace the above query with New Query %let year1 = %STR(%')%sysfunc(intnx(month,%sysfunc(today()),-12),date9.)%STR(%'); Data x ; set y; where Offer_St_dt >= &year1; run; I am getting error in the above case as ERROR: Syntax error while parsing WHERE clause. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, (, +, -, :, INPUT, NOT, PUT, ^, ~. ERROR 76-322: Syntax error, statement will be ignored.

archana · ‎04-24-2014

Yes. Thank you very much.

Online Status	Offline
Date Last Visited	‎10-03-2015 11:36 AM

Re: to convert a date from date9 format to sas number

Re: to convert a date from date9 format to sas number

to convert a date from date9 format to sas number

How to convert date format of 01SEP2015 to number format like 20340.

Re: Update existing and insert new record to sas dataset.

Re: Update existing and insert new record to sas dataset.

Update existing and insert new record to sas dataset.

Re: passing variable into oracle query

Re: Passing sas character variables into oracle query

Re: Passing sas character variables into oracle query

Re: to convert a date from date9 format to sas number

Re: to convert a date from date9 format to sas number

Re: Update existing and insert new record to sas dataset.

Re: Macro variables in SAS

Teradata load error

Re: Macro variables in SAS

Re: Macro variables in SAS

Macro variables in SAS

Pivot table in SAS

Re: Updating Extrenal Excel Pivot Table in SAS

Re: Automating Excel pivot table in SAS

Automating Excel pivot table in SAS

Automating pivot tables in SAS

pulling the latest record based on date

Issue in sorting a large dataset

Issue in sorting a large dataset

Re: Issue in resolving date variable in where clause

Issue in resolving date variable in where clause

Re: Comparing null and a character value