About MM88

MM88 · ‎09-12-2023

Thanks @Tom, your solution also works. Regards.

MM88 · ‎09-11-2023

Hi community, Is there a way to keep one empty line if there are multiple contiguous lines? I want to maintain the same row order. I tried distinct, but only one empty line is returned and the original row order is lost. proc sql; CREATE TABLE HAVE (var1 char(10), var2 char(10)); INSERT INTO HAVE VALUES('A', 'B') VALUES('', '') VALUES('', '') VALUES('', '') VALUES('C', 'D') VALUES('', '') VALUES('', '') VALUES('E', 'F') VALUES('', '') VALUES('', '') VALUES('', '') VALUES('', '') VALUES('G', 'H') ; QUIT; proc sql; CREATE TABLE WANT (var1 char(10), var2 char(10)); INSERT INTO WANT VALUES('A', 'B') VALUES('', '') VALUES('C', 'D') VALUES('', '') VALUES('E', 'F') VALUES('', '') VALUES('G', 'H'); QUIT; Thanks

MM88 · ‎08-08-2023

Thanks @Tom . It works good. I appreciate your help.

MM88 · ‎08-08-2023

Hi community, I am new to SAS, I would like to obtain a SAS dataset that completes intermediate lines. I have a dataset like: data original_data; input var1 $ var2; datalines; A 12 B 15 C 20 D 23 ; run; I would like to obtain another dataset with the intermediate lines like: data original_data; input var1 $ var2; datalines; A 12 A 13 A 14 B 15 B 16 B 17 B 18 B 19 C 20 C 21 C 22 D 23 ; run; Thanks for your help.

MM88 · ‎07-27-2023

Thanks @Tom, it works your solution. Only in my system expects parenthesis in: do while (not(eof)); Regards

MM88 · ‎07-26-2023

Hi community, I would like to call a python program for each row of my dataset. My dataset has 4 variables, that I need to pass as parameters to the python call. data _null_; set mydataset; command = 'python C:\temp\mypython.py ' || " " || quote(strip(var1)) || " " || quote(var2) || " " || quote(var3) || " " || quote(var4); X command; run; But no python call is executed. Any suggestions of what could be the problem? Thanks

MM88 · ‎07-10-2023

Hi community, I have SAS Visual Analytics 7.5. Is it possible to create a bar chart that shows count and percentage values? Sample image. I can use two or more measure in a bar chart, but it create two parallel graphics. Thanks.

MM88 · ‎06-29-2023

Hi community, Perhaps there is a better solution. I made it work creating a 'dummy' integer variable containing only missing in the data source. Applying any function (Min [_ByGroup_], Max [_ByGroup_]) to this variable in SAs Visual Analytics you can obtain the missing value. Any other ideas, please share. Regards.

MM88 · ‎06-28-2023

Hi experts, Thanks for the suggestions. I made it work using @Tom first suggestion calling the macro parameter between quotes. DATA _NULL_; SET HAVE END=eof ; call execute(cats('%nrstr(%MyMacro)(',quote(trim(list_coordinates),"'"),')')); RUN; Then I 'dequote' the parameter inside my macro and use the new one. %macro MyMacro(list_coordinates); %let new_coordinates_list = %sysfunc(dequote(&list_coordinates)); /*Call my webservice using new_coordinates_list*/ %mend MyMacro; Thanks for your time.

MM88 · ‎06-28-2023

Hi @Kurt_Bremser, Semicolon is not my delimiter choice. Inside the macro I call a webservice that receive the coordinates list separated by semicolons. Any advice?

MM88 · ‎06-28-2023

Hi experts, I am struggling to make a macro call that includes semicolons inside the parameter. DATA _NULL_; SET WORK.HAVE END=eof ; call execute('%MyMacro('||list_coordinates||')'); RUN; My 'list_coordinates' parameter is something like 51.95179749,7.99066114;51.17936325,6.74318409;51.33995819,4.31496429. I am getting the following error each time that found a semicolon: Statement is not valid or it is used out of proper order Thanks

