About mlogan

mlogan · ‎03-21-2016

Hi ballardw, by retain I want to rearange the variables (columns).

mlogan · ‎03-21-2016

Hi All, I have the following spreadsheet I want to import. During the import stage I also want to Rename, Retain and Label the column. Is it possible to implement all three functions during the import stage? Thanks ID Name1 Name2 Title1 Title2 1234 Alex Michael 23 New York St. (123) 563-2541 5678 John Jacob 202-74th St. 123-585-4785 3456 Heather-Bin Tornoway 220- 35th Ave. (123)4587458 2345 Megan-Fitzam Hansen 9 Huron st. (123)4587458 ; run; I came up with the following code: proc import datafile="C:\Have.xlsx" dbms=xlsx replace out=Want (RENAME=(ID=St_ID Name1=First_name Name2=Last_name Title1=Address) keep = ID Name1 Name2 Title1); sheet='Sheet1'; run; Expected Output: St_ID First_name Last_name Address 1234 Alex Michael 23 New York St. 5678 John Jacob 202-74th St. 3456 Heather-Bin Tornoway 220- 35th Ave. 2345 Megan-Fitzam Hansen 9 Huron st.

mlogan · ‎03-20-2016

Hi All, I have students record where I have to replace them with proper country code(I have 280 country code), language code(20 language code) and citizenship_status(6 citizenship status). Is 'Format' an efficient way because I have such a long list for country? Can you please tell me what should be the best way to proceed. Thanks, ID Last_Name Country Language Citizenship_status 101 Mike USA English Citizen 102 Solomon Canada French Permanent Resident 103 Husain Alzeria Arabic Refugee Output table will look like this: ID Last_Name Country Language Citizenship_status 101 Mike 234 6 1 102 Solomon 23 8 2 103 Husain 8 1 4

mlogan · ‎03-19-2016

Thanks Xia, It worked for me perfect!!!

mlogan · ‎03-18-2016

Hi Reinhard, Thanks for your help. it worked for me. input ID (Contact_type Contact) (& $20.); actually worked for me and I don't know why, but I learned a second thing(:$20.); whichc(put(left(Contact_Type),$upcase3.), 'HOM', 'MOB', 'CEL') is quite handy. Thank you,

mlogan · ‎03-18-2016

Hi PG, Your code working perfect. Would you please show me the code when there are two variable I am comparing with? I mean flag the observation when: a) 'Current' AND 'Past' exist and b) 'Current' OR 'Past' exist. (using upcase in both cases) Thanks, data have; input ID (Time1 Time2 Time3) ( & $10.); cards; 1234 CURRENT Current Current 5678 Current Current3 Current 3456 Current Past Current 2345 Current CURRENT Current2 ; run;

mlogan · ‎03-18-2016

Hi Xia, your code is very helpful, but it is pointing only to one variable and exact text (CURRENT in this case). Can you please tell me the code for Two variable ('Current' and 'Past' in this case) with UPCASE option? I mean flag it when either Current or Past exist regardless of upper or lower case. Thanks. data have; input ID (Time1 Time2 Time3) ( & $10.); cards; 1234 CURRENT Current Current 5678 Current Current3 Current 3456 Current Past Current 2345 Current CURRENT Current2 ; run; data want1; set have; array x{*} time1-time3; flag='CURRENT' in x; run;

mlogan · ‎03-18-2016

Hi Reeza, Would you please write the first.id for procedure for me. I want the output like: 101 Home 4434323454 102 Mobile 8987609878 103 Cellular 6779998786 Thanks, data have; input ID (Contact_type Contact) ( & $20.); cards; 101 Home 4434323454 101 Mobile 8767876546 102 Mobile 8987609878 102 Email ghg@gmail.com 103 Email aaa@gmail.com 103 Cellular 6779998786 104 Email sss@gmail.com ; RUN Proc format; InValue $ Contact_type_fmt 'Home' = 1 'Mobile' = 2 'Cellular' = 3 'Email'= 4; Proc sql; Create table temp as Select have.*, input(contact_type, $contact_type_fmt.) as priority From have Where not missing(Contact) Order by id, priority; Quit;

mlogan · ‎03-18-2016

