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: 
RTelang
  • 190 Posts
  • 1 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: checking missing date

by Fluorite | Level 6 in SAS Procedures
‎02-05-2016 06:05 AM
‎02-05-2016 06:05 AM
@RW9 can i use ur first code logic against my new inputs -Jan-1975 --1977 02--1978 03-Jan- ?? can we change the if the conditions or the substr condition..? ... View more

Re: checking missing date

by Fluorite | Level 6 in SAS Procedures
‎02-05-2016 05:48 AM
‎02-05-2016 05:48 AM
-Jan-1975 --1977 02--1978 03-Jan- this are the dates i have. so for example --1977 so its converted date format is 05-jan-1977 ... View more

Re: checking missing date

by Fluorite | Level 6 in SAS Procedures
‎02-05-2016 05:39 AM
‎02-05-2016 05:39 AM
for example see this 01-Jan-1975 05-jan-1977 02-jan-1978 03-Jan-0000 this is the actual format the dash is between day-month-year u get it so in the 2 & 3 card line its '--' '--' ... View more

Re: checking missing date

by Fluorite | Level 6 in SAS Procedures
‎02-05-2016 02:26 AM
‎02-05-2016 02:26 AM
@RW9here my input datastep data have; input birthdate $; cards; -Jan-1975 --1977 02--1978 03-Jan- run; & its log birthdate 1 -Jan-197 2 --1977 3 02--1978 ... View more

Re: checking missing date

by Fluorite | Level 6 in SAS Procedures
‎02-05-2016 02:21 AM
‎02-05-2016 02:21 AM
@ rw9 here's my log with the code & errors... 57 data have; 58 input birthdate $; 59 cards; NOTE: The data set WORK.HAVE has 4 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.02 seconds 64 run; 65 66 data want; 67 set have; 68 day=substr(birthdate,1,2); 69 month=substr(birthdate,5,7); 70 year=substr(birthdate,8,6); 71 if day="-" then day="01"; 72 if month="--" then month="JAN"; 73 if year="-" then year="0000"; 74 converted_date=input(cats(day,month,year),date9.); 75 format converted_date date9.; 76 run; NOTE: Invalid third argument to function SUBSTR at line 69 column 9. NOTE: Invalid third argument to function SUBSTR at line 70 column 8. NOTE: Invalid argument to function INPUT at line 74 column 18. birthdate=-Jan-197 day=-J month=-197 year=7 converted_date=. _ERROR_=1 _N_=1 NOTE: Invalid third argument to function SUBSTR at line 69 column 9. NOTE: Invalid third argument to function SUBSTR at line 70 column 8. NOTE: Invalid argument to function INPUT at line 74 column 18. birthdate=--1977 day=-- month=77 year= converted_date=. _ERROR_=1 _N_=2 NOTE: Invalid third argument to function SUBSTR at line 69 column 9. NOTE: Invalid third argument to function SUBSTR at line 70 column 8. NOTE: Invalid argument to function INPUT at line 74 column 18. birthdate=02--1978 day=02 month=1978 year=8 converted_date=. _ERROR_=1 _N_=3 NOTE: Invalid third argument to function SUBSTR at line 69 column 9. NOTE: Invalid third argument to function SUBSTR at line 70 column 8. NOTE: Invalid argument to function INPUT at line 74 column 18. birthdate=03-Jan- day=03 month=an- year= converted_date=. _ERROR_=1 _N_=4 NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to missing values. Each place is given by: (Number of times) at (Line):(Column). 4 at 74:18 NOTE: There were 4 observations read from the data set WORK.HAVE. NOTE: The data set WORK.WANT has 4 observations and 5 variables. ... View more

Re: checking missing date

by Fluorite | Level 6 in SAS Procedures
‎02-05-2016 12:31 AM
‎02-05-2016 12:31 AM
@RW9 am using a input dataset have still there error exist ... View more

Re: checking missing date

by Fluorite | Level 6 in SAS Procedures
‎02-04-2016 06:11 AM
‎02-04-2016 06:11 AM
hello RW9 here my 4 inputs are having missing day month year & day month.. so u say i create a data set with my inputs & then use ur logic & can i use it as macro.. ... View more

checking missing date

by Fluorite | Level 6 in SAS Procedures
‎02-04-2016 05:30 AM
‎02-04-2016 05:30 AM
here am writing d code to check missing day month year from the input below  & display the correct format according to the given values below. my input dates are  -MMM-YYYY  --YYYY  DD--YYYY  DD-MMM-  the values to display according to the coressponding input value in the output are--> -MMM-YYYY = 01-MMM-YYYY --YYYY = 01-JAN-YYYY DD--YYYY = DD-JAN-YYYY DD-MMM- = DD-MMM-0000     here is my code to take string & display it but it gives a missing output what can i do to read the input then see wats missing then display the respective outputs   data date; str ='-jan-1988'; date1= input(str,anydtdte11.); format date1 mmddyyd10. run;   ... View more

