About ama220

ama220 · ‎03-14-2023

Thank you, this also worked. I saw the top one first. I appreciate your help!

ama220 · ‎03-07-2023

Hello: Any help with extracting the year from a SAS character variable Latest_date_Date Char 11 $11. example 08-mar-2001 End result wanted is a new latest_year = 2001. Thanks!

ama220 · ‎02-17-2023

Thanks!

ama220 · ‎02-16-2023

Hello, I need to suppress categories with low frequency values (less than 10) from the output of proc freq. Any tips to me me out would be appreciated. proc freq order= freq ; table outcome_coded

ama220 · ‎01-13-2021

Thanks for responding. There was an error in the log: NOTE: Invalid third argument to function SUBSTR at line 566 column 11.

ama220 · ‎01-13-2021

Thanks! It worked but for some observations, as seen below, I am getting a missing value for the extracted dose. 7 injections 25 units each, injected into spinal area quantity:155 units;other frequency:1 set of injection;? inject 200 unit every 3 mo intra-muscularly frequency - 155 units every 3 months i.m?recent dose quantity: 16, dose unit: units dose - 400u?frequency q90ds ? quantity:155 iu international unit(s);other route:injection?

ama220 · ‎01-13-2021

Hello, I am having trouble extracting the dose and unit information from the below character variable and appreciate any help. data have: dose_all 125 units, single 200 units 240 iu, single 25 units prn im ? other frequency:q 90 days;? 100 u 300 iu, single 400 units once im between 100 to 200 units, single Data want (only dose, unit) are most important to extract. dose_all dose unit x1 x2 x3 x3 125 units, single 125 units single 200 units 200 units 240 iu, single 240 iu single 25 units prn im 25 units prn im ? other frequency:q 90 days;? ? other frequency:q 90 days;? 100 u 100 u 300 iu, single 300 iu single 400 units once im 400 units once im between 100 to 200 units, single between 100 to 200 units single Thanks

ama220 · ‎11-26-2018

Thank you for putting me on the right track. I ended up having to go through the excel file and deleting the extra spaces at the end of several cells that I had manually coded to resolve the problem. Although the code was helpful, it did not solve the problem completely.

ama220 · ‎11-26-2018

Thank you for putting me on the right track. I ended up having to go through the excel file and deleting the extra spaces at the end of several cells to resolve the problem. Although the code was helpful, it did not solve the problem completely.

ama220 · ‎11-26-2018

Thank you for your helpful insight and for taking the time to explain all this detail! It was helpful for me.

ama220 · ‎11-26-2018

Thanks! I believe that is the issue. Any idea how to spot the cells where the "alt-enter" occurs in the excel file?

ama220 · ‎11-26-2018

Thanks for your response. I am using the import statement as follows PROC IMPORT OUT= narr.filename DATAFILE= "c:\filename _nar.csv" DBMS=CSV REPLACE; GETNAMES=YES; DATAROW=2; GUESSINGROWS=MAX; RUN;

ama220 · ‎11-26-2018

I imported a cvs comma delimited file (that I saved from an excel file). This file contains some numeric variables as well as character variables. The character variables contain open ended narrative descriptions that can often be long. When I run a proc freq or a proc print, I get ineligible values for some variables, such as " , M, 1, 2. In one instance, the frequency contains a value from another variable. The problem seems to be limited to a few lines of data only but it is disruptive of my analysis. Here is an SAS Output that is not legible ID Frequency Percent " 2 1 Thanks

ama220 · ‎06-08-2018

I have this date variable (numeric, format DATE9.) that appears as 01DEC2011. I need to change that to this format: 12/29/2011. I seem to be missing something in my code (see below) because i'm getting missing values for the new date variable. start_dt_n = INPUT(PUT(start_dt,10.),YYMMDD10.); FORMAT start_dt_n MMDDYY10.; Any hints on how to fix this? Thanks

ama220 · ‎05-14-2018

Thanks, your code is great. Because I needed to limit to the month and year, I found the other code more appreciate to my needs. I really appreciate your help.

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: Extracting the year from a character SAS variable

Extracting the year from a character SAS variable

Re: How can I suppress categories with low frequencies from SA

How can I suppress categories with low frequencies from SA

Re: Unconcatenate dose from variable

Re: Unconcatenate dose from variable

Unconcatenate dose from variable

Re: Illegible freq values when reading CVS/excel file with narrative v...

Re: Illegible freq values when reading CVS/excel file with narrative v...

Re: Illegible freq values when reading CVS/excel file with narrative v...

Re: Illegible freq values when reading CVS/excel file with narrative v...

Re: Illegible freq values when reading CVS/excel file with narrative v...

Illegible freq values when reading CVS/excel file with narrative varia...

Change variable from numeric to SAS date

Re: Changing month-year variable from character to date format