Thanks Reinhard, your code works, but it doesn't work when 101 by group don't have an email and 104 has only email (see the following below). I want Home, Mobile and Cellular as priority order. If all are missing, then I don't want that observation (104 in this case). Can you please help further. Thanks, data have; input ID (Contact_type Contact) ( & $20.); cards; 101 Home 4434323454 101 Mobile 8767876546 102 Mobile 8987609878 102 Email ghg@gmail.com 103 Email aaa@gmail.com 103 Cellular 6779998786 104 Email sss@gmail.com ; RUN proc sql; create table want(drop=priority) as select *, whichc(Contact_Type, 'Home', 'Mobile', 'Cellular') as priority from have where not missing(Contact) group by id having priority=min(priority); quit; Folowing is my expected output: 101 Home 4434323454 102 Mobile 8987609878 103 Cellular 6779998786

mlogan · ‎03-17-2016

Hi All, I have the following table with people's contact information. for each by group I have their Home/Mobile/Email and Cellular no. I need to find the observation with contact_type = 'Home'. If the by group don't have a 'Home' contact type then the code will bring the contact_type = 'Mobile', if Mobile is missing then it will bring the contact_type = 'Cellular'. ID Contact_Type Contact 101 Home 4434323454 101 Email abc@gmail.com 101 Mobile 8767876546 102 Mobile 8987609878 102 Email ghg@gmail.com 103 Cellular 6779998786 103 Email aaa@gmail.com Output will look like this: ID Contact_Type Contact 101 Home 4434323454 102 Mobile 8987609878 103 Cellular 6769998786 Can someone help me please. Thanks,

mlogan · ‎03-16-2016

Thanks Xia Keshan. Your code is really helpful.

mlogan · ‎03-15-2016

Hi All, I want to get rid of 'Psy' and 'His - 1' from my table, make all rows left align and get rid of spaces within the value (eg: Eng - 1 should be Eng1). Can someone help me please. Thanks St_ID Course1 Course2 Course3 1234 Math - 1 Psy Eng - 1 5678 Eng - 2 Math - 2 Geo 3456 Psy Eng - 1 Phy 2345 Che - 1 His - 1 Math - 2 Output table should look like this: St_ID Course1 Course2 Course3 1234 Math-1 Eng-1 5678 Eng-2 Math-2 Geo 3456 Eng-1 Phy 2345 Che-1 Math-2

mlogan · ‎03-08-2016

Following code worked! PROC EXPORT DATA=Apple.student_e_c_s_t OUTTABLE='Employees' DBMS=ACCESSCS REPLACE; DATABASE='E:\GW\test.mdb'; run;

mlogan · ‎03-07-2016

Hi All, Is there a way to export SAS 9.4 table to Access .mdb file. I know it is an old format, but need that if anyone can help. I have the following code that works with excel, but I need to know how to export it to .mdb file. proc export outfile="want.xlsx" dbms=xlsx replace data=have; sheet='test'; run; Thanks,

mlogan · ‎02-20-2016

Hi Reeza, Do you mean SAS 9.4 have all the features of SAS Analytics pro plus some additional feature??

Online Status	Offline
Date Last Visited	‎04-10-2025 02:32 PM

Re: Redistributing numbers

Re: Redistributing numbers

Re: Redistributing numbers

Re: Redistributing numbers

Re: Redistributing numbers

Re: Redistributing numbers

Redistributing numbers

Re: How to apply format to all numeric values all at once

How to apply format to all numeric values all at once

Connecting DB2 Database using sas base.

Re: Redistributing numbers

Re: Redistributing numbers

Re: Redistributing numbers

Re: How to apply format to all numeric values all at once

Re: Dynamic Calculations of Variables

Redistributing numbers

Adding an empty row after each by group

csv import with text qualifier

Retrieving Data with REST API

Re: Export SAS 9.4 file to Access .mdb

Re: Retain and Label during Data Import stage

Retain and Label during Data Import stage

Replacing variable with corresponding code

Re: Do loop question

Re: Retrieving data within by group

Re: Do loop question

Re: Do loop question

Re: Retrieving data within by group

Re: Retrieving data within by group

Retrieving data within by group

Re: Removing some variables, left align and space removal

Removing some variables, left align and space removal

Re: Export SAS 9.4 file to Access .mdb

Export SAS 9.4 file to Access .mdb

Re: SAS 9.4 or SAS Analytics Pro