About gobejo

gobejo · ‎11-14-2015

the proc options did not help. i am using SAS University edition. Is there some statement i need to know that will display the options statements in the output?

gobejo · ‎11-13-2015

I entered the following code: options ls=80 date number; proc means data=orion.sales; var Salary; run; options nodate pageno=1; proc freq data=orion.sales; tables Country; run; options ls=95; In the attached file is an example of the problem. I do not see in the options displayed for some reason. WHY? Below is the LOG: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 55 56 options ls=80 date number; 57 58 proc means data=orion.sales; NOTE: Data file ORION.SALES.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. 59 var Salary; 60 run; NOTE: There were 165 observations read from the data set ORION.SALES. NOTE: PROCEDURE MEANS used (Total process time): real time 0.06 seconds cpu time 0.07 seconds 61 62 options nodate pageno=1; 63 64 proc freq data=orion.sales; NOTE: Data file ORION.SALES.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. 65 tables Country; 66 run; NOTE: There were 165 observations read from the data set ORION.SALES. NOTE: PROCEDURE FREQ used (Total process time): real time 0.04 seconds cpu time 0.05 seconds 67 68 options ls=95; 69 70 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 82

gobejo · ‎08-28-2015

Thank you for the isea Mark. But, i was wondering why i do not see SBB in DATA Want

gobejo · ‎08-28-2015

Below is an example of what i am trying to achieve. DATA HAVE; INFILE DATALINES DSD; INPUT A $CHAR50.; DATALINES; June Summary Responses MM Regional Calls ARIZONA APPOINTMENTS Contacts WM AZ APPOINTMENTS Contacts San Diego APPOINTMENTS Contacts LADT APPOINTMENTS Contacts San Gabriel Valley APPOINTMENTS Contacts Orange County+Ontario APPOINTMENTS Contacts Long Beach APPOINTMENTS Contacts SBB Arizona APPOINTMENTS Contacts San Diego APPOINTMENTS Contacts Los Angeles APPOINTMENTS Contacts Long Beach APPOINTMENTS Contacts San Jose APPOINTMENTS Contacts ; RUN; DATA WANT; INFILE DATALINES DSD DLM="|" TRUNCOVER; INPUT A :$CHAR30. B :$CHAR3. C :$CHAR30.; DATALINES; ARIZONA|MM|ARIZONA APPOINTMENTS|MM|ARIZONA Contacts|MM|ARIZONA WM AZ|MM|WM AZ APPOINTMENTS|MM|WM AZ Contacts|MM|WM AZ San Diego|MM|San Diego APPOINTMENTS|MM|San Diego Contacts|MM|San Diego LADT|MM|LADT APPOINTMENTS|MM|LADT Contacts|MM|LADT San Gabriel Valley|MM|San Gabriel Valley APPOINTMENTS|MM|San Gabriel Valley Contacts|MM|San Gabriel Valley Orange County+Ontario|MM|Orange County+Ontario APPOINTMENTS|MM|Orange County+Ontario Contacts|MM|Orange County+Ontario Long Beach|MM|Long Beach APPOINTMENTS|MM|Long Beach Contacts|MM|Long Beach Arizona|SBB|Arizona APPOINTMENTS|SBB|Arizona Contacts|SBB|Arizona San Diego|SBB|San Diego APPOINTMENTS|SBB|San Diego Contacts|SBB|San Diego Los Angeles|SBB|Los Angeles APPOINTMENTS|SBB|Los Angeles Contacts|SBB|Los Angeles Long Beach|SBB|Long Beach APPOINTMENTS|SBB|Long Beach Contacts|SBB|Long Beach ; RUN;

gobejo · ‎08-26-2015

i corrected it...ido not want to delete. I want to create a new observation under a new variable. It still did not work.

gobejo · ‎08-26-2015

Hi, I have the following code: DATA WORK.PASS1 (DROP= G M); SET WORK.TELEMKT; RETAIN MONTH ACTION; IF INDEXW(A,"Summary") THEN MONTH=UPCASE(SUBSTR(A,1,3)); IF G="Total Calls" THEN DELETE; IF G="Total Appointments" THEN DELETE; IF G="Total Contacts" THEN DELETE; IF A=" " AND E=" " THEN DELETE; IF SCAN(A,1)="MM" AND _N_=95 THEN ACTION="Arizona Calls"; RUN; This part of the code: IF SCAN(A,1)="MM" AND _N_=95 THEN DELETE; does not work. The new variable is created, but not the new observation.

gobejo · ‎03-25-2015

Hi I have a variable with different record lengths. I am trying to find out if i can read from the end of the string. Also, If any of the "want" is alphanumeric, then DELETE. I want only US based Zip, not canadian postal code Have Want WARREN MI 48091-3241 48091 BLOOMFIELD MI 48304-2916 48304 SAINT CLAIR SHORES MI 48082-1158 48082 HUNTINGTON WOODS MI 48070 48070 MACOMB MI 48042-2398 48042 HUNTINGTN WDS , MI 480700000 48070

gobejo · ‎03-04-2015

I am looking to see if if the dataset of 1.4 million contains any of 250. So the out put range should be within 1-250. Now when i did an inner join, i get 498.

gobejo · ‎03-04-2015

Hi, I have a dataset with 250 records and a dataset of 1.4 million. I created a key which is a concatenation of lastname, last4digitstaxid and zipcode. How can i find how many of the 250 records are there in 1.4 million and what they are. I have SAS EG. Thanks, Tom

gobejo · ‎03-03-2015

