cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Qavi
‎09-20-2019
  • 4 Posts
  • 5 Likes Given
  • 0 Solutions
  • 0 Likes Received

How to read row delimiter in SAS

by Fluorite | Level 6 in SAS Programming
‎06-28-2017 09:29 AM
‎06-28-2017 09:29 AM
I am trying to read the data from .txt external file through SAS Code,it has '|' as a column delimiter and '<' as a row delimiter.I am not able to read the data in proper way,I am using below mentioned code to read the data from the server.Data is coming in as a data stream without any end of line indicators like CRLF.I tried all the options FLOWOVER,MISSOVER and TRUCOVER but i am not getting the desired result.Can someone let me know how to read the row delimiter here ? Thanks for your help. DATA WORK.PURCHASE; LENGTH Filer_TIN $ 11 Ret_Type $ 1 Period_Key 8 TAXABLE_GOODS_VAL 8 AMT_TAX_VAL 8 INCL_TAX_VAL 8 COMP_VAL 8 TAX_FRE_SALES_VAL 8 EXEM_SALES_VAL 8 LABOUR_CHRGES_VAL 8 OTHER_CHRGES_VAL 8 GROSS_TOTAL_VAL 8 FORM_NUM 8 TYPE_OF_TX 8 Partner_TIN $ 11; FORMAT Filer_TIN $CHAR11. Ret_Type $CHAR1. Period_Key BEST4. TAXABLE_GOODS_VAL BEST11. AMT_TAX_VAL BEST9. INCL_TAX_VAL BEST10. COMP_VAL BEST9. TAX_FRE_SALES_VAL BEST10. EXEM_SALES_VAL BEST8. LABOUR_CHRGES_VAL BEST10. OTHER_CHRGES_VAL BEST9. GROSS_TOTAL_VAL BEST11. FORM_NUM BEST3. TYPE_OF_TX BEST2. Partner_TIN $CHAR11.; INFORMAT Filer_TIN $CHAR11. Ret_Type $CHAR1. Period_Key BEST4. TAXABLE_GOODS_VAL BEST11. AMT_TAX_VAL BEST9. INCL_TAX_VAL BEST10. COMP_VAL BEST9. TAX_FRE_SALES_VAL BEST10. EXEM_SALES_VAL BEST8. LABOUR_CHRGES_VAL BEST10. OTHER_CHRGES_VAL BEST9. GROSS_TOTAL_VAL BEST11. FORM_NUM BEST3. TYPE_OF_TX BEST2. Partner_TIN $CHAR11.; INFILE '/sas/EIUData/PURCHASE_ANNEX.txt' LRECL=102 ENCODING="UTF-8" DLMSTR="|" truncover; INPUT Filer_TIN : $CHAR11. Ret_Type : $CHAR1. Period_Key : ?? BEST4. TAXABLE_GOODS_VAL : ?? COMMA11. AMT_TAX_VAL : ?? COMMA9. INCL_TAX_VAL : ?? COMMA10. COMP_VAL : ?? COMMA9. TAX_FRE_SALES_VAL : ?? COMMA10. EXEM_SALES_VAL : ?? COMMA8. LABOUR_CHRGES_VAL : ?? COMMA10. OTHER_CHRGES_VAL : ?? COMMA9. GROSS_TOTAL_VAL : ?? COMMA11. FORM_NUM : ?? BEST3. TYPE_OF_TX : ?? BEST2. Partner_TIN : $CHAR11. ; RUN; Sample Data : 27020018076 |R|1606|5045.48|277.48|0.00|0.00|0.00|0.00|0.00|0.00|5322.96|231 |10 |27080058880 |<27020018076 |R|1606|947.87|52.13|0.00|0.00|0.00|0.00| 0.00|0.00|1000.00|231 |10 |27131130266 |<27020018076 |R|1606|1848.34|101.66|0.00|0.00|0.00|0.00|0.00|0.00|1950.00|231 |10 |27220036105 |<27020018076 |R|1606|8597.17|472.85|0.00|0.00|0.00|0.00|0.00|0.00|9070.02|231 |10 |27220646138 |<27020018076 |R|1606|22800.00|1360.00|0.00| 0.00|0.00|0.00|0.00|0.00|24160.00|231 |10 |27240041138 |<27020018076 |R|1606|67096.22|4025.02|0.00|0.00|0.00|0.00|0.00|0.00|71121.24|231 |10 |27260645728 |<27020018076 |R|1606|6493.12|357.12|0.00|0.00|0.00|0.00|0.00|0.00|6850.24|231 |10 |27270301033 |<27020018076 |R|1606|945001.00| 52605.00|0.00|0.00|0.00|0.00|0.00|0.00|997606.00|231 |10 |27290000710 |<27020018076 |R|1606|3981.04|218.96|0.00|0.00|0.00|0.00|0.00|0.00|4200.00| 231 |10 |27290279682 |<27020018076 |R|1606|2800.00|168.00|0.00|0.00|0.00|0.00|0.00|0.00|2968.00|231 |10 |27361171219 |<27020018076 |R|1606| 59052.49|3247.87|0.00|0.00|0.00|0.00|0.00|0.00|62300.36|231 |10 |27390019279 |<27020018076 |R|1606|8583163.22|514989.78|0.00|0.00|0.00|0.00| 0.00|0.00|9098153.00|231 |10 |27460293314 |<27020018076 |R|1606|440662.27|26439.73|0.00|0.00|0.00|0.00|0.00|0.00|467102.00|231 |10 | 27490371140 |<27020018076 |R|1606|4146.96|228.08|0.00|0.00|0.00|0.00|0.00|0.00|4375.04|231 |10 |27530294100 |<27020018076 |R|1606|54424.24| 7347.24|0.00|0.00|0.00|0.00|0.00|0.00|61771.48|231 |10 |27610060189 |<27020018076 |R|1606|3500.50|192.50|0.00|0.00|0.00|0.00|0.00|0.00|3693.00| 231 |10 |27650269493 |<27020018076 |R|1606|471985.10|28319.10|0.00|0.00|0.00|0.00|0.00|0.00|500304.20|231 |10 |27670990871 |<27020018076 | R|1606|2853.81|171.23|0.00|0.00|0.00|0.00|0.00|0.00|3025.04|231 |10 |27690241729 |<27020018076 |R|1606|642012.00|38970.74|0.00|0.00|0.00|0.00| Kindly find the attached sample data for refrence. ... View more