Re: help cipher can't create

by Fluorite | Level 6 in SAS Procedures
‎01-22-2016 01:36 AM
‎01-22-2016 01:36 AM
here is my macro to send mail through sas but above mentioned error arises cipher can't be created... what changes can i do to remove the error. %macro Frm_send_email(TO=,FROM=,SUBJECT=,ATTACHMENT=,BODY=); %if &to ne %then %let TO="&TO"; %if &from ne %then %let from=FROM="&FROM"; %IF &SUBJECT ne %THEN %LET subject=SUBJECT="&SUBJECT"; %IF &ATTACHMENT ne %THEN %LET attachment=ATTACHMENT="&ATTACHMENT"; %IF &BODY ne %THEN %LET BODY="&BODY"; options emailhost=( "smtp.gmail.com" port=465 SSL auth=plain id="sample@gmail.com" pw="***********" ); FILENAME outbox EMAIL &TO &FROM &SUBJECT &ATTACHMENT; DATA _NULL_; FILE outbox; PUT &BODY; RUN; %MEND Frm_send_email; options mlogic mprint symbolgen; %Frm_send_email(TO=sample.com,FROM=sample@gmail.com,SUBJECT=details,ATTACHMENT=,BODY=here is it take a look); ... View more

Re: help cipher can't create

by Fluorite | Level 6 in SAS Procedures
‎01-21-2016 04:05 PM
‎01-21-2016 04:05 PM
FILENAME outbox EMAIL ("***********"); DATA _NULL_; FILE outbox TO=("************") FROM=("***********") SUBJECT=("Example of a SAS E-mail" ); PUT " "; PUT "Hello Boss,"; PUT " "; PUT "Attached are the Daily Operational Reports."; PUT " "; PUT "uu"; RUN; ... View more

Re: help cipher can't create

by Fluorite | Level 6 in SAS Procedures
‎01-21-2016 03:34 PM
‎01-21-2016 03:34 PM
Email host FILENAME not found. i get this error if i remove email hostname option... ... View more

Re: help cipher can't create

by Fluorite | Level 6 in SAS Procedures
‎01-21-2016 03:30 PM
‎01-21-2016 03:30 PM
i have created this macro to send mail with the parameters. can u correct d error ? ... View more

help cipher can't create

by Fluorite | Level 6 in SAS Procedures
‎01-21-2016 03:16 PM
‎01-21-2016 03:16 PM
here is my code to send mail but a error arises please help to solve it.   1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 55 56 %macro Frm_send_email(TO=,FROM=,SUBJECT=,ATTACHMENT=,BODY=); 57 %if &to ne %then 58 %let TO="&TO"; 59 60 %if &from ne %then 61 %let from=FROM="&FROM"; 62 63 %IF &SUBJECT ne %THEN 64 %LET subject=SUBJECT="&SUBJECT"; 65 66 %IF &ATTACHMENT ne %THEN 67 %LET attachment=ATTACHMENT="&ATTACHMENT"; 68 69 %IF &BODY ne %THEN 70 %LET BODY="&BODY"; 71 options emailhost= 72 ( 73 "smtp.gmail.com" port=465 74 SSL auth=plain 75 id="sample@gmail.com" 76 pw="***********" ); 77 78 FILENAME outbox EMAIL &TO &FROM &SUBJECT &ATTACHMENT; 79 80 DATA _NULL_; 81 FILE outbox; 82 PUT &BODY; 83 RUN; 84 85 %MEND Frm_send_email; 86 /* options mlogic mprint symbolgen; */ 87 %Frm_send_email(TO=sample.com,FROM=sample@gmail.com,SUBJECT=details,ATTACHMENT=,BODY=here is it take a 87 ! look);   NOTE: The file OUTBOX is: E-Mail Access Device   ERROR: Unable to create cipher.   NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.03 seconds     88 89 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 101 ... View more

Re: debug delete sas environment

by Fluorite | Level 6 in SAS Procedures
‎01-18-2016 05:20 AM
‎01-18-2016 05:20 AM
k so u suggest i apply lib & file clear statements to my macro & it will work fine so i remove the proc sql step... ... View more

Re: debug delete sas environment

by Fluorite | Level 6 in SAS Procedures
‎01-18-2016 05:11 AM
‎01-18-2016 05:11 AM
k but i need macro so am doing it. i know simple libnme clear is k but i need macro for bigger amt of data ... View more
Contact Me
Likes given to
View All
Likes from
View All
Quick links