About UdayGuntupalli

Ksharp · ‎12-07-2018

ods select none; ods output nlevels=want; proc freq data=have nlevels; table _all_; run; ods select all; proc sql noprint; select TableVar into : missing_variables separated by ' ' from want where NNonMissLevels=0; quit; %put Missing variables are: &missing_variables ;

RW9 · ‎11-15-2018

Its very rarely, if ever, a good idea to put quotes in macro variables. Just look at the trouble to do something simple like put a double quote in, its really more effort than its worth. Macro should note replace datastep, base SAS is the programming language, use that and you will not have all this messy code.

Cynthia_sas · ‎10-15-2018

Hi: That's not enough of the log to tell anything. I'd recommend working with Tech Support. How you created, registered and run the stored process makes a difference. For example, what was your client application? Did you use the Stored Process Web App? The message about no logical assign for filename _WEBOUT usually means that you registered the stored process incorrectly and did not indicate that it would produce streaming results, as described here: http://support.sas.com/kb/34/120.html That's why I recommend working with Tech Support. Posting 2 lines of Log isn't going to give anyone the true picture of how you defined and ran the stored process. Cynthia

ChrisBrooks · ‎10-08-2018

The htmlencode function is a data step function. If you want this to work in open (or macro) code you need to wrap it inside a %sysfunc call e.g. %Global x1 x2; %let x1 = 'not a <tag>'; %Put &x1; %let x2 = %sysfunc(htmldecode(&x1)); %put &x2; You can find more details on how to use %sysfunc here -> http://support.sas.com/documentation/cdl/en/mcrolref/62978/HTML/default/viewer.htm#p1o13d7wb2zfcnn19s5ssl2zdxvi.htm

novinosrin · ‎09-18-2018

If you are familiar with hashes. There is away using Hashes as it accepts literal expressions. Looping num and char arrays and feeding into hash obj at run time hash.definekey(' ') in a loop. Hash guru PD aka Paul Dorfman who is very busy now and will be here in a couple of weeks or less has demonstrated alike in many of his papers. You could output the hash renamed contents to a dataset. I am not recommending, however it's nice to bring some awareness while I got lucky to receive privileges from PD on a personal level

Reeza · ‎09-13-2018

Minify is the term, you’re looking for I believe. Pretty - means legible, minified is to remove spaces, line breaks etc. The data in the file is the same but makes it smaller in size. The parsing shouldn’t be different so this would really only matter for big files.

BrunoMueller · ‎09-05-2018

Have you already defined the Stored Process with Input/Output data source definitions and looked at the WSDL coming back from the webservice, this should reflect how to provide the data. Here is sample code on how to access the XML data passed in: libname ws_ixml xmlv2; proc copy in=ws_ixml out=work; run; proc contents data=work._all_ ; run; proc print data=work.t1; run; The definition of the WS_IXML looks like this: The Web Service request looks like this: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:biw="http://www.sas.com/xml/namespace/biwebservices"> <soapenv:Header/> <soapenv:Body> <biw:ws_input_data> <biw:streams> <biw:ws_ixml contentType="?"> <biw:Value>  <root> <t1> <c1>r1c1</c1> <c2>r1c2</c2> <c3>123</c3> <c4>2018-09-05</c4> </t1> <t1> <c1>r2c1</c1> <c2>r2c2</c2> <c3>456</c3> <c4>2018-09-05</c4> </t1> </root> </biw:Value> </biw:ws_ixml> </biw:streams> </biw:ws_input_data> </soapenv:Body> </soapenv:Envelope> The request xml was taken from SoapUI. So the XML between the <biw:Value></biw:Value> tags can be read using the XMLV2 libname engine. The XML data passed in to the WS_IXML libref can be read without using a XML Map file. <root> is the root tag, <t1> is the table name, each repeating <t1> ... </t1> is treated as an observation. The <c4> column is an example how to pass in a date. You can get the WSDL of a Stored process called as a SAS Webservice like this: http://host:port/SASBIWS/services/<metadata folder name>/<stored process name>?WSDL Hope this helps

UdayGuntupalli · ‎08-22-2018

BUMPING

ballardw · ‎08-22-2018

@SASPhile wrote: I'm not looking if a variable exists. I'm looking for a variable that contains TEST as part of variablename and if it has at least one missing values. HOW many variables are you concerned with in each data set? What does the output potentially look like with 10 variables? And are you really sure that you want every variable that may have 'TEST' as part of the name? What if you have a variable named "testimony" "intestate" Do you want each time a variable is missing or if any records in the set are missing values at least once?

Reeza · ‎08-22-2018

I think you'll need a SQL join. You say concatenate but based on my knowledge of XML it looks like it was parsed to multiple tables and you want to combine them again. We can't tell you how to join it without more information on the data, specifically the logic to link it. If I'm incorrect, one of the other users solution will work for you. @UdayGuntupalli wrote: All, If I have 2 SAS datasets that are stored as XML files, how can I concatenate them ? libname XMLData xmlv2 '/data/Test.xml'; data Work.TestACMod; set Work.TestAC; format ReadTime datetime.; run; data XMLData.TestAC; Set Work.TestACMod; run; libname XMLData1 xmlv2 '/data/Test1.xml'; data Work.TestSiteDet; set Work.Sit; format CoDate datetime.; run; data XMLData1.TestSiteDet; set Work.TestSiteDet; run;

Ksharp · ‎08-21-2018

proc sql; select coalesce(visit_date,expected_visit_date) as new_visit_date from have; quit;

Carmine_Rossi · ‎08-06-2018

Thank you very much! The MDY function is what I was looking for! -Carmine

UdayGuntupalli · ‎08-06-2018

@manya92, Since I can't see the data, it is hard for me to troubleshoot. Is it possible your application of distinct during the join causing it ? Could you kindly remove the distinct during the join operation and try to filter for distinct values in a separate step ?

Reeza · ‎07-30-2018

Because it’s date time variable, your interval should be DTYEAR.

Online Status	Offline
Date Last Visited	‎05-21-2019 05:30 PM

Re: Test if a macro variable has missing value

Test if a macro variable has missing value

Re: Solver in SAS - select rows that sum to a given value (with more t...

Re: Solver in SAS - select rows that sum to a given value (with more t...

Re: Conditionally Merging 2 Datasets

Converting Month From Number to Name

Re: Extract substribg

Re: How to stop a SAS Program from running

Re: How to stop a SAS Program from running

How to stop a SAS Program from running

Re: Optimize Learning at SAS GF

Re: Test if a macro variable has missing value

Re: Converting Month From Number to Name

Re: Optimize Learning at SAS GF

Re: Optimize Learning at SAS GF

Re: Error Handling in a construct like try/catch

Optimize Learning at SAS GF

Re: How to output XML without Pretty format ?

Re: How to read a table from XML Input call in SOAP ?

Re: How to expand a SAS dataset

Re: How to loop through columns of dataset and test for missing values

Re: How to add double quotes to string in open code

Re: How to have a SAS Stored Process return a csv

Re: htmldecode function in open code

Re: How to rename all the column names of a dataset

Re: How to output XML without Pretty format ?

Re: How to read a table from XML Input call in SOAP ?

Re: Sample SOAP API To Test

Re: Check for Column and missing

Re: Concatenate XML files

Re: replacing missing date values in a column with new date

Re: SAS Year Variable to a general date (ex: 20180101)

Re: left join

Re: How to change year of datetime ?

SAS Global Forum 2019

SAS Global Forum 2018