cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ybz12003
‎12-18-2024
  • 877 Posts
  • 414 Likes Given
  • 7 Solutions
  • 20 Likes Received

Macro Error?

by Rhodochrosite | Level 12 in SAS Programming
‎01-31-2020 06:01 PM
‎01-31-2020 06:01 PM
Hello,   I have an error message shown in my macro coding, any idea where went wrong? %let FormatList = A B C; %let FormatCNT=%sysfunc(countw(&FormatList)); %do JJ = 1 %to &FormatCNT; %let Format=%scan(&FormatList,&JJ); proc sql; select distinct &Format. from test; quit; %end; 350 %let FormatList = A B C; 351 352 %let FormatlistCNT=%sysfunc(countw(&Formatlist)); 353 354 %do JJ = 1 %to &FormatlistCNT; ERROR: The %DO statement is not valid in open code. 355 356 %let Format=%scan(&Formatlist,&JJ); WARNING: Apparent symbolic reference JJ not resolved. WARNING: Apparent symbolic reference JJ not resolved. ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: &JJ ERROR: Argument 2 to macro function %SCAN is not a number. 357 358 proc sql; 359 select distinct &Format. from test; ----- 79 ERROR 79-322: Expecting a FROM. 360 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ERROR: The %END statement is not valid in open code. 361 362 %end;   ... View more

Re: Simplify the repeat format procedure?

by Rhodochrosite | Level 12 in SAS Programming
‎01-31-2020 05:58 PM
‎01-31-2020 05:58 PM
Thank you so much for all of your wonderful help! ... View more

Simplify the repeat format procedure?

by Rhodochrosite | Level 12 in SAS Programming
‎01-31-2020 05:45 PM
‎01-31-2020 05:45 PM
Hello,   I have the follow repeat coding.  Any idea how to simply them?  Thanks. data want (drop = A B C); set test; if A in ('No', 'n') then AA=0; if A in ('Yes', 'y') then AA=1; if B in ('No', 'n') then BB=0; if B in ('Yes', 'y') then BB=1; if C in ('No', 'n') then CC=0; if C in ('Yes', 'y') then CC=1; run; ... View more

Re: Find a specific text in the randomly?

by Rhodochrosite | Level 12 in SAS Programming
‎01-31-2020 04:35 PM
‎01-31-2020 04:35 PM
Thanks, that's what I want! ... View more

Re: Find a specific text in the randomly?

by Rhodochrosite | Level 12 in SAS Programming
‎01-31-2020 03:43 PM
‎01-31-2020 03:43 PM
No, I would like to find all the seven answers even though there are one word in-between 'Health Center' or in front of it.  ... View more

Find a specific text in the randomly?

by Rhodochrosite | Level 12 in SAS Programming
‎01-31-2020 03:22 PM
‎01-31-2020 03:22 PM
Hi experts,   I have a challenge situation here.   I would like to looking for a text with 'Health Center' in one of my variables.   However, it comes with different formats and different places.   I am curious, if there is a way to find them.  Thanks!   For example, 1. Health Center 2. health center 3. Health center 4. Health State Center 5. State health center 6. Health Department Center 7. Department health center ... View more

Re: How to list all the text answers in the one column?

by Rhodochrosite | Level 12 in SAS Programming
‎01-31-2020 02:20 PM
‎01-31-2020 02:20 PM
Awesome!! ... View more

Re: How to list all the text answers in the one column?

by Rhodochrosite | Level 12 in SAS Programming
‎01-31-2020 02:05 PM
‎01-31-2020 02:05 PM
No, I only the 20 different answers, not the full list of 500 rows.   ... View more

How to list all the text answers in the one column?

by Rhodochrosite | Level 12 in SAS Programming
‎01-31-2020 01:54 PM
‎01-31-2020 01:54 PM
Hello,   I have around twenty different answers in one column 'A'.   Column A is in text format.   I would like to get a full list for all of them.   Any idea how?  Basely, I would like to use the method to apply for the other ten variables.   Thanks! ... View more

Re: dataline starting at row 5?

by Rhodochrosite | Level 12 in SAS Programming
‎01-31-2020 01:47 PM
‎01-31-2020 01:47 PM
Thanks! ... View more

dataline starting at row 5?

by Rhodochrosite | Level 12 in SAS Programming
‎01-31-2020 12:48 PM
‎01-31-2020 12:48 PM
Hello,   When I import the Excel sheet, my dataline starts at row 5.  Please let me know how to specify this?  Thank you.   proc import datafile=ddd out=Crosswalk dbms=excel replace; getnames=yes; mixed=yes; scantext=yes; run; ... View more

Re: Remove all the "-" or "_" between the text, and compress the text?

by Rhodochrosite | Level 12 in SAS Programming
‎01-30-2020 08:37 AM
‎01-30-2020 08:37 AM
I got it work, thanks. ... View more

