About Satish_Parida

Satish_Parida · ‎08-02-2019

Thank you. Expression: /^VIST\[*[0-9|A-Z]\]\/*[0-9|A-Z]V\[*[0-9|A-Z]\]$/ works for all the scenarios I have. Could you please help me with the expression, which will work for the following. VIST[1A]/SSV[10A]

Satish_Parida · ‎08-02-2019

Thank you, but x1 and x2 give correct output, that's why I am confused what is wrong with x?

Satish_Parida · ‎08-02-2019

Hi Experts, some of the praxmatch are not working for some regular expressions. Could you please tell me whats wrong with the regular expressions where it is not working. data test; input StudyEventKey:$40.; x = prxmatch(prxparse('/^VIST\[*\]*V*\[*\]/') ,StudyEventKey); /*Does not work*/ x1 = prxmatch(prxparse('/^VIST\[*\]*V*\[1\]/') ,StudyEventKey); x2 = prxmatch(prxparse('/^VIST\[*\]*V*\[2\]/') ,StudyEventKey); y = prxmatch(prxparse('/^VIST\[*\]*V*/') ,StudyEventKey); z = prxmatch(prxparse('/^VIST\[*\]\/*V*\[*\]/') ,StudyEventKey); /*Does not work*/ cards; VIST[1]/FV[1] VIST[1]/SV[1] VIST[1]/TV[1] VIST[2]/FV[1] VIST[2]/SV[1] VIST[2]/TV[1] ; run;

Satish_Parida · ‎06-19-2019

data have; input byvar a b c; cards; 1 100 200 300 2 400 500 600 ; run; proc sort data=have; by byvar; run; proc transpose data=have out=want(keep=byvar _name_ Value1 rename=(_name_=var_name Value1=Value)) prefix=Value; by byvar; var a b c; run; Can we have the datatype of column "Value" in "want" table set to character datatype during transpose? If we have a mixed datatype in the input "have" table it is working fine.

Satish_Parida · ‎03-30-2019

/* Please let us know if it worked for you.*/ data std_data; infile cards dlm='|' dsd missover; input Id:best12. Test_date:ddmmyy10. Test_id:$4. Test_component:$20. Test_score:best12.; format Test_date:ddmmyy10.; cards; 1|20-09-2011|XYZ|English|2.5 1|20-09-2011|XYZ|Math|4 1|20-09-2011|XYZ|Science|6 2|30-05-2015|XYZ|English|4.5 2|30-05-2015|XYZ|Math|7 2|30-05-2015|XYZ|Science|4 3|18-12-2013|XYZ|English|4.5 3|18-12-2013|XYZ|Math|4 3|18-12-2013|XYZ|Science|8 4|12-12-2012|XYZ|English|4.5 4|12-12-2012|XYZ|Math|4.5 4|12-12-2012|XYZ|Science|8 ; run; proc transpose data=std_data out=std_data_trans; by id Test_date Test_id; var Test_score; id Test_component; run; data condn; infile cards dlm='|' dsd missover; input Score_letter:$3. English:$5. Math:$5. Science:$5. ; cards; DIP|<4|<4|<7 DEG|4|4|7 MAS|4.5|4.5|8 ; run; data want; set std_data_trans; if English lt 4 and Math lt 4 and Science lt 7 then Score_letter='DIP'; else if English le 4.5 and Math le 4.5 and Science lt 8 then Score_letter='DEG'; else if English ge 4.5 and Math ge 4.5 and Science ge 8 then Score_letter='MAS'; run; proc transpose data=want out=want_trans; by id Test_date Test_id; var English Math Science Score_letter; run; data want_trans(drop=Test_Score rename=(_name_=Test_component Test_Score1=Test_Score)); set want_trans; if _name_='Score_letter' then do; Test_id=''; Test_component='Recommendation'; Score_letter=Test_Score; Test_Score=''; end; Test_Score1=input(Test_Score,best12.); run;

Satish_Parida · ‎03-30-2019

Please provide all the input datastes to the program. And the program is syntactically incorrect in so many places.

Satish_Parida · ‎03-30-2019

