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: 
suztang
‎10-24-2023
  • 9 Posts
  • 3 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: What's the code for the SAS EG import setting that converts variab...

by Fluorite | Level 6 in SAS Studio
‎10-24-2023 05:05 PM
‎10-24-2023 05:05 PM
Yes! Some of the variables do overlap in this way, but not through 32 character places. And that doesn't explain all the fields being selected for the name conversion. This is so weird. ... View more

Re: What's the code for the SAS EG import setting that converts variab...

by Fluorite | Level 6 in SAS Studio
‎10-24-2023 04:31 PM
‎10-24-2023 04:31 PM
Ow. This table goes out to 155 fields. I checked to see if the import was consistent about which fields it converts to Var999, and of course it is NOT consistent! If I close a session, it may change its idea about which variables to convert to Var999 the next time I open it. I can't even tell what length or special character is causing it to  convert like that.   Ugh. ... View more

Re: What's the code for the SAS EG import setting that converts variab...

by Fluorite | Level 6 in SAS Studio
‎10-24-2023 11:42 AM
‎10-24-2023 11:42 AM
Several of them exceed 32 characters (they're questions from a survey form), but in SAS EG, the var name conversion would simply truncate at 32 characters, which is fine. When I do it in SAS Studio, however, the names get replaced with Var999 (where 999 is the number of the variable's field position), and I really hate this because then I have to go back and rename the thing myself.   Also, I want the data import to be compatible with the programs I wrote to analyze them in SAS EG. The fields on the form did not change, just my version of SAS. ... View more

What's the code for the SAS EG import setting that converts variable n...

by Fluorite | Level 6 in SAS Studio
‎10-23-2023 05:17 PM
‎10-23-2023 05:17 PM
Transitioning from SAS EG to SAS ViYa and Studio. In SAS EG, I could check a box during import to convert characters in a var name to make them SAS-compatible. The closest I can get to that in Studio is to use option validvarname=v7, except I don't want my variable names truncated. What's the code to replicate what SAS EG is doing with var names? ... View more

Re: Match Merging

by Fluorite | Level 6 in SAS Programming
‎07-23-2020 08:10 PM
‎07-23-2020 08:10 PM
I see what you're doing with that, and it obviously yielded the right table.   When I run the same code (variable names changed to protect the innocent), a peculiar thing happens: All the values from my second table get erased in the merge. ... View more

Re: Match Merging

by Fluorite | Level 6 in SAS Programming
‎07-23-2020 07:31 PM
‎07-23-2020 07:31 PM
The real common variable isn't actually a Char., it's a Date8., and it's Date8. in both tables. I am perplexed as this is not my first rodeo with merging and concatenating tables. ... View more

Match Merging

by Fluorite | Level 6 in SAS Programming
‎07-23-2020 06:35 PM
‎07-23-2020 06:35 PM
I have two datasets: lifeguards and weather. The lifeguards set is workshift and name day name Sun Alice Sun Bobby Sun Charlie Fri Danny Fri Ellie Sat Fran Sat Gemma The weather set is day and high temp day Temp Sun 39 Mon 35 Tue 36 Wed 36 Thu 40 Fri 38 Sat 39 I want to match merge them so they look like day name Temp Sun Alice 39 Sun Bobby 39 Sun Charlie 39 Mon . 35 Tue . 36 Wed . 36 Thu . 40 Fri Danny 38 Fri Ellie 38 Sat Fran 39 Sat Gemma 39   So I wrote: data want; merge lifeguards weather; by day; run; But I did not get what I want. I got this instead: day name Temp Sun Alice . Sun Bobby . Sun Charlie . Sun . 39 Mon . 35 Tue . 36 Wed . 36 Thu . 40 Fri Danny . Fri Ellie . Fri . 38 Sat Fran . Sat Gemma . Sat . 39   Please help me figure out where I went wrong. I tried it with "in" assignments and using update instead of merge. I don't understand proc sql, so if that's part of your solution, please explain the syntax to me? ... View more

Re: Changing a string in Excel to a datetime, and making SAS retain th...

by Fluorite | Level 6 in SAS Programming
‎05-08-2018 08:02 PM
‎05-08-2018 08:02 PM
I used SAS Enterprise Guide 7.1. The spreadsheet is xlsx from Excel 2013. Using the Process Flow interface, I clicked on [File] --> [Import Data] and followed the steps to import the file that way.   When I did not modify the formats in the dialogue, the data imported, but as strings. When I did try to modify the format, I lost all the data. All the fields were populated with '.' Now I have checked this spreadsheet, and every field that I changed is formatted as a date because I did that manually in Excel. Excel treats it as such. But it seems SAS doesn't recognize the change I made to the table. ... View more

Changing a string in Excel to a datetime, and making SAS retain the fo...

by Fluorite | Level 6 in SAS Programming
‎05-08-2018 07:18 PM
‎05-08-2018 07:18 PM
Hi folks, long time listener, first-time caller.   I have an Excel spreadsheet with some date time fields that were stored as regular text. I used Excel to change the format to date and time (mm/dd/yy hh:mm). Then I imported the sheet into SAS. SAS changed all the fields back to character strings.   How do I get SAS to recognize the fields as date and time and format them as datetime18.? I am using Enterprise Guide.   [UPDATE] Despite wanting to throw my computer out several times, I got it sussed out. The Answer is right: Turns out someone screwed up the spreadsheets, so there were frame shifts and wrong things in the wrong columns. I had to sort through thousands of observations to find the errors. Took forever, but we got it! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-24-2023 08:26 PM
Group Hubs for suztang
View All
Likes given to
View All
Quick links