About JoshuaHarris

JoshuaHarris · ‎05-17-2022

I checked the below page created by Chris and couldn't find any ways that we could execute SAS egp files using cmd prompt. Also tried the powershell one, but couldn't change the execution policies as we using office system and it cannot be modified. https://communities.sas.com/t5/SAS-Communities-Library/Doing-More-with-SAS-Enterprise-Guide-Automation/ta-p/417832 Will wait for Chris to respond with some solution or workaround

JoshuaHarris · ‎05-17-2022

Thank you for your quick reply. Can you please let me know if we can do the same for .egp files

JoshuaHarris · ‎05-17-2022

Can we run SAS in cmd prompt by passing a .sas file without opening the SAS tool? Similar to how python code runs in the background if we pass python tst.py in cmd prompt

JoshuaHarris · ‎02-03-2022

Thanks a lot for your speedy response and help

JoshuaHarris · ‎01-26-2022

Yes all combinations of values(positive and negative) that equal to 0 but once we identified a set of numbers thats sum is 0,that number/row item shouldn't be used again

JoshuaHarris · ‎01-26-2022

Sure. Please find below the sample data Amount_column -56 76 10 -76 56 20 -45 -3 15 -35 40 4 4 First output should hv Amount_col -56 56 76 -76 Second output should have Flag amount_col A 10 A 20 A 15 A - 45 B 40 B 4 B 4 B - 45 B - 3 if you sum all A, then it will b 0 and if you sum all B, it will be 0..(offset) Or even one output will be better Flag amount_col Zero 56 Zero -56 Zero - 76 Zero 76 A 10 A 20 A 15 A - 45 B 40 B 4 B 4 B - 45 B - 3

JoshuaHarris · ‎01-26-2022

I have an "amount" column in a dataset which has several positive and negative values. I want to create one output which has same positive and negative numbers(eg: - 56,56,-72,72) and another output(excludes the data in first output) which has total values of any combination of positive and negative numbers equals to 0. (eg:, -5,-10,15), (-90,10,-5,85).. Is it possible to do this in SAS.. Please suggest..

JoshuaHarris · ‎03-22-2019

@Ksharp awesome job.. Thanks.. It works cool 🙂

JoshuaHarris · ‎03-22-2019

Awesome!!! Thanks @PGStats Works like a charm.. Still am learning your code 🙂

JoshuaHarris · ‎03-21-2019

Thanks Tom! But i don't have the SAS/OR. Hence this proc optnet is not available for me. Would like to do this with other logics

JoshuaHarris · ‎03-21-2019

My expected result is 1 2 3 6 1 2 5 2 3 6 2 5 3 6 4 8 9 . 8 9 4 9 4

JoshuaHarris · ‎03-21-2019

I have a dataset which contains pid, cid. I want to get the list of all the possible paths of each pid. Example data as below Pid cid 1 2 2 3 2 5 3 6 4 8 8 9 9 4 My expected result is 1 2 3 6 1 2 5 2 3 6 2 5 3 6 4 8 9 . 8 9 9 4 If the path is about to loop then i want to blank out the value and stop it to avoid any infinite loopings.

JoshuaHarris · ‎09-07-2018

Thanks. I will try the http proc and will update the post

JoshuaHarris · ‎09-07-2018

I saved it as unicode text and read the file again with utf-16. Found a workaround for this temporarily. Only few number of rows contains this special encoding data. So filtered out using excel filter option on that column and copied it to notepad and replace all there with space and copy back to excel solves my problem

JoshuaHarris · ‎09-07-2018

Am importing an excel which contains some Latin characters as well. As it's not read properly, i googled and learnt that we can save the excel as unicode text file and then use proc import with encoding of utf-16. Now am able to read it. But the dataset contains some extra symbols came along with latin characters. Example Â became Â-> or Âf like this. How to read this properly and also how to process using string functions like cats and then report it back to excel properly with no extra symbols or letters. Note: am using SAS for windows(9.3) Thanks

Re: How to run SAS in cmd without opening the actual SAS tool

Re: How to run SAS in cmd without opening the actual SAS tool

How to run SAS in cmd without opening the actual SAS tool

Re: Find sum of multiple positive and negative values

Re: Find sum of multiple positive and negative values

Re: Find sum of multiple positive and negative values

Find sum of multiple positive and negative values

Re: Trace all the paths from source id

Re: Trace all the paths from source id

Re: Trace all the paths from source id

Re: Find sum of multiple positive and negative values

Re: Trace all the paths from source id

Trace all the paths from source id

Re: How to run SAS in cmd without opening the actual SAS tool

Re: How to run SAS in cmd without opening the actual SAS tool

How to run SAS in cmd without opening the actual SAS tool

Re: Find sum of multiple positive and negative values

Re: Find sum of multiple positive and negative values

Re: Find sum of multiple positive and negative values

Find sum of multiple positive and negative values

Re: Trace all the paths from source id

Re: Trace all the paths from source id

Re: Trace all the paths from source id

Re: Trace all the paths from source id

Trace all the paths from source id

Re: Access Sharepoint using SAS

Re: Trouble in importing data having some special characters

Trouble in importing data having some special characters