Re: Row and column delimiter

by Fluorite | Level 6 in SAS Programming
‎06-28-2017 08:41 AM
‎06-28-2017 08:41 AM
Hi Patrick,   I am trying to read the data from .txt external file through SAS Code,it has '|' as a column delimiter and '<' as a row delimiter.I am not able to read the data in proper way,I am using below mentioned code to read the data from the server.Data is coming in as a data stream without any end of line indicators like CRLF.I tried all the options FLOWOVER,MISSOVER and TRUCOVER but i am not getting the desired result.Can you please let me know how to read the row delimiter here ? Thanks for your help.   DATA WORK.PURCHASE;     LENGTH         Filer_TIN        $ 11         Ret_Type         $ 1         Period_Key         8         TAXABLE_GOODS_VAL   8         AMT_TAX_VAL        8         INCL_TAX_VAL       8         COMP_VAL           8         TAX_FRE_SALES_VAL   8         EXEM_SALES_VAL     8         LABOUR_CHRGES_VAL   8         OTHER_CHRGES_VAL   8         GROSS_TOTAL_VAL    8         FORM_NUM           8         TYPE_OF_TX         8         Partner_TIN      $ 11;     FORMAT         Filer_TIN        $CHAR11.         Ret_Type         $CHAR1.         Period_Key       BEST4.         TAXABLE_GOODS_VAL BEST11.         AMT_TAX_VAL      BEST9.         INCL_TAX_VAL     BEST10.         COMP_VAL         BEST9.         TAX_FRE_SALES_VAL BEST10.         EXEM_SALES_VAL   BEST8.         LABOUR_CHRGES_VAL BEST10.         OTHER_CHRGES_VAL BEST9.         GROSS_TOTAL_VAL  BEST11.         FORM_NUM         BEST3.         TYPE_OF_TX       BEST2.         Partner_TIN      $CHAR11.;     INFORMAT         Filer_TIN        $CHAR11.         Ret_Type         $CHAR1.         Period_Key       BEST4.         TAXABLE_GOODS_VAL BEST11.         AMT_TAX_VAL      BEST9.         INCL_TAX_VAL     BEST10.         COMP_VAL         BEST9.         TAX_FRE_SALES_VAL BEST10.         EXEM_SALES_VAL   BEST8.         LABOUR_CHRGES_VAL BEST10.         OTHER_CHRGES_VAL BEST9.         GROSS_TOTAL_VAL  BEST11.         FORM_NUM         BEST3.         TYPE_OF_TX       BEST2.         Partner_TIN      $CHAR11.;     INFILE '/sas/EIUData/PURCHASE_ANNEX.txt'         LRECL=102         ENCODING="UTF-8" DLMSTR="|" truncover;       INPUT         Filer_TIN        : $CHAR11.         Ret_Type         : $CHAR1.         Period_Key       : ?? BEST4.         TAXABLE_GOODS_VAL : ?? COMMA11.         AMT_TAX_VAL      : ?? COMMA9.         INCL_TAX_VAL     : ?? COMMA10.         COMP_VAL         : ?? COMMA9.         TAX_FRE_SALES_VAL : ?? COMMA10.         EXEM_SALES_VAL   : ?? COMMA8.         LABOUR_CHRGES_VAL : ?? COMMA10.         OTHER_CHRGES_VAL : ?? COMMA9.         GROSS_TOTAL_VAL  : ?? COMMA11.         FORM_NUM         : ?? BEST3.         TYPE_OF_TX       : ?? BEST2.         Partner_TIN      : $CHAR11. ; RUN;   How we can read "<" as rew delimitre in SAS?coud you please help me on this?     Sample Data :   27020018076 |R|1606|5045.48|277.48|0.00|0.00|0.00|0.00|0.00|0.00|5322.96|231 |10 |27080058880 |<27020018076 |R|1606|947.87|52.13|0.00|0.00|0.00|0.00| 0.00|0.00|1000.00|231 |10 |27131130266 |<27020018076 |R|1606|1848.34|101.66|0.00|0.00|0.00|0.00|0.00|0.00|1950.00|231 |10 |27220036105 |<27020018076 |R|1606|8597.17|472.85|0.00|0.00|0.00|0.00|0.00|0.00|9070.02|231 |10 |27220646138 |<27020018076 |R|1606|22800.00|1360.00|0.00| 0.00|0.00|0.00|0.00|0.00|24160.00|231 |10 |27240041138 |<27020018076 |R|1606|67096.22|4025.02|0.00|0.00|0.00|0.00|0.00|0.00|71121.24|231 |10 |27260645728 |<27020018076 |R|1606|6493.12|357.12|0.00|0.00|0.00|0.00|0.00|0.00|6850.24|231 |10 |27270301033 |<27020018076 |R|1606|945001.00| 52605.00|0.00|0.00|0.00|0.00|0.00|0.00|997606.00|231 |10 |27290000710 |<27020018076 |R|1606|3981.04|218.96|0.00|0.00|0.00|0.00|0.00|0.00|4200.00| 231 |10 |27290279682 |<27020018076 |R|1606|2800.00|168.00|0.00|0.00|0.00|0.00|0.00|0.00|2968.00|231 |10 |27361171219 |<27020018076 |R|1606| 59052.49|3247.87|0.00|0.00|0.00|0.00|0.00|0.00|62300.36|231 |10 |27390019279 |<27020018076 |R|1606|8583163.22|514989.78|0.00|0.00|0.00|0.00| 0.00|0.00|9098153.00|231 |10 |27460293314 |<27020018076 |R|1606|440662.27|26439.73|0.00|0.00|0.00|0.00|0.00|0.00|467102.00|231 |10 | 27490371140 |<27020018076 |R|1606|4146.96|228.08|0.00|0.00|0.00|0.00|0.00|0.00|4375.04|231 |10 |27530294100 |<27020018076 |R|1606|54424.24| 7347.24|0.00|0.00|0.00|0.00|0.00|0.00|61771.48|231 |10 |27610060189 |<27020018076 |R|1606|3500.50|192.50|0.00|0.00|0.00|0.00|0.00|0.00|3693.00| 231 |10 |27650269493 |<27020018076 |R|1606|471985.10|28319.10|0.00|0.00|0.00|0.00|0.00|0.00|500304.20|231 |10 |27670990871 |<27020018076 | R|1606|2853.81|171.23|0.00|0.00|0.00|0.00|0.00|0.00|3025.04|231 |10 |27690241729 |<27020018076 |R|1606|642012.00|38970.74|0.00|0.00|0.00|0.00|   Kindly find the attached sample data for your refrence. ... View more

