About PriyaL

PriyaL · ‎05-23-2017

Thanks for your solution. Is this a local macro variable? It is just that I need to use this in a title as follows: title3 "Date range &bcfstart to &bcfend"; And SAS does not seem to pick up these macros. Thanks.

PriyaL · ‎05-23-2017

Hi All, I am having an error when trying to run this code: %let bcfdate = today(); %let days = 8; data _null_; %let bcfstart=%sysfunc(intnx("day",%sysfunc(&bcfdate.),-&days.)); run; %put &bcfstart.; I believe that the today() function cannot be processed in the data _null_ statement and therefore "bcfstart" cannot be calculated Does anyone have any ideas on how to get around this issue? Cheers.

PriyaL · ‎03-24-2017

Thankyou - This worked very well.

PriyaL · ‎03-24-2017

Hi I would like to know if anyone can help me with a macro loop I am having trouble with I am trying to run the same macro for the weeks running Monday to Sunday for the past 2 years /*2015*/ %line(29dec2014,04jan2015);%line(05jan2015,11jan2015);%line(12jan2015,18jan2015);%line(19jan2015,25jan2015);%line(26feb2015,01mar2015);%line(02mar2015,08mar2015); %line(09mar2015,15mar2015);%line(16mar2015,22mar2015);%line(23mar2015,29mar2015);%line(30mar2015,05apr2015);%line(06apr2015,12apr2015);%line(13apr2015,19apr2015); I am repeating the same lines several times but I am sure I can write a weekly macro loop to give the start and end dates so something that looks like %macro new (Start, End); .....i=1 to 60 j=1 to 60 %line(&i.,&j.) %mend; Thanks Priya.

PriyaL · ‎10-12-2016

Hi, I am trying to Unzip some files in a location connected to UNIX. However there are several to Unzip and I thought it will be easier to code using a macro. But I am not sure how to alter the "x" command or use the following statement in the macro x "gunzip /sas/data/...." Would anyone have any ideas of how to implement this code in the macro. Thanks.

PriyaL · ‎09-15-2016

Hi, I would like to conduct a 1-sample T-test but instead of using the default mu0=0 in Proc univariate, can I change the default mu0 to 0.2 to test if my data points follow a normal distribution close to mu=0.2, to see how closesly distributed the data is? Thanks, Priya.

PriyaL · ‎09-15-2016

Hi Reeza, Would you know if it is possible to adjust the default mean (mu0) value from 0 to my own hypothetical mean as I want to test if my sample lie close to a hypothetical mean using the t-test. Thanks Priya.

PriyaL · ‎09-08-2016

Hi, When I was sitting for the Base practice exam I spent most of my time reading through forums for clues! I had a very similar experience to you, and I finally passed on my 4th attempt with 89%. Some of the questions are trick questions, and the best way to understand them is to find as many practice questions as possible. If your aim is to simply pass the exam (as I am sure you have excellent SAS skills anyway from working on the job) then I would recommend buying question papers on exam sites and studying those. I also think it is frustrating that they don't give a list of the answers you scored incorrectly!! I think that would be extremely beneficial. I wouldn't say I have plans to do an exam again, unless it is required as part of a job spec. Good luck for your next attempt! Hope this helps.

PriyaL · ‎04-15-2016

The first 3 characters will only display the month whereas I need the month and year.

PriyaL · ‎04-15-2016

Hi, I am trying to find a way to convert a date into a like for like character string to I can merge in data using the date as a variable. For example Reference Date date2 893746 31MAR2002:00:00:00.000 Mar-02 Where date2 is the datepart(date) formatted using monyy5. I would like to make a variable date3 that is a character replica of date2 as I don't want to deal with days in the merge. Does anyone know an easy way to do this? Thanks.

PriyaL · ‎11-26-2015

HI @FreelanceReinh I think you are right as a proc summary is the easiest way as my data is already in the columns by month. So i would just need to sum through the columns I want to make a final dataset with 2 rows which contains the sum total of all account balances for all acounts in that month. Is there a way to filter on proc summary just to keep the variables with the prefix 'account_balance' as my datasets contains several other variables because it is a master dataset. Thanks.

PriyaL · ‎11-25-2015

Here is an idea of the data Account_Number account_balance201404 account_balance201405 account_balance201406 account_balance201407 account_balance201408 account_balance201409 134897578 70077.71 69721.07 69363.77 69005.82 68647.21 68287.94 198994889 200682.6 200682.5 200682.4 200682.3 200682.19 200682.09 388499933 126449.9 125801.3 125151.6 124500.6 123848.46 123195.11 384902999 106735.5 106735.5 106735.5 106735.5 106735.49 106735.49 238499399 35464.27 35465.45 35466.64 35467.83 35469.02 35470.21 . . . . . . . . . . . . . . . . . . . . . There are several rows, and i am just looking to make 1 table with 2 rows so the first row is the Overall sums per month and the second row is the final sum. So for example: Jan-07 Feb-07 Mar-07 Apr-07 May-07 Jun-07 Jul-07 389488577 389497072 3.9E+08 3.9E+08 3.9E+08 389531052 389539547

PriyaL · ‎11-25-2015

The colomn headers simply depict the data that is in the month, so for coloumn "balance_201305" that will be a coloumn of all customer balances in May 2013. So I guess you are suggesting I change the layout of the inital data and sum through the row and create a Sum Total field at the end. Can this be achieved with the Proc Transpose function in SAS? Thanks

PriyaL · ‎11-25-2015

Hi, Would anyone know how to loop through dates in an array with formats such as 201501 for January 2015. I am trying to loop through 6 years and get a total balance for all accounts for each year, please see the following code. %let from=200701; %let to=201508; data newdata (keep= _:); set olddata end=Lastobs; array month{*} balance_&from.-balance_&to.; array out{*} _&from.-_&to.; do i=1 to 104; out{i}+sum(of month{i}); end; if Lastobs; run;

Online Status	Offline
Date Last Visited	‎05-23-2017 11:09 AM

Re: Using the today() function in a data null step.

Using the today() function in a data null step.

Re: SAS Date loop Monday to Sunday

SAS Date loop Monday to Sunday

Connecting to UNIX in a macro with "x" command

Proc Univariate Hypothetical mean for Students T

Re: Student's T in proc univariate

Re: Failed Certification Exam 2xs

Re: Convert date to character string

Convert date to character string

Re: Using the today() function in a data null step.

Re: Failed Certification Exam 2xs

Re: Using the today() function in a data null step.

Using the today() function in a data null step.

Re: SAS Date loop Monday to Sunday

SAS Date loop Monday to Sunday

Connecting to UNIX in a macro with "x" command

Proc Univariate Hypothetical mean for Students T

Re: Student's T in proc univariate

Re: Failed Certification Exam 2xs

Re: Convert date to character string

Convert date to character string

Re: Array looping through dates in YYMMN6. format

Re: Array looping through dates in YYMMN6. format

Re: Array looping through dates in YYMMN6. format

Array looping through dates in YYMMN6. format