MM88 · ‎06-27-2023

@Madelyn_SAS, coould you please give an example? SAS VA gives error because MISSING function return bool, instead of numeric.

MM88 · ‎06-27-2023

Hi experts, Is it possible to return missing value in an aggregated measure in SAS Visual Analytics? Example: IF ( Max [_ByGroup_] (TreatAs(_Number_, 'Date1'n[Raw])) <= Max [_ByGroup_] (TreatAs(_Number_, 'Date2'n[Raw])) ) RETURN ( Sum [_ByGroup_] ('myvar1'n) / Sum [_ByGroup_] ('myvar2'n) ) ELSE . SAS gives an error saying that there is an element that cannot be aggregated (the missing .) I don't like to return 0. Are there any options to return missing? Thanks

MM88 · ‎06-20-2023

@ballardw , perphaps Zip Copes were created for US, but in Europe there is a similar concept of 'postal code'. Anyway, is it possible to find distance between two cities, instead of zip codes? I assume we should provide country too. Thanks in advance.

MM88 · ‎06-19-2023

Good morning, I would like to obtain the distance between two zip codes using SAS and Google Maps. I found this link in the community https://communities.sas.com/t5/SAS-Communities-Library/Driving-Distances-and-Drive-Times-using-SAS-and-Google-Maps/ta-p/475839 , however is not working for me. I believe url response is not in the same format that code expects. ¿Can someone please advice me how to fix the query? I have some other questions: 1- Postal Code are not unique, how we can be sure we are querying the correct cities? For example postal code 27513 belongs to Chantada, Lugo, Spain, but also to Cary, NC, US. 2- Is possible to query for different transports: driving, plane, interrail? * enter two zip codes; %let z1=28001; %let z2=27513; * no changes required below this line; filename x url "https://www.google.com/maps/dir/&z1/&z2/?force=lite"; filename z temp; data _null_; infile x recfm=f lrecl=1 end=eof; file z recfm=f lrecl=1; input @1 x $char1.; put @1 x $char1.; if eof; call symputx('filesize',_n_); run; data _null_; infile z recfm=f lrecl=&filesize. eof=done; input @ 'miles' +(-15) @ '"' distance :comma12. text $30.; units = scan(text,1,'"'); time = scan(text,3,'"'); file print; put "DRIVING DISTANCE BETWEEN &z1 AND &z2 : " distance comma6. +1 units" (TIME: " time ")"; stop; done: file print; put "CANNOT FIND THE DISTANCE OR TIME BETWEEN &z1 AND &z2, TRY ANOTHER COMBINATION"; run; filename x clear; filename z clear; Thanks for your help. Best regards

Online Status	Offline
Date Last Visited	‎09-22-2023 01:49 PM

Re: Keep one empty line

Keep one empty line

Re: Fill rows with sequential data

Fill rows with sequential data

Re: Call python with parameters for each row of SAS dataset

Call python with parameters for each row of SAS dataset

Bar chart with count and percentage values.

Re: Return missing in aggregated measure in SAS Visual Analytics

Re: Error macro execution when parameter contains semicolon

Re: Error macro execution when parameter contains semicolon

Re: Error macro execution when parameter contains semicolon

Re: Keep one empty line

Keep one empty line

Re: Fill rows with sequential data

Fill rows with sequential data

Re: Call python with parameters for each row of SAS dataset

Call python with parameters for each row of SAS dataset

Bar chart with count and percentage values.

Re: Return missing in aggregated measure in SAS Visual Analytics

Re: Error macro execution when parameter contains semicolon

Re: Error macro execution when parameter contains semicolon

Error macro execution when parameter contains semicolon

Re: Return missing in aggregated measure in SAS Visual Analytics

Return missing in aggregated measure in SAS Visual Analytics

Re: Distance between zip codes in SAS

Distance between zip codes in SAS