About sleretrano

LinusH · ‎01-16-2017

Nothing fancy just like: Create table want as Select have.* From have Inner join state_lookup On have.initial_state = state_lookup.state Order by state_lookup.state_order ;

Ksharp · ‎10-29-2016

Read it as character , Can it work ? Input Var1-Var35 @350 Var36 : $20.; If it was worked, then your termstr= is not right, try others like termstr=nl. Or your file is stream file (not have row-end character),then you need other input method like: Input Var1-Var35 @350 Var36 @@;

sleretrano · ‎10-28-2016

Yes, it worked. I've always heard spaces are a bad idea, but I've never had an issue with them, to be honest.

sleretrano · ‎09-07-2016

It did work, thanks. I hadn't thought of trying the most simple thing.

sleretrano · ‎07-29-2016

I didn't post the output because I don't really care what the output looks like. What matters to me is the join condition. This seems to do what I want. Thank you very much.

ChrisHemedinger · ‎07-26-2016

This was a bug in EG 5.1 -- the keyboard shortcut to go to the END was broken. It's been fixed in version 7.11/7.12.

sleretrano · ‎07-21-2016

You're right. The fact that you can't create the template before selecting the variables led me to think the variables were part of the template. Thank you very much.

sleretrano · ‎07-21-2016

I thought I had replied, I just noticed I didn't. Thank you for this lesson.

RW9 · ‎07-13-2016

Just to add, Comma Separated Variable files - whilst officially documented as a standard - is widely used around the world for data transfer. If you open a CSV in Excel it will automatically populate values into columns for instance. The : is used in different ways for different applications, and so could be confusing. Its fine if its just within your company, unless anyone new joins, but going outside... https://en.wikipedia.org/wiki/Comma-separated_values

sleretrano · ‎05-20-2016

OK, got it. It's just ORD=_n_ I didn't know about this. I'm trying to make your second option work at the moment.

sleretrano · ‎04-13-2016

Thank you. I'm new to SAS, I don't know the standard terminology yet. This was helpful.

Online Status	Offline
Date Last Visited	‎01-18-2017 05:35 AM

Re: Ordering with respect to a custom order

Ordering with respect to a custom order

Re: Trouble reading the last variable from a colon delimited

Re: Trouble reading the last variable from a colon delimited

Re: Trouble reading the last variable from a colon delimited

Re: Trouble reading the last variable from a colon delimited

Re: Trouble reading the last variable from a colon delimited

Trouble reading the last variable from a colon delimited

Re: Reading from Unix

Re: Reading from Unix

Re: Changing default options on Describe>Summary Statistics

Re: Display variable properly (BESTw.d)

Re: Reading from Unix

Re: Changing default options on Describe>Summary Statistics

Re: Ordering with respect to a custom order

Re: Trouble reading the last variable from a colon delimited

Re: Reading from Unix

Re: Turn macro variable into a number

Re: More efficient way of proc sql joining ON a disjunction

Re: Keyboard shortcut - moving cursor from 'DO' to 'END'

Re: Changing default options on Describe>Summary Statistics

Re: Defining macro variable by cases

Re: Importation crops last variable for no apparent reason

Re: Use data from another table

Re: Display variable properly (BESTw.d)