About ama220

ama220 · ‎08-15-2024

Thanks!

ama220 · ‎08-15-2024

Thank you! The file has many variables and I did not wan to list them all in in the input line. Do you know an easy way to do that without having to type them all?

ama220 · ‎08-15-2024

Thanks, it worked!

ama220 · ‎08-15-2024

Thanks, it worked!

ama220 · ‎08-14-2024

Folks, I need help with importing character variables that do not have truncated values from csv files. Below is my import code and the lenght of the variable I need to reach. Any help with resolving this issue would be much appreciated! PROC IMPORT OUT= TEST.my_data_2 DATAFILE= "C:\testing\drugx\data\rhabdomyo.csv" DBMS=CSV REPLACE; GETNAMES=YES; DATAROW=2; RUN; Variable Type Len Format Informat Drugname Char 13 $13. $13

ama220 · ‎08-14-2024

Folks, I need help with importing character variables that do not have truncated values from csv files. Below is my import code and the lenght of the variable I need to reach. Any help with resolving this issue would be much appreciated! PROC IMPORT OUT= TEST.my_data_2 DATAFILE= "C:\testing\drugx\data\rhabdomyo.csv" DBMS=CSV REPLACE; GETNAMES=YES; DATAROW=2; RUN; Variable Type Len Format Informat Drugname Char 13 $13. $13

ama220 · ‎04-11-2023

Thanks, unofratnely, I am still missing instances of flagging "month" instances in the character variable in question b/c my data is messy. The only thing that seems to work is using a data step and the index variable. Any idea of what would be a better command to use. I tried many things to no avail and given that I have other similar character variables to code, I need a better way. if index(dose_vbm,'month') > 0;

ama220 · ‎04-08-2023

Thanks! This seems to be the right way; just had an error: findw(dose_vbm, (string,'every 3 month',' ;:?') or findw(string,'every 3 months',' ; - 22 2223! :?') or findw(string,'q3months',' ;:?') then dose_vbm_freq = 'months' ;else ERROR 22-322: Syntax error, expecting one of the following: (, ), [, {.

ama220 · ‎04-08-2023

Thanks for your help, all the examples I provided are a match: every three months or q3months. The challenge is the values are presented as shown in the example I shared so I am trying to shorten the code to capture these cases.

ama220 · ‎04-08-2023

Thanks for your quick response! One flag variable to capture all these cases without having to coping them all in the findw statement or a similar one.

ama220 · ‎04-08-2023

Hello, I am trying to create a flag variable for certain values in a string variable. I tried the “findw” statement but is not specific enough to capture certain same values as shown below without having to use endless number of entries. Any idea how I can a write a brief code that would capture cases as highlighted without having to put accompanying semicolon, or question marks? If findw(dose, "") or findw(dose, "") then dose_3_months = 1; ? other frequency:once every 3 month;other route:inject? ? other frequency:q3months ;? ? other frequency:q3months;? 200 units?every 3 months?head, neck, and shoulders every 3 months? every 3 months?given into/under the skin every 3 months?head/neck injections

ama220 · ‎03-17-2023

Thanks! I was tried the same code but on a different dataset. No wonder it did not work earlier.

ama220 · ‎03-17-2023

Hello: I have a set of variables that start with the same prefix. I would like to drop some of them. E.g., Variables are AC1 AC2 AC3 AC4 ...... AC100. I'd like to retain the first 10 ACx variables and delete the rest after that. Thanks for your help!

ama220 · ‎03-14-2023

Thanks for your help!!

ama220 · ‎03-14-2023

Thanks for the detailed response! This worked as well, but I saw the top one first and accepted as the solution.

Online Status	Offline
Date Last Visited	‎08-15-2024 03:48 PM

Re: importing untruncated character variable from csv file

Re: importing untruncated character variable from csv file

Re: importing untruncated character variable from csv file

Re: importing untruncated character variable from csv file

importing untruncated character variable from csv file

Re: Where do I post my question in the SAS Support Communities?

Re: Help with findw

Re: Help with findw

Re: Help with findw

Re: Help with findw

Re: importing untruncated character variable from csv file

Re: importing untruncated character variable from csv file

Re: importing untruncated character variable from csv file

Re: Help with findw

Re: Help with findw

Re: importing untruncated character variable from csv file

Re: importing untruncated character variable from csv file

Re: importing untruncated character variable from csv file

Re: importing untruncated character variable from csv file

importing untruncated character variable from csv file

Re: Where do I post my question in the SAS Support Communities?

Re: Help with findw

Re: Help with findw

Re: Help with findw

Re: Help with findw

Help with findw

Re: Dropping some, not all, variables with the same prefix

Dropping some, not all, variables with the same prefix

Re: Extracting the year from a character SAS variable

Re: Extracting the year from a character SAS variable