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: 
BookmarkSubscribeRSS Feed
Kurt_Bremser
Super User Kurt_Bremser
Super User

Re: Proc sql

Posted 06-11-2018 06:00 AM (516 views)  |   In reply to katkarparam

The proper way of dealing with issues is not starting with the tools. You start with the issue itself, and then select the tool most suited for the task.

So what for would you use this list of 10000 items?

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX
0 Likes
Reply
tomrvincent
Rhodochrosite | Level 12 tomrvincent
Rhodochrosite | Level 12

Re: Proc sql

Posted 06-13-2018 08:07 AM (486 views)  |   In reply to Kurt_Bremser
10,000 records. Only 37 values.
0 Likes
Reply
katkarparam
Fluorite | Level 6 katkarparam
Fluorite | Level 6

Re: Proc sql

Posted 06-28-2018 05:48 AM (449 views)  |   In reply to tomrvincent
yaa
0 Likes
Reply
ChrisBrooks
Ammonite | Level 13 ChrisBrooks
Ammonite | Level 13

Re: Proc sql

Posted 06-11-2018 06:15 AM (509 views)  |   In reply to katkarparam

There’s a nice introduction to the subject here https://support.sas.com/resources/papers/proceedings15/3024-2015.pdf 

0 Likes
Reply
katkarparam
Fluorite | Level 6 katkarparam
Fluorite | Level 6

Re: Proc sql

Posted 06-12-2018 01:27 AM (498 views)  |   In reply to ChrisBrooks
thank you.. I will refer it
0 Likes
Reply
tomrvincent
Rhodochrosite | Level 12 tomrvincent
Rhodochrosite | Level 12

Re: Proc sql

Posted 06-11-2018 08:50 AM (503 views)  |   In reply to katkarparam
How many distinct state values are there in your dataset?
0 Likes
Reply
katkarparam
Fluorite | Level 6 katkarparam
Fluorite | Level 6

Re: Proc sql

Posted 06-12-2018 01:26 AM (498 views)  |   In reply to tomrvincent
for this dataset I have 37 distinct values.
0 Likes
Reply

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Watch How to Concatenate Values on YouTube

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 21 replies
  • ‎06-08-2018 07:49 AM
  • 1886 views
  • 2 likes
  • 5 in conversation