About alex_philby

Kurt_Bremser · ‎08-29-2018

proc transpose is one of the most useful tools to beat data into easily usable form. It allows you to have code that needs no explicit variable names where those are undetermined.

Astounding · ‎07-19-2018

If your data set holding the counts is named COUNTS, you would just need to sort and subset: proc sort data=counts; by occupation employer descending count qualification; run; data want; set counts; by occupation employer descending count qualification; if first.count; run;

Kurt_Bremser · ‎05-30-2018

Try this: data have; input felony $50.; cards; drugs consumer drugs seller drugs trafficker murder in the first degree murder in the second degree sex offender sex worker ; run; data have1; set have; first_word = scan(felony,1); run; data want; set have1; by first_word; /* add nostsorted if necessary */ if first.first_word then rank = 1; else rank + 1; run;

alex_philby · ‎01-10-2018

This one too is working with small data tables, but makes my SAS session crash when I try to run it on the 1mil+ observations tables. Sorry everyone, I guess it's just a memory problem. I can run simple data step on the mentionned tables, but your programs makes my session crash, for some reason.

Astounding · ‎12-21-2017

To understand the purpose of that DO group, consider this sentence: it makes it difficult Without that code, both of these pairs would be output: it makes (the first and second words) makes it (the second and third words) Sorting with NODUPKEY would still fail to remove either of them. So that DO group switches the value of WORD1 and WORD2, and makes WORD1 the word that alphabetizes first (and WORD2 the word that alphabetizes second). So the result comes out as: it makes it makes Then NODUPKEY finds the duplicates and removes one.

Online Status	Offline
Date Last Visited	‎10-29-2020 09:14 PM

Re: how to get values from a different table without merging ?

how to get values from a different table without merging ?

Re: Produce and count modes of combinations of variables

Re: Produce and count modes of combinations of variables

Produce and count modes of combinations of variables

attributing a rank to each modality starting with same word

Re: count occurences of specific words in a separate table

Re: count occurences of specific words in a separate table

Re: count occurences of specific words in a separate table

Re: count occurences of specific words in a separate table

Re: how to get values from a different table without merging ?

Re: how to get values from a different table without merging ?

Re: attributing a rank to each modality starting with same word

Re: count occurences of specific words in a separate table

Re: count occurences of specific words in a separate table

Re: how to get values from a different table without merging ?

Re: Produce and count modes of combinations of variables

Re: attributing a rank to each modality starting with same word

Re: count occurences of specific words in a separate table

Re: count occurences of multiple words