data have; infile cards dlm='|'; input ID:$1. Group $ Date:date9. year_month:monyy6.; format date date9. year_month monyy6.; cards; 1|BETA BLOCKERS|27-Feb-12|Feb-12 1|ANTIDEPRESSANTS|27-Feb-12|Feb-12 1|ANTIHYPERTENSIVES|27-Feb-12|Feb-12 1|Calcium Channel Blockers|27-Feb-12|Feb-12 1|DIURETICS|12-Mar-12|Mar-12 1|Calcium Channel Blockers|29-Mar-12|Mar-12 1|ANTIDIABETICS|29-Mar-12|Mar-12 1|VITAMINS|29-Mar-12|Mar-12 1|ANTIHYPERTENSIVES|29-Mar-12|Mar-12 1|BETA BLOCKERS|29-Mar-12|Mar-12 1|ANTIDEPRESSANTS|29-Mar-12|Mar-12 1|Anti-infective Agents - Misc.|21-Apr-12|Apr-12 1|ANTIDIABETICS|26-Apr-12|Apr-12 1|DIAGNOSTIC PRODUCTS|26-Apr-12|Apr-12 1|MUSCULOSKELETAL THERAPY AGENTS|14-May-12|May-12 1|DIURETICS|14-May-12|May-12 1|Antifungals|17-May-12|May-12 1|MUSCULOSKELETAL THERAPY AGENTS|18-Jun-12|Jun-12 1|Calcium Channel Blockers|23-Jun-12|Jun-12 1|ANTIHYPERTENSIVES|23-Jun-12|Jun-12 1|ANTIDEPRESSANTS|23-Jun-12|Jun-12 1|BETA BLOCKERS|23-Jun-12|Jun-12 1|DIURETICS|23-Jun-12|Jun-12 1|DIAGNOSTIC PRODUCTS|23-Jun-12|Jun-12 1|MEDICAL DEVICES AND SUPPLIES|27-Jul-12|Jul-12 1|DIAGNOSTIC PRODUCTS|27-Jul-12|Jul-12 2|ANTIHYPERTENSIVES|10-Jan-12|Jan-12 2|ANTICONVULSANTS|10-Jan-12|Jan-12 2|ESTROGENS|10-Jan-12|Jan-12 2|ANTIDEPRESSANTS|10-Jan-12|Jan-12 2|ANTIHYPERLIPIDEMICS|10-Jan-12|Jan-12 2|ULCER DRUGS|10-Jan-12|Jan-12 2|HYPNOTICS/SEDATIVES/SLEEP DISORDER AGENTS|10-Jan-12|Jan-12 2|DIURETICS|10-Jan-12|Jan-12 2|ANALGESICS - OPIOID|11-Jan-12|Jan-12 2|CEPHALOSPORINS|11-Jan-12|Jan-12 2|ANALGESICS - OPIOID|11-Jan-12|Jan-12 2|ULCER DRUGS|9-Feb-12|Feb-12 2|ANTIDEPRESSANTS|9-Feb-12|Feb-12 2|ESTROGENS|9-Feb-12|Feb-12 2|ANTIHYPERTENSIVES|9-Feb-12|Feb-12 2|ANTICONVULSANTS|9-Feb-12|Feb-12 2|ANTIHYPERLIPIDEMICS|9-Feb-12|Feb-12 2|HYPNOTICS/SEDATIVES/SLEEP DISORDER AGENTS|10-Feb-12|Feb-12 2|DIURETICS|10-Feb-12|Feb-12 2|ESTROGENS|12-Mar-12|Mar-12 2|ANTICONVULSANTS|12-Mar-12|Mar-12 2|HYPNOTICS/SEDATIVES/SLEEP DISORDER AGENTS|12-Mar-12|Mar-12 2|DIURETICS|12-Mar-12|Mar-12 2|ANTIHYPERLIPIDEMICS|12-Mar-12|Mar-12 2|ANTIHYPERTENSIVES|12-Mar-12|Mar-12 2|ULCER DRUGS|12-Mar-12|Mar-12 2|ANTIDEPRESSANTS|14-Mar-12|Mar-12 ; run; proc sort data=have; by id year_month; run; data want; set have; by id year_month; if first.year_month then seq=1; else seq+1; run; Please let us know if it worked for you.

Satish_Parida · ‎03-30-2019

Can you post how the data looks like, using data step datalines. Then it would be easy for us to provide some sort of result.

Satish_Parida · ‎03-11-2019

@Tom Q: Can you convert your little example into a complete valid XML file so other can use it to test? Ans: Attached to the query ! Q: What happens if you replace the spaces with hexcodes for space character? Ans: The Hexcodes are necessary as the Mapper uses them to convert them to particular character in SAS. e.g "	" translates to a "tab", "&" translates to "ampersand". Q: Or are you saying you are just having issues with values like: Ans: The issue is with any kind of blank character which is leading or trailing the non-blank charterers either be it plane space or hexcode for new line line feed or tabs. Note: If you run the code, and copy paste the result to notepad++ you can see the result. PS: The tab, quotes, ampersands, new lines are represented in hex codes in XML. Spaces don't need hex codes. If we put general tab, new line, in the xml file they are converted to space from XML mapping to SAS.

Satish_Parida · ‎03-08-2019

Q: Can you convert your little example into a complete valid XML file so other can use it to test? Ans: Attached to the query ! Q: What happens if you replace the spaces with hexcodes for space character? Ans: The Hexcodes are necessary as the Mapper uses them to convert them to particular character in SAS. e.g "	" translates to a "tab", "&" translates to "ampersand". Q: Or are you saying you are just having issues with values like: Ans: The issue is with any kind of blank character which is leading or trailing the non-blank charterers either be it plane space or hexcode for new line line feed or tabs. Note: If you run the code, and copy paste the result to notepad++ you can see the result. PS: The tab, quotes, ampersands, new lines are represented in hex codes in XML. Spaces don't need hex codes. If we put general tab, new line, in the xml file they are converted to space from XML mapping to SAS.