Re: BI Lineage Plug-in is missing from SAS Management Console-9.3!!

by Fluorite | Level 6 in Administration and Deployment
‎04-03-2017 07:52 AM
‎04-03-2017 07:52 AM
  I checked SMC by running /sasmeta/SASHome/SASManagementConsole/9.3/sasmc on Server through GUI, BI lineage Plug-in was there, so it might be some file got corrupted on client machine. As you suggested, I re-installed the SMC on client machine and it gets resolved. Thank You for your reply!!!     ... View more

BI Lineage Plug-in is missing from SAS Management Console-9.3!!

by Fluorite | Level 6 in Administration and Deployment
‎04-01-2017 09:11 AM
‎04-01-2017 09:11 AM
Hi Guys,                   I was looking to scan the SAS objects through BILineage Plug-in of SAS Management Console 9.3, I logged in through sasadm@saspw user but I couldn’t find the BILineage Plug-in under ‘Environment Management’ tree. After doing analysis I found that 2 more plug-ins (Configuration Manager and Deployment Tester) are missing from ‘Application Management’ tree. We are using SAS Software since 2012 and I had done same activity last year but now BI Lineage plug-in is missing form that tree. We had Maintenance activity in last month, due to this, we had shutdown all the servers (SAS & database) but I am not sure whether BI lineage plug-in was there at that time, I just checked yesterday and got to know that plug-in is missing. No Configuration changes have been done on any server since last 2 years so what will be the exact reason? &how I can resolve this issue without restoring it from the backup? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-20-2019 10:49 AM
Likes given to
Quick links