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: 
Liz_LSU
‎09-08-2016
  • 9 Posts
  • 0 Likes Given
  • 0 Solutions
  • 3 Likes Received

Re: Separating a string value into different variables

by Calcite | Level 5 in SAS Programming
‎04-07-2014 05:13 PM
‎04-07-2014 05:13 PM
Is there any way that you can change the way the raw data are written? The month and the day both need to be two digits. Otherwise, how will you know whether 1122014 is January 12 (1/12) or November 2 (11/2)? A six-digit number is obviously a 1-digit month and 1-digit day and an eight-digit number is obviously a two-digit month and a two-digit year, but a seven-digit date could be a one-digit month and two-digit day or a two-digit month and one-digit day. liz ... View more

Re: SAS DATES

by Calcite | Level 5 in SAS Procedures
‎08-30-2013 09:40 AM
‎08-30-2013 09:40 AM
Robert, Are your dates before January 1, 1960? In SAS, day 0 is January 1, 1960, so any date earlier than that will be a negative number. Use Altal's suggest to format your date variable as a date and you should see it printing as the correct date. Look at it without the format first, then with the format. BTW, you can do this in one step, you don't have to use two! (I teach a SAS programming class and one of my pet peeves is using umpteen steps when one will do.) liz ... View more

Re: Macros and Dates

by Calcite | Level 5 in SAS Programming
‎08-29-2013 10:43 AM
‎08-29-2013 10:43 AM
>> I am trying to keep data for a particular date which can be any date this year or few years ago Are the dates in your data in ONE variable or is there a different variable for EACH DATE (which would be thousands of variables, and a real nightmare!)? From your code, it looks like you are looking at one date at a time, which leads me to believe that perhaps you have one variable and you want to work with all the observations for a particular date. If that's the case, you just need to use a WHERE statement if you have a variable that contains the date. You don't even have to create a subset. proc print data=greatbigdataset;     where transdate = '20AUG2013'd;     var ....; run; If this isn't the case, please post some sample data (if even it's very simplified and not real) so we can see the actual structure of your data set. liz ... View more

Re: SAS DATES

by Calcite | Level 5 in SAS Procedures
‎08-29-2013 10:25 AM
3 Likes
‎08-29-2013 10:25 AM
3 Likes
You can do this in one step by reading the data with an informat: (You didn't say how your data actually look and how you specify an informat is a little different depending on whether you are using list input or column/formatted input.) liz ... View more

EG 4.2: default margin settings for printing datasheet?

by Calcite | Level 5 in SAS Enterprise Guide
‎09-16-2010 02:41 PM
‎09-16-2010 02:41 PM
Is there a way to change the default margin settings for printing a datasheet in EG 4.2? I'm having to print preview, then page setup and reset my margins every time I want to print the datasheet and it's very annoying. I'm testing five different versions of a lab practicum and have to print each data sheet twice (once with a column formatted and once with it not) and I'm still experimenting with different data sets. The default left and right margins are 1", which causes the datasheet to print on two pages even though it fits just fine with the margins set to .25". I've searched the knowledgebase and some of the threads here. It looks like autoexec MIGHT be an option in EG 4.3 (which I've requested). I need a solution that is transparent to the several hundred students that will be using EG in a lab setting. Thanks, liz ... View more

Re: How to Read Comma-Embedded Numbers into Numeric Variable?

by Calcite | Level 5 in SAS Procedures
‎10-08-2009 04:54 PM
‎10-08-2009 04:54 PM
SASLooker, It's not clear from your message where VAR_OLD comes from. Are you reading it in as a character variable? If so, then read it as a numeric variable using the COMMAw.d informat, as Patrick suggested. In your INPUT statement, the code VAR_OLD :COMMA5. will read anything up to four digits, with or without a comma, as a numeric variable. The colon modifier tells SAS to ignore the width (5) and lets you read anything from one- to four-digit numbers. If you don't include the colon modifier and there are numbers less than 1,000, you won't get the expected results for those numbers. If it's in a permanent SAS data set rather than one you are creating when you run your program, never mind! liz ... View more

Re: SAS formats/format library with SQL server data

by Calcite | Level 5 in SAS Programming
‎10-04-2009 08:30 PM
‎10-04-2009 08:30 PM
Al, Thanks for the reply. That definitely sounds like something to investigate. liz ... View more

SAS formats/format library with SQL server data

by Calcite | Level 5 in SAS Programming
‎10-03-2009 08:28 PM
‎10-03-2009 08:28 PM
I'm very familiar with using format libraries and formats with permanent SAS data sets. I may be involved with a very large project in which hundreds of legacy SAS data sets (most of which include permanent user formats) will be converted into SQL tables. I know next to nothing about SQL; others with that expertise will be handling that part of the project. I will be responsible for helping get the data out of SAS and into SQL and then revising the existing programs to work with the data in the new form. In my SAS-centric world, the format library will still exist and each SAS program that analyzes the new SQL data will assign the formats. Is that the best way to handle this, or is there a better way (e.g., a way to assign formats within SQL)? Thanks, liz ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-08-2016 05:15 PM
Likes from
View All
Quick links