Satish_Parida · ‎03-08-2019

@Tom I am sorry if not explaining the issue correctly. The field in question looks like following, in the Value attribute in the ItemData field. <ItemData ItemOID="VS.C4" TransactionType="Upsert" Value="	



 TEsting 	special 
character		



"> All the hexa codes are converted to specific values without any issue. The issue is the blank characters before the first non-blank character and the blank characters after the last non-blank character are not converted at all, they are trimmed before transforming to SAS data set files.

Satish_Parida · ‎03-08-2019

@Tom We have blank characters which involve tabs, spaces, new lines, line feeds e.g. 

 ;	 If line feed is converted to space then they don't serve the purpose in our case.

Satish_Parida · ‎03-08-2019

This is not about variable lengths, we have defined lengths for all the variables in Mapper file, and the data in the XML file is way smaller than the assigned length. Issue is XML Mapper trimming those leading and trailing spaces. If you run the code with the files, in line 2 we are expecting the leading and trailing spaces. How ever the blank characters in the middle of the string works fine.

Satish_Parida · ‎03-08-2019

Hi All, I am converting XML files to SAS files using XML mapper. Issue: We have some Charterer variables which have leading and trailing blank characters (tab/space/line feed)in the string in the XML file. e.g. "

 TEsting 	" By W3 standard SAS removes the blank characters and creates the SAS data-set without any leading or trailing blank characters. But we need the leading and trailing blank charactersin the Value field. I have attached the Mapper file and the source file and here is the code I have used. Please change the local path in the code before you run it. filename NHL "C:\Users\satish.k.parida\Desktop\ClinicalAuditRecords.xml"; /*File attached*/ filename MAP "C:\Users\satish.k.parida\Desktop\RAVE_ODM_MAP.map"; /*File attached*/ libname NHL xmlv2 xmlmap=MAP; data ItemData; set NHL.ItemData; run; To see if you are getting the new lines or tabs you can copy the text from SAS viewer or editor and paste it in a notepad ++ to view symbols. I am not sure if we can run this on University edition. We have defined lengths for all the variables in Mapper file, and the data in the XML file is way smaller than the assigned length. Issue is XML Mapper trimming those leading and trailing spaces. If you run the code with the files, in 2nd record we are expecting the leading and trailing spaces. How ever the blank characters in the middle of the string works fine. The issue is not environment specific, I have ran in windows and Linux and UTF8 and English SAS. Apologizes, as I could not upload the XML and the mapper file individually so I had to upload the zip file. file snippet <ItemData ItemOID="VS.C4" TransactionType="Upsert" Value="	



 TEsting 	special 
character		



"> Thanks in Advance.

Satish_Parida · ‎03-02-2019

See the following Link https://communities.sas.com/t5/SAS-Enterprise-Guide/Recommended-maximum-number-of-variables-for-data-set-in-EG/td-p/5133 Check the 1st answer, you can test out the number of maximum variables possible. But the concern will be hitting the memory, while accessing or writing into the data set or simply storing it.

Online Status	Offline
Date Last Visited	‎04-17-2023 07:51 AM

Re: Reading CSV file with double quotes, line breaks and spaces

Re: Reading a csv file with records length more than 33,000

Re: Case when multiple conditions to create aggregated value

Re: Case when multiple conditions to create aggregated value

Reading a csv file with records length more than 33,000

Re: Control the Log and Listing Location from Batch Call in SAS Grid S...

Re: Control the Log and Listing Location from Batch Call in SAS Grid S...

Control the Log and Listing Location from Batch Call in SAS Grid Serve...

Re: Using in-format (??) in proc fcmp

Re: Using in-format (??) in proc fcmp

Re: Control the Log and Listing Location from Batch Call in SAS Grid S...

Re: Replace null with value by looking back and ahead a certain number...

Re: break field with -

Re: SAS Programming

Re: Removing postfix (e.g Inc, Limited) in corporate names

Re: Deleting rows with condition

Re: XML LIBNAME reading data from URL

Re: SAS:how to use index to pick out macro array variable

Re: Case when multiple conditions to create aggregated value

Re: break field with -

Re: SAS regular Expression

Re: SAS regular Expression

SAS regular Expression

Proc Transpose character numeric issue

Re: Conditionally insert a row for unique id

Re: creating decode if not available in the dataset before proc freq

Re: Adding seq number

Re: Construct portfolio by adding stocks daily and dropping them after...

Re: Retaining leading and trailing blank characters in XML Mapper

Re: Retaining leading and trailing blank characters in XML Mapper

Re: Retaining leading and trailing blank characters in XML Mapper

Re: Retaining leading and trailing blank characters in XML Mapper

Re: Retaining leading and trailing blank characters in XML Mapper

Retaining leading and trailing blank characters in XML Mapper

Re: Number of Columns in a Dataset