topic Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT in SAS Programming

FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

anitapamu2 — Mon, 09 Mar 2015 12:30:25 GMT

data yourdata; format finaltime time12.2; infile cards dlm=','; input age team finaltimec $ score; finaltime = input(finaltimec,?? hhmmss.); drop finaltimec; cards; 20,1,55.49,1 22,1,1:23.57,2 34,1,NA,3 19,2,32.22,4 55,3,5:38.43,5 17,3,12:52.17,6 31,3,25.13,7 ; run;VARAIABLE IT

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

Ksharp — Mon, 09 Mar 2015 13:16:54 GMT

You didn't post the output you need yet.

finaltime = input(finaltimec,?? stimer.);

Xia Keshan

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

Kurt_Bremser — Mon, 09 Mar 2015 13:27:32 GMT

Suppressing error messages and notes with the "??" modifier is NOT, I repeat NOT, helpful in locating problems!

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

anitapamu2 — Mon, 09 Mar 2015 13:45:33 GMT

can you do me small favour

I want finaltime in the format of mm:ss.dd .

above question i have used format time12.2.

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

Ksharp — Tue, 10 Mar 2015 07:47:33 GMT

Instead of it with mmss12.2

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

anitapamu2 — Fri, 13 Mar 2015 15:47:46 GMT

Hi Xia Keshan,

Can you please send Me BASE SAS & ADV SAS NOTES and Doc.which really helpful or 2 to 3 yrs of experience guys.

anitapamu2@yahoo.com

Thanks,

Anita

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

anitapamu2 — Tue, 17 Mar 2015 05:42:06 GMT

Hi ,

we missing the variable called Place.and the place contain '--' that special character should present in the data set along with the variables.

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

anitapamu2 — Tue, 17 Mar 2015 05:54:50 GMT

Hi Xia Keshan,

the datavalues have been missed placed in the data set.

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

anitapamu2 — Tue, 17 Mar 2015 05:57:52 GMT

Hi Xia Keshan,

In the variable Stroke and Points we can see the special character ' [] ' .

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

Ksharp — Tue, 17 Mar 2015 06:43:51 GMT

OK. Here is :

data want;

infile 'c:\temp\MeetResults_SourceData_2.txt' truncover ;

input @;

length Gender age_group Distance course Stroke $ 100;

retain Gender age_group Distance course Stroke;

if prxmatch('/^\w+/',_infile_) then do;

input (Gender age_group Distance course Stroke ) ($);

end;

else if prxmatch('/\w+,/',_infile_) then do;

input places $ 1-4 Name $ 5-28 Age $ 29-33 Team $ 34-61 Finals $ 62-73 Points $ 74-80;

output;

end;

run;

Message was edited by: xia keshan

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

anitapamu2 — Tue, 17 Mar 2015 10:53:09 GMT

Thank you !!

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

anitapamu2 — Wed, 18 Mar 2015 04:34:15 GMT

Hi All,

I have created a small macro to *Converting all character values to uppercase

%macro UPCASE_Var(_a_infile_,_a_outfile_);

data &_a_outfile_.;

set &_a_infile_.;

array Chars

_character_;

do i = 1 to dim(Chars);

Chars = upcase(Chars);

end;

drop i;

run;

%mend;

%UPCASE_Var(sashelp.class,test1234);

But can some help me to write for all SASDATA SET in the Libname

%macro UPCASE_Var(libname);

code here....

%mend;

% UPCASE_Var(libname);

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

Ksharp — Wed, 18 Mar 2015 12:04:56 GMT

No need for Macro .

Here is an example , copying all the tables in SASHELP into WORK library.

filename y temp;
proc cport library=sashelp file=y memtype=data outtype=upcase;run;
proc cimport library=work infile=y;run;

Xia Keshan

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

pallis — Wed, 18 Mar 2015 14:53:37 GMT

(1) if prxmatch('/^\w+/',_infile_) then do;

input (Gender age_group Distance course Stroke ) ($);

end;

(2) else if prxmatch('/\w+,/',_infile_) then do;

input places $ 1-4 Name $ 5-28 Age $ 29-33 Team $ 34-61 Finals $ 62-73 Points $ 74-80;

output;

end;

Please correct my understanding if i'm wrong.

(1) Here you are identifying that first letter(string) starts with character and you are specifying it as character

(2) Here you are mentioning the variables with lengths

what i observed here is is she cresting two different data sets?

Whats she wants i didn't understand she just mentioned that in data set she find special characters [].

I'm totally blank. can you explain please.

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

anitapamu2 — Wed, 18 Mar 2015 18:05:07 GMT

Can we create a macro variable for following text (ram is "very disposition",now we want ,to eat you,right"way is not collected")

%let want = 'ram is "very disposition",now we want ,to eat you,right"way is not collected" ';

%put want ;

ITS NOT WORKING CAN ANYONE HELP ME

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

Ksharp — Thu, 19 Mar 2015 11:12:11 GMT

Sure .

%let want = ram is "very disposition",now we want ,to eat you,right"way is not collected" ;

%put &want ;

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

Ksharp — Thu, 19 Mar 2015 11:21:24 GMT

Here is macro solution .Copy all the table from SASHELP into WORK.

%macro UPCASE_Var(_a_infile_,_a_outfile_);

data &_a_outfile_.;

set &_a_infile_.;

array Chars

_character_;

do i = 1 to dim(Chars);

Chars = upcase(Chars);

end;

drop i;

run;

%mend;

data _null_;

set sashelp.vmember(keep=libname memname memtype where=(libname='SASHELP' and memtype='DATA')) ;

call execute(cats('%UPCASE_Var(',libname,'.',memname,',',memname,')'));

run;

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

Ksharp — Thu, 19 Mar 2015 11:31:43 GMT

"(1) Here you are identifying that first letter(string) starts with character and you are specifying it as character"

Yes. The pattern match the line which starts with a word .

(2) Here you are mentioning the variables with lengths

No. I just match pattern a word plus a comma . or just match a comma only.

else if findc(',',_infile_) then do;

"what i observed here is is she cresting two different data sets?"

No. They all are a table he want.

"Whats she wants i didn't understand she just mentioned that in data set she find special characters []."

That the first code of mine I generated ,didn't post here ,just email him .

you saw a [] ,I think it is a carriage character '0D'x .

Xia Keshan

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

pallis — Thu, 19 Mar 2015 11:50:12 GMT

%let want = 'ram is "very disposition",now we want ,to eat you,right"way is not collected" ';

%put &want. ;