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: 
JaneLi
‎09-01-2015
  • 17 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Read Access Varible into SAS

by Calcite | Level 5 in SAS Procedures
‎02-24-2015 06:51 PM
‎02-24-2015 06:51 PM
my friend said I should use"if" and "substr" to delete the junk value. but I still couldn't figure it out. ... View more

Re: Read Access Varible into SAS

by Calcite | Level 5 in SAS Procedures
‎02-24-2015 06:48 PM
‎02-24-2015 06:48 PM
And I only want to read PersonID, country and city. But in the city column there are always some gender information. I don't know how to deal with these junk values. ... View more

Re: Read Access Varible into SAS

by Calcite | Level 5 in SAS Procedures
‎02-24-2015 06:47 PM
‎02-24-2015 06:47 PM
thie is what my database looks like ... View more

Read Access Varible into SAS

by Calcite | Level 5 in SAS Procedures
‎02-24-2015 04:16 PM
‎02-24-2015 04:16 PM
I am trying to read two variables from my access database and then do SQL.  But there are three variable in my database: personID, country and city. I only need to read two variables personID and city. How SAS only read the first and third column? data PersonDS3 ; Infile Person3 missover firstobs=2; Input PersonID  City & $25. ; Proc SQL; Create table Most_PersonID AS   SELECT city Count(PersonID)AS CountOfPersonID   FROM PersonDS3     GROUP BY city; quit; Proc sort data=Most_PersonID; by Descending CountOfPersonID; ... View more

correlation

by Calcite | Level 5 in SAS Programming
‎02-01-2015 03:21 PM
‎02-01-2015 03:21 PM
Hello, Please help me with the following. I attached the data with this. Create two new variables. One will be the difference in Inflation from last year. The other will be the difference in Inflation with its value 2 years ago. Run a correlation among these three inflations rates.   – Add in a comment what you conclude about these inflation rates.*/ Thanks ... View more

Re: Read only two column from Excel

by Calcite | Level 5 in SAS Enterprise Guide
‎01-21-2015 05:17 PM
‎01-21-2015 05:17 PM
Just to print two columns as a table. I read my data from library Li, I only want to get two columns: PHYSHLTH,TOLDHI2.   And PHYSHLTH >=5, at the same time TOLDHI2=2). Can anyone help me with my code?? My code: libname Li "C:\Users\yl665\downloads"; proc contents data=Li.llcp2011_abridged; run; Data llcp2011_abridged; Set llcp2011;   When (PHYSHLTH >=5 and TOLDHI2=2); RUN; Proc print DATA llcp2011_abridged;run ... View more

Re: Read only two column from Excel

by Calcite | Level 5 in SAS Enterprise Guide
‎01-21-2015 05:12 PM
‎01-21-2015 05:12 PM
I read my data from library 1, I only want to get two columns: PHYSHLTH,TOLDHI2. and PHYSHLTH >=5, at the same time TOLDHI2=2). Can anyone help me with my code?? My code: libname Li "C:\Users\yl665\downloads"; proc contents data=Li.llcp2011_abridged; run; Data llcp2011_abridged; Set llcp2011;   When (PHYSHLTH >=5 and TOLDHI2=2); RUN; Proc print DATA llcp2011_abridged;run ... View more

Read only two column from Excel

by Calcite | Level 5 in SAS Enterprise Guide
‎01-21-2015 05:07 PM
‎01-21-2015 05:07 PM
hey guys, I want to read a excel into SAS and just print two column of the table? I don't know how to do with this? ... View more

Re: Library does not exist

by Calcite | Level 5 in SAS Programming
‎01-20-2015 04:41 PM
‎01-20-2015 04:41 PM
library could only be a folder. try to use your folder. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes given to
View All
Quick links