About avatar

avatar · ‎07-16-2019

I am getting error --- when I run that code with my sas dataset

avatar · ‎07-16-2019

I got this below code – how do I use it with filename statement. Please explain FILENAME dlmtest &filename lrecl=5000; DATA _NULL_; set New_Daily_claims; file dlmtest dsd LRECL=5000 dlm = '|'; /*  CHANGE THAT TO PIPE SYMBOL, Note: DSD AND LRECL Are required. */ PUT(_ALL_)(+0); RUN;

avatar · ‎07-16-2019

I can not use proc Export in remote setup. I need to use a in data step/ please advise thanks

avatar · ‎07-16-2019

I would like to export sas output as .txt file with pipe delimiter. Please help Thanks

avatar · ‎06-20-2019

oh! I found out the error for previous step . not for my code. it is working fine now t Thank you all for your replies. All worked fine!

avatar · ‎06-20-2019

I am trying to add zero for patient number if the length is than 7 following code gives error data fix_ptnt; set FCR_ADUIT_REPORT; format patient_id $20.; if length(PATIENT_SRC_NO) = 6 then patient_id = '0'||strip(PATIENT_SRC_NO); run; can you please help? thanks,

avatar · ‎05-24-2019

it is character data 585452101 571629201 585175701 24968566 579876301 575507505 184126254 184021353 577099102

avatar · ‎05-24-2019

I would lik eto know whaich sas function to use to get all orders ending with 01. Please reply Thanks

avatar · ‎05-24-2018

Thank you all very much !!!!. Now I understand how this works.

avatar · ‎05-24-2018

I Would like to remove supplies from file. below code does not work. it works only for one supply. when combined , it does not remove . any other way to remove all at once. AND (A.PROD_1_DESC NOT LIKE 'ADAPTER%' OR A.PROD_1_DESC NOT LIKE 'AUVI-Q%' OR A.PROD_1_DESC NOT LIKE 'AVOSTARTGRIP%' OR A.PROD_1_DESC NOT LIKE 'CATH++%' OR A.PROD_1_DESC NOT LIKE 'CLAVE%' OR A.PROD_1_DESC NOT LIKE 'CONNECTOR%' OR A.PROD_1_DESC NOT LIKE 'CRONO SYRINGE%' OR A.PROD_1_DESC NOT LIKE 'DRESSING%' OR A.PROD_1_DESC NOT LIKE 'FILTER%' OR A.PROD_1_DESC NOT LIKE 'GRIPPER%' OR A.PROD_1_DESC NOT LIKE 'HUBER%' Please help. Thanks

avatar · ‎05-03-2016

I cannot list all drugs using like, right? WHERE t1.PRODUCT_DESC_1 like ('*ARIPIPRAZOLE*','*ASENAPINE*')

avatar · ‎05-03-2016

I find variations in drug name like ARIPIPRAZOLE++, ARIPIPRAZOLE Contains brings both. I will go with contains WHERE t1.PRODUCT_DESC_1 CONTAINS ('ARIPIPRAZOLE') OR t1.PRODUCT_DESC_1 CONTAINS ('CLOZAPINE'); This code worked . Thank you so much!!

avatar · ‎05-03-2016

With below code got error again: ERROR: CONTAINS operator requires character operands. A.PRODUCT_DESC_1 CONTAINS ('ARIPIPRAZOLE' or 'ASENAPINE' or 'BREXPIPRAZOLE'). Anything wrong?

avatar · ‎05-03-2016

I want to search for list of drugs in oracle database. can I list all the drugs in proc sql in where clause as below? WHERE ( (A.PRODUCT_DESC_1 CONTAINS ('ARIPIPRAZOLE',' ASENAPINE',BREXPIPRAZOLE) I got ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, ) Please help Thanks,

avatar · ‎04-28-2016

Tried with datepart and got zero rows. Not sure which one to use . Please advise. AND datepart(a.trans_dt >="&T1"d) and datepart(a.trans_dt <="&T2"d)) SYMBOLGEN: Macro variable T1 resolves to 17APR2016 SYMBOLGEN: Macro variable T2 resolves to 23APR2016 74 order by a.trans_dt; NOTE: Table WORK.SPARCS_RETURN created, with 0 rows and 29 columns. 75 QUIT;

Online Status	Offline
Date Last Visited	‎07-07-2020 06:09 PM

Re: How to export sas dataset as txt file with pipe delimiter?

Re: How to export sas dataset as txt file with pipe delimiter?

Re: How to export sas dataset as txt file with pipe delimiter?

How to export sas dataset as txt file with pipe delimiter?

Re: Problem with Concat function

Problem with Concat function

Re: SAS Function to to identify orders ending with 01

SAS Function to to identify orders ending with 01

Re: NOT LIKE OPERATOR DOES NOT WORK WITH A LIST

NOT LIKE OPERATOR DOES NOT WORK WITH A LIST

Re: How to export sas dataset as txt file with pipe delimiter?

Re: NOT LIKE OPERATOR DOES NOT WORK WITH A LIST

Re: How to find list of drugs in oracle db?

Re: How to export sas dataset as txt file with pipe delimiter?

Re: How to export sas dataset as txt file with pipe delimiter?

Re: How to export sas dataset as txt file with pipe delimiter?

How to export sas dataset as txt file with pipe delimiter?

Re: Problem with Concat function

Problem with Concat function

Re: SAS Function to to identify orders ending with 01

SAS Function to to identify orders ending with 01

Re: NOT LIKE OPERATOR DOES NOT WORK WITH A LIST

NOT LIKE OPERATOR DOES NOT WORK WITH A LIST

Re: How to find list of drugs in oracle db?

Re: How to find list of drugs in oracle db?

Re: How to find list of drugs in oracle db?

How to find list of drugs in oracle db?

Re: Create a Macro to resolve date ranges to use in Proc SQL