Proc sql - Page 2

Kurt_Bremser · Posted 06-11-2018 06:00 AM

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

tomrvincent · Posted 06-13-2018 08:07 AM

10,000 records. Only 37 values.

katkarparam · Posted 06-28-2018 05:48 AM

yaa

ChrisBrooks · Posted 06-11-2018 06:15 AM

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

katkarparam · Posted 06-12-2018 01:27 AM

thank you.. I will refer it

tomrvincent · Posted 06-11-2018 08:50 AM

How many distinct state values are there in your dataset?

katkarparam · Posted 06-12-2018 01:26 AM

for this dataset I have 37 distinct values.

Re: Proc sql

Re: Proc sql

Re: Proc sql

Re: Proc sql

Re: Proc sql

Re: Proc sql

Re: Proc sql

Re: Proc sql

Re: Proc sql

Re: Proc sql

Re: Proc sql

Re: Proc sql

Re: Proc sql

Re: Proc sql

The 2025 SAS Hackathon has begun!

SAS Training: Just a Click Away