It says the variablesis uninitialized: proc sort data=founders.ucc_count; 26 by duns_number secured_party_name; 27 run; NOTE: There were 291 observations read from the data set FOUNDERS.UCC_COUNT. NOTE: The data set FOUNDERS.UCC_COUNT has 291 observations and 5 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 503.37k OS Memory 16536.00k Timestamp 03/03/2015 10:12:49 AM Step Count 34 Switch Count 31 Page Faults 0 Page Reclaims 60 Page Swaps 0 Voluntary Context Switches 106 Involuntary Context Switches 46 Block Input Operations 0 Block Output Operations 256 28 29 30 31 Data work.ucc_transpose; 32 Retain name_1 dt_1 type_1 name_2 dt_2 type_2 name_3 dt_3 type_3; 33 SET founders.ucc_count; 34 array a(3) $50 name_1 - name_3; 2 The SAS System 08:53 Tuesday, March 3, 2015 35 array b(3) $20 type_1 - type_3; 36 array c(3) dt_1 - dt_3; 37 retain name_1 - name_3 type_1 - type_3 dt_1 - dt_3; 38 by duns_number secured_party_name; 39 if first.duns_number then do; 40 do i = 1 to 3; 41 a(i)=''; 42 b(i)=''; 43 c(i)=.; 44 end; 45 end; 46 a(count)=name; 47 b(count)=type; 48 c(count)=date; 49 format dt1 - dt3 yymmdd10.; 50 label type_1 ='filing type 1' 51 type_2 ='filing type 2' 52 type_3 ='filing type 3' 53 dt_1 ='UCC Date 1' 54 dt_2 ='UCC Date 2' 55 dt_3 ='UCC Date 3'; 56 if last.duns_number; 57 keep id secured_party_name name_1-name_3 type_1-type_3 date_1-date_3; 58 run; NOTE: Variable name is uninitialized. NOTE: Variable type is uninitialized. NOTE: Variable date is uninitialized. NOTE: Variable dt1 is uninitialized. NOTE: Variable dt2 is uninitialized. NOTE: Variable dt3 is uninitialized. Thanks

gobejo · ‎03-03-2015

Hi Arthur, I do not have access to download or install anything. Thanks, Tom

gobejo · ‎03-03-2015

Hi Jag, The requirement changed, and modified the following code you gave me. Data work.ucc_transpose; LENGTH name_1 date_1 type_1 name_2 date_2 type_2 name_3 date_3 type_3; SET founders.ucc_count; array a(3) $50 name_1 - name_3; array b(3) $20 type_1 - type_3; array c(3) date_1 - date_3; retain name_1 - name_3 type_1 - type_3 date_1 - date_3; by duns_number; if first.duns_number then do; do i = 1 to 3; a(i)=''; b(i)=''; c(i)=.; end; end; a(count)=name; b(count)=type; c(count)=date; format dt1 - dt3 yymmdd10.; label type_1 ='filing type 1' type_2 ='filing type 2' type_3 ='filing type 3' date_1 ='UCC Date 1' date_2 ='UCC Date 2' date_3 ='UCC Date 3'; if last.duns_number; keep id secured_party_name name_1-name_3 type_1-type_3 date_1-date_3; run; and this is what the error log showed: Data work.ucc_transpose; 26 LENGTH name_1 dt_1 type_1 name_2 dt_2 type_2 name_3 dt_3 type_3; _ 22 1 1 _ 352 ERROR 22-322: Expecting a numeric constant. ERROR 352-185: The length of numeric variables is 3-8. 27 SET founders.ucc_count; 28 array a(3) $50 name_1 - name_3; 29 array b(3) $20 type_1 - type_3; 30 array c(3) dt_1 - dt_3; 31 retain name_1 - name_3 type_1 - type_3 dt_1 - dt_3; 32 by duns_number secured_party_name; 33 if first.duns_number then do; 34 do i = 1 to 3; 35 a(i)=''; 36 b(i)=''; 37 c(i)=.; 38 end; 39 end; 40 a(count)=name; 41 b(count)=type; 42 c(count)=date; 43 format dt1 - dt3 yymmdd10.; 44 label type_1 ='filing type 1' 45 type_2 ='filing type 2' 2 The SAS System 08:53 Tuesday, March 3, 2015 46 type_3 ='filing type 3' 47 dt_1 ='UCC Date 1' 48 dt_2 ='UCC Date 2' 49 dt_3 ='UCC Date 3'; 50 if last.duns_number; 51 keep id secured_party_name name_1-name_3 type_1-type_3 date_1-date_3; 52 run;

gobejo · ‎03-02-2015

Hi, I have data that looks like this: ID party filing dt count 2115389 bank original 2012-09-13 1 2115389 bank continuation 2011-10-06 2 2115389 bank correction 2008-04-09 3 I want the data to look like this: ID party filing dt filing dt filing dt 2115389 bank original 2012-09-13 continuation 2011-10-06 correction 2008-04-09

gobejo · ‎03-02-2015

Hi Arthur, Just a small change data want; set need; by 'Duns Number'n; if first.'Duns Number'n then Count=0; else Count+1; run; Thanks, Thomas

gobejo · ‎03-02-2015

Hi Arthur, I have an example showing what the output should look like. Thanks, Thomas

Online Status	Offline
Date Last Visited	‎11-14-2015 01:44 PM

Re: options statement do not show on top right corner

options statement do not show on top right corner

Re: Retain Statement

Retain Statement

Re: IF _N_ counter

IF _N_=95 THEN

How to read from end of string?

Re: Matching

Matching

Re: Transpose Data

Re: Parsing

Re: Importing data

Re: options statement do not show on top right corner

options statement do not show on top right corner

Re: Retain Statement

Retain Statement

Re: IF _N_ counter

IF _N_=95 THEN

How to read from end of string?

Re: Matching

Matching

Re: Transpose Data

Re: Transpose Data

Re: Transpose Data

Transpose Data

Re: count

Re: count