About AshokD

AshokD · ‎11-27-2018

Hi , Below code is working fine when we have two spaces before Score column values. data example1; input ID Name & $30. Score; cards; 1 Deepanshu Bhalla 22 2 Atta Pat 21 3 Xonxiangnam Samnuelnarayan 33 ; When we have single space before score column value , it's not working properly. data example1; input ID Name & $30. Score; cards; 1 Deepanshu Bhalla 22 2 Atta Pat 21 3 Xonxiangnam Samnuelnarayan 33 ; Any suggestion to resolve this ?

AshokD · ‎10-25-2018

@PeterClemmensen @RW9 Thanks for your time and suggestion. It work's fine.

AshokD · ‎10-25-2018

Hi All, In data step we have STRIP function which removes leading and trailing spaces. Do we have any similar function in Proc SQL ? Please share your thoughts.

AshokD · ‎10-12-2018

Hi All, Does anyone know how to read encrypted Excel documents into SAS, without the need to decrypt and save prior? Thanks in advance for your help

AshokD · ‎10-11-2018

Thanks for your help and time.

AshokD · ‎10-11-2018

@PeterClemmensen yes , Amount is a numeric variable

AshokD · ‎10-11-2018

@RW9 Hi, I'm not trying number into pounds format. I need to convert pounds into words. Example :- Input Output £33.17 – Thirty three pounds and seventeen cents. £22.17 - Twenty two pounds and seventeen cents.

AshokD · ‎10-11-2018

Hi All, I'm working on a requirement amount field to text conversion. My input field Transaction_Amount contains the value £33.17. I have to output the above value to Thirty three pounds and seventeen cents. Note - Output should be printed to text with the corresponding any input amount value. Could you please someone suggest any format or any other technique to accomplish this ? Thanks in advance for the help.

AshokD · ‎09-02-2018

@Tom It works, Thanks for the help.

AshokD · ‎09-02-2018

data have; length Country $30.; input EmpID Trnsct Country $; cards; 123 200 US 456 300 India 678 500 China 980 300 Japan 700 600 Singapore 800 240 US ; run; %macro a; option mprint mlogic symbolgen; proc sql; select distinct country into :country1 - :country99 from have; quit; %put &country1 &country2 &country3 &country4 &country5 &sqlobs; %do i =1 %to &sqlobs; DATA out_'&country..&sqlobs..'; set have(where=(country='&country.&sqlobs.')); run; %end; %mend a; %a; I'm facing issue in resolving the macro to split the dataset. Can someone help

AshokD · ‎09-02-2018

@Ksharp@novinosrin@novinosrin Thanks for your inputs.

AshokD · ‎09-01-2018

Hi All, I need some of your help on the below scenario:- #1) I have data like below and need to create multiple dataset using macro based on the country, so need to create 5 different datasets Can someone provide a good approach for this ? EmpID Amount Country 123 $200 US 456 $300 India 678 $500 China 980 $300 Japan 700 $600 Singapore #2) I have a data like below and need to pull the highlighted rows since age is different in the 3rd transaction when compared to 1st and 2nd transaction. I tried self join ,it's working fine but do we have anyother way in datastep ? EmpID TrnsctID Age 123 900 30 123 500 30 567 400 28 987 300 27 123 200 28

AshokD · ‎08-30-2018

@ChrisNZ@ballardw Thanks for the input. I thought , we can override the value as per our need. Let me try some other way. Thanks.

AshokD · ‎08-30-2018

Hi All, I'm testing my SAS code on different run dates by using date override and it's working fine. But I see SYSDAY Automatic Variable resolves to current day. Any possibility to override this automatic variable ? Example - I'm running the job using date override as of 2018-09-03 , so SYSDAY should resolve to Monday. Thanks in advance for the help.

AshokD · ‎08-28-2018

Hi @PeterClemmensen, Here are the details:- Dataset A:- EmployeeID Transactiontype 123456 Transact1 345678 Transact2 678903 Transact3 Dataset B:- EmployeeID TransactionType Service 123456 Transact1 A1 345678 Transact2 A2 678903 Transact3 A1 I have to compare A and B datasets to determine the Service for each transactions for the employeeIDs. Once we determined the service ,I have to output the data to different fles:- If service is A1 then output to File1 If service is A2 then output to File2 The Logic I have tried it:- data FILE1 FILE2; if _N_ = 1 then do; declare hash h(dataset: "B") h.defineKey('EmployeeID'); h.defineData('TransactionType','Service '); h.defineDone(); end; set A; rc = h.find(); if (rc = 0) then do; if Service ='A1' then output FILE1; else if Service ='A2' then output FILE2; end; run; Please have a look , provide your suggestion

Online Status	Offline
Date Last Visited	‎05-06-2024 12:12 PM

Re: Counts Number of Active Customers

Re: Counts Number of Active Customers

Counts Number of Active Customers

Amount Movement

Re: Historical data

Re: Historical data

Re: Historical data

Re: Historical data

Re: Historical data

Historical data

Re: To remove laeding and trailing spaces in Proc SQL ?

Re: Amount to text conversion

To remove laeding and trailing spaces in Proc SQL ?

Datalines clarification

Re: To remove laeding and trailing spaces in Proc SQL ?

To remove laeding and trailing spaces in Proc SQL ?

To read encrypted Excel documents into SAS ?

Re: Amount to text conversion

Re: Amount to text conversion

Re: Amount to text conversion

Amount to text conversion

Re: Macro - To create multiple dataset

Re: Macro - To create multiple dataset

Re: Macro - To create multiple dataset

Macro - To create multiple dataset

Re: SYSDAY Automatic Variable

SYSDAY Automatic Variable

Re: Hash Logic Example