topic Re: problems with formatting in SAS Programming

problems with formatting

vraj1 — Mon, 11 Jan 2016 12:18:25 GMT

I have a variable which has format $TDRUG41. and informat $41.

i want to filter

data ind;
set girdata;
if drug_id="DRUG 2";
run;

Somehow this is not working. Can anyone help me.

Re: problems with formatting

EH — Mon, 11 Jan 2016 12:31:57 GMT

Hello vraj1,

Probably "DRUG 2" is one of the formatted values of drug_id.

In that case:

if put(drug)id, $tdrug41.) = 'DRUG 2";

will do.

Otherwise please attach a small piece of the data and code.

Hope this helps,

Eric

Re: problems with formatting

vraj1 — Mon, 11 Jan 2016 12:39:44 GMT

The code which you had sent is not working somehow. It is running from 10 mins.

Re: problems with formatting

EH — Mon, 11 Jan 2016 12:41:00 GMT

Maybe because of my typo using different quote symbols :-(. It should be ' ' or " ". Sorry...

Re: problems with formatting

EH — Mon, 11 Jan 2016 12:42:02 GMT

and another typo which you must have seen, drug_id... Not my day today 😉

Re: problems with formatting

vraj1 — Mon, 11 Jan 2016 12:42:23 GMT

No 🙂 i corrected it but still.

if put(drug_id, $tdrug41.) = "Biphasic Insulin Aspart 30";

Re: problems with formatting

EH — Mon, 11 Jan 2016 12:46:04 GMT

Maybe you can add a few lines of data and also a few lines of the format definition. It may be something like variable length of uppercase/lowercase. Dirty work...

Eric

Re: problems with formatting

vraj1 — Mon, 11 Jan 2016 12:48:43 GMT

data ind;
set girdata;
*if drug_id="Biphasic Insulin Aspart 30";
if put(drug_id, $tdrug41.) = "Biphasic Insulin Aspart 30";
run;

Re: problems with formatting

EH — Mon, 11 Jan 2016 12:53:35 GMT

Try without 41, only $tdrug.

Re: problems with formatting

vraj1 — Mon, 11 Jan 2016 13:14:06 GMT

yes it worked 🙂

Thanks a lot

Re: problems with formatting

RW9 — Mon, 11 Jan 2016 13:28:32 GMT

Just want to add two points to this. Firstly, if @EH solution worked, its good form to mark his post as the result, both so other people can see the solution and so he gets some points for the effort. Secondly, why are you attempting to find a drug name via formats? If you need to use drug information you are far better off using coded data using WHO Drug coding. I would be suprised if you didn't have this autoencoding on the database. It allows you to find specific drugs/drug groups regardless of typos in the data, different product names etc. your example for instance could be Biphasic Insulin Aspart, your code wouldn't pick it up. Also, you then need to separately maintain your formats catalog, i.e. re-inventing the wheel.