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

Re: Help! Import .asc file to SAS

by Calcite | Level 5 in SAS Procedures
‎05-14-2014 02:46 PM
‎05-14-2014 02:46 PM
Thank you very much! I think I know how to resolve this problem!:smileylaugh: ... View more

Re: Help! Import .asc file to SAS

by Calcite | Level 5 in SAS Procedures
‎05-14-2014 01:53 PM
‎05-14-2014 01:53 PM
I also tried to open it with Notepad, but it is too large that Notepad cannot open it. Do you mean I cannot import the data file without using the input statement? ... View more

Help! Import .asc file to SAS

by Calcite | Level 5 in SAS Procedures
‎05-14-2014 01:28 PM
‎05-14-2014 01:28 PM
Hello, I received several .asc files, but do not know how to import/read them in sas. I tried to use the code listed below, but since I do not know what variables are in that file, I cannot use "input" statement to rename and define them. data sasdat; infile 'C:\XX\'; run; Log shows: NOTE: The infile 'C:\Core.asc' is:       Filename=C:Core.asc,       RECFM=V,LRECL=256,File Size (bytes)=4061484384,     NOTE: 0 records were read from the infile 'C:Core.asc'. NOTE: The data set sasdat has 1 observations and 0 variables. Any suggestions are appreciated! THANKS! ... View more

Re: row sorting

by Calcite | Level 5 in SAS Procedures
‎10-04-2013 03:37 PM
‎10-04-2013 03:37 PM
Hi Altal, Your codes are very helpful! I still have one question about the equal value, for instance, id=2 the pattern should be 'c_bd' or 'c_db', because b=d=5. Is there an easier way to deal with that? Thanks! ... View more

Re: row sorting

by Calcite | Level 5 in SAS Procedures
‎10-03-2013 05:57 PM
‎10-03-2013 05:57 PM
Hello Altal, Thanks for your answer. It is helpful. The new variable 'pattern' you make indicates the pattern of present/absent. But how to make the 'pattern' variable reflect the order? ... View more

Re: row sorting

by Calcite | Level 5 in SAS Procedures
‎10-03-2013 05:47 PM
‎10-03-2013 05:47 PM
Ballardw, thanks for bring these to my attention! You are absolutely right. I just made this as a simple example. In my real dataset, I have 8 variables and the actual names are 2-4 letters. To make the 'pattern' variable short, I could use numbers to replace the letters, say if pattern is A_B_C then I could use 1_2_3 instead. And for the equal value, if A, B, and C are 1, 1, and 2 respectively, then the pattern could be AB_C. ... View more

row sorting

by Calcite | Level 5 in SAS Procedures
‎10-03-2013 03:09 PM
‎10-03-2013 03:09 PM
Hello all, Could anyone help me to figure out this problem? Thanks in advance! My original dataset is like this: ID A B C 1 2 3 4 2 5 . 3 3 9 5 1 4 5 . . 5 . . . I'd like to create a new variable that indicates the order pattern from the minimum to the maximum. So the new dataset should look like this: ID A B C Pattern 1 2 3 4 A_B_C 2 5 . 3 C_A 3 9 5 1 C_B_A 4 5 . . A 5 . . . . Any suggestion is appreciated! Thanks! ... View more

Re: Array question

by Calcite | Level 5 in SAS Procedures
‎05-17-2013 07:27 PM
‎05-17-2013 07:27 PM
Thanks, Tom! That's helpful. But in my real dataset, some people may have multiple records/observations. The requirement ( a(i)=1 ) may just apply to one of their records. If I use 'delete' function, that will only delete one observation per person. So I think output all the eligible people might be more easier. Any idea how to output those ids? Thanks! ... View more

Array question

by Calcite | Level 5 in SAS Procedures
‎05-17-2013 06:19 PM
‎05-17-2013 06:19 PM
Hello, ID a1 a2 a3 a4 a5 x y 1 1 1 1 0 1 1 3 2 1 0 1 0 1 2 4 3 0 1 0 1 0 3 5 4 1 1 1 1 1 1 5 My dataset looks like this. I created an array for a1-a5. The purpose is to select the records that all the a(i) values are equal to 1 ( i = x to y). I am a new SAS user. Any suggestions would be appreciated. Thanks in advance! ... View more

Re: How to sum selected array variables

by Calcite | Level 5 in SAS Procedures
‎05-04-2013 07:16 PM
‎05-04-2013 07:16 PM
Thank you! It works!! ... View more

How to sum selected array variables

by Calcite | Level 5 in SAS Procedures
‎05-04-2013 05:49 PM
‎05-04-2013 05:49 PM
Header 1 Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7 Header 8 Header 9 Header 10 Header 11 Header 12 Header 13 id cost1 cost2 cost3 cost4 cost5 cost6 cost7 cost8 cost9 cost10 cost11 cost12 end 1 . 0 1 1 4 6 7 2 8 2 8 0 5 2 1 1 . 1 2 2 2 2 3 5 7 6 2 3 0 0 0 0 0 0 0 0 0 0 1 1 10 4 2 2 2 2 2 2 2 2 2 2 2 2 12 My dataset looks like this. Now, I want to add a new column to get the sum of selected "costXX" variables from 1 to the value of end. For example, I should sum up cost1-cost5 for the first row and cost1-cost12 for the last row. The value of costXX variables could be missing. I created an array for these variables: array a(12) cost1-cost12. But the sum function can only be used for sum up all of the array variables, right?  tot = sum(of a{*} ); Any one know how to do this? Thanks! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:12 AM
Quick links