BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
FreelanceReinh
Jade | Level 19

@Cruise wrote:

@novinosrin

the data HAVE is posted in my original post. It has in total around 900 ZIP codes. that's it. not a large data. 


Well, 1449 to be more precise (see my PROC FREQ output).

 

(I assume that the table of ZIP code categories with columns PUP, VAT, CAT and OTHER [and a ridiculous number of empty cells due to unequal sizes of the four categories] is in fact a spreadsheet, not a SAS dataset.)

 

novinosrin
Tourmaline | Level 20

@Cruise  Just noticed the other thread creating your raw data to sas datasets. If you have separate datasets, choose the solution suggested by @FreelanceReinh  for this req. 

 

in1 and in2 the concat indsname (Hint)

How to Concatenate Values

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

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 16 replies
  • 4274 views
  • 10 likes
  • 4 in conversation