Remove all the "-" or "_" between the text, and compress the text?

by Rhodochrosite | Level 12 in SAS Programming
‎01-29-2020 03:54 PM
‎01-29-2020 03:54 PM
Hi Experts,   I remember there is a SAS function which could remove all the "-" or "_" between the text, and compress the text?  But I forgot which one.   My variable is Charastatic.    Please advice.  Thanks.   ... View more

Re: Simplify Macro - Dates?

by Rhodochrosite | Level 12 in SAS Programming
‎10-02-2019 11:32 AM
‎10-02-2019 11:32 AM
Hi PaigeMiller,   Your codes are shown error too.   19 data _null_; 20 do start_year=2010 to 2016; 21 call symputx(cats('startdate_',year),mdy(7,1,year)); 22 call symputx(cats('enddate_',year),mdy(6,30,year+1)); 23 end; 24 run; NOTE: Variable year is uninitialized. ERROR: Symbolic variable name STARTDATE_. must contain only letters, digits, and underscores. NOTE: Argument 1 to function SYMPUTX('startdate_.',.) at line 21 column 10 is invalid. ERROR: Symbolic variable name ENDDATE_. must contain only letters, digits, and underscores. NOTE: Argument 1 to function SYMPUTX('enddate_.',.) at line 22 column 10 is invalid. ERROR: Symbolic variable name STARTDATE_. must contain only letters, digits, and underscores. NOTE: Argument 1 to function SYMPUTX('startdate_.',.) at line 21 column 10 is invalid. ERROR: Symbolic variable name ENDDATE_. must contain only letters, digits, and underscores. NOTE: Argument 1 to function SYMPUTX('enddate_.',.) at line 22 column 10 is invalid. ERROR: Symbolic variable name STARTDATE_. must contain only letters, digits, and underscores. NOTE: Argument 1 to function SYMPUTX('startdate_.',.) at line 21 column 10 is invalid. ERROR: Symbolic variable name ENDDATE_. must contain only letters, digits, and underscores. NOTE: Argument 1 to function SYMPUTX('enddate_.',.) at line 22 column 10 is invalid. ERROR: Symbolic variable name STARTDATE_. must contain only letters, digits, and underscores. NOTE: Argument 1 to function SYMPUTX('startdate_.',.) at line 21 column 10 is invalid. ERROR: Symbolic variable name ENDDATE_. must contain only letters, digits, and underscores. NOTE: Argument 1 to function SYMPUTX('enddate_.',.) at line 22 column 10 is invalid. ERROR: Symbolic variable name STARTDATE_. must contain only letters, digits, and underscores. NOTE: Argument 1 to function SYMPUTX('startdate_.',.) at line 21 column 10 is invalid. ERROR: Symbolic variable name ENDDATE_. must contain only letters, digits, and underscores. NOTE: Argument 1 to function SYMPUTX('enddate_.',.) at line 22 column 10 is invalid. ERROR: Symbolic variable name STARTDATE_. must contain only letters, digits, and underscores. NOTE: Argument 1 to function SYMPUTX('startdate_.',.) at line 21 column 10 is invalid. ERROR: Symbolic variable name ENDDATE_. must contain only letters, digits, and underscores. NOTE: Argument 1 to function SYMPUTX('enddate_.',.) at line 22 column 10 is invalid. ERROR: Symbolic variable name STARTDATE_. must contain only letters, digits, and underscores. NOTE: Argument 1 to function SYMPUTX('startdate_.',.) at line 21 column 10 is invalid. ERROR: Symbolic variable name ENDDATE_. must contain only letters, digits, and underscores. NOTE: Argument 1 to function SYMPUTX('enddate_.',.) at line 22 column 10 is invalid. start_year=2017 year=. _ERROR_=1 _N_=1 NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 7 at -22:-53 7 at 21:42 7 at 22:40 NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.31 seconds cpu time 0.21 seconds ... View more

Re: Simplify Macro - Dates?

by Rhodochrosite | Level 12 in SAS Programming
‎10-02-2019 11:02 AM
‎10-02-2019 11:02 AM
Hi Tom,   Got error message in Log.   15 %do year=2010 %to 2016; ERROR: The %DO statement is not valid in open code. 16 %let startdate_&year=01JUL&year; WARNING: Apparent symbolic reference YEAR not resolved. ERROR: Symbolic variable name STARTDATE_&YEAR must contain only letters, digits, and underscores. 17 %let enddate_&year=30JUN%eval(&year+1); WARNING: Apparent symbolic reference YEAR not resolved. ERROR: Symbolic variable name ENDDATE_&YEAR must contain only letters, digits, and underscores. 18 %end; ERROR: The %END statement is not valid in open code. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-18-2024 03:24 PM
Likes given to
View All
Quick links