About sonic_poem

sonic_poem · ‎06-21-2019

Thanks for the info. Will give csv file a chance. Updated the subject title from "error" to "warning" messages.

sonic_poem · ‎06-20-2019

I have an Excel spreadsheet titled "Need" that includes a variable "Story." The variable "Story" has a large text and is >$20,000 in length. Importing the spreadsheet "Need" with the variable "Story" using the proc import statement below is giving me error messages for every line in the dataset (see Warning message below.) How do I troubleshoot and make sure all my variables are imported properly? proc import OUT=want DATAFILE= "C:File\Need.xlsx" DBMS=XLSX REPLACE; sheet='Sheet1'; run; . . WARNING: Some character data was lost during transcoding in column: Story at obs 8540. WARNING: Some character data was lost during transcoding in column: Story at obs 8542.

sonic_poem · ‎06-20-2019

Got it. Thanks.

sonic_poem · ‎06-20-2019

I just received an error message below: NOTE: Character values have been converted to numeric values at the places given by:(Line):(Column). 72:8 I'm puzzled by this message since the column 8 in my dataset is a gender variable that has no numeric value. I would like to look up the cell value using line and column value provided in the error message. Please help.

sonic_poem · ‎05-30-2019

Thank you! It worked!!

sonic_poem · ‎05-30-2019

Hi, I inherited a program containing macro codes and saw the log message below. Can you help troubleshoot what the issue is regarding the following codes? data _null_; set test8 end=eof; call symputx('Product'||left(_n_), product, 'G'); call symputx('Environment'||left(_n_), environment, 'G'); if eof then call symputx('numrows',_n_, 'G'); run; NOTE: Numeric values have been converted to character values at the places given by: (Line) : (Column). 1463:35 1464:35

sonic_poem · ‎05-29-2019

Thanks for the detailed analysis. I'm learning to code in macro. I appreciate it. This solution worked, too!

sonic_poem · ‎05-29-2019

Thanks, it worked!

sonic_poem · ‎05-29-2019

Thank you for the reply. But, I need to use this value for my next step so I do need this as a macro variable.

sonic_poem · ‎05-29-2019

Hello, I have a data set below. I need to set the first (or the least) count value as a macro variable (constant) where the cumulative percent (cum_pct) is at least 80.0. So, for this data set, I need to write a program obtain count of 7 (since cum_pct is >= 80.0 for the first time in this datase) and create a macro variable for it. I attempted using Do While loop and received the error messages below. Please advise. Ct cum_pct 1 40.0 2 51.8 3 58.1 4 62.4 5 76.2 6 79.4 7 80.9 8 83.8 9 94.0 10 100.0 proc sort data=test_freq;by ct;run; data _null_; do while(cum_pct>=80); set test_freq ; by ct; do i=1 to _n_; call symput ('ctpct', ct); if first.ct; end; end; run; %let ctpct=&ctpct; %let ctpctn=%eval(&ctpct); ctpct resolves to character string "ct". ctpctn resolves to _null_.

sonic_poem · ‎05-24-2019

The corrected version below is working. Thank you! data tagged; length id $ 8 check1-check&reviewn 8; do until (last.id); set case3; by id; array pt(&reviewn) $; array check(&reviewn) ; do i = 1 to dim(check); check[i] = index(PTUPC,strip(pt[i])); end; end; drop i; run;

sonic_poem · ‎05-24-2019

Thanks for the feed back. I tried the methods suggested. I also tried using numeric version of review (as reviewn) to see if it helps. proc sql; select count as observation into: review TRIMMED from high; quit; %let review=&review; %let reviewn=%eval(&review); Good thing is using either REVIEW or REVIEWN, I no longer get any error messages. However, all my CHECK variables are 0 using the program below. I believe CHECK should be a numeric variable since it's an output from the INDEX function. I have modified the code as suggested. I am also uploading the sample data and the output I would like to see when the program runs successfully. proc sort data=case3;by id;run; data tagged; length id $ 8 check1-check&review 8; do until (last.id); set case3; by id; array pt(&review) $; array check(&review) ; do i = 1 to dim(check); call symputx ('name', pt[i]); check[i] = index (PTUPC,'&name'); end; end; drop i; run; id pt1 pt2 pt3 allpt ck1 ck2 ck3 a001 ab ab ac abd 1 1 0 a002 ac ab dc abd 0 1 0 a003 ad ab bd abd 0 1 2

sonic_poem · ‎05-23-2019

I have character variables pt1-pt&review (the maximum ranges vary). I'm trying to find out if there is a match to main variable allpt for each of these variables by using index function for all the rows (first.id to last.id) in the dataset. If matched, the array variables check1-check&review will have value>0. Since I need to use the value of the variables pt1-pt34 for index function, I tried using macro function "call symputx..." I'm getting error messages with the codes below. data tagged; length id $ 8 check1-check&review 8; do until (last.id); set case; by id; array pt(&review) $; array check(&review) $; do i = 1 to dim(check); call symputx ('name', pt[i]); check[i] = index (allpt,'&name'); end; drop i; run; ERROR 22-322: Syntax error, expecting one of the following: a name, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_. ERROR: Missing numeric suffix on a numbered variable list (check1-check). ERROR 352-185: The length of numeric variables is 3-8. Macro variable REVIEW resolved successfully, by the way. Thanks for help!

Online Status	Offline
Date Last Visited	‎04-15-2021 04:48 PM

Re: Troubleshooting Proc Import warning messages

Troubleshooting Proc Import Warning messages

Re: Look up cell value using line and column #s

Look up cell value using line and column #s

Re: Troubleshooting macro codes

Troubleshooting macro codes

Re: Macro and Do loop?

Re: Macro and Do loop?

Re: Macro and Do loop?

Macro and Do loop?

Re: Macro and Do loop?

Re: Troubleshooting Proc Import warning messages

Troubleshooting Proc Import Warning messages

Re: Look up cell value using line and column #s

Look up cell value using line and column #s

Re: Troubleshooting macro codes

Troubleshooting macro codes

Re: Macro and Do loop?

Re: Macro and Do loop?

Re: Macro and Do loop?

Macro and Do loop?

Re: Macro and array loop

Re: Macro and array loop

